Index

A  B  C  D  E  F  G  I  J  K  L  M  N  O  P  Q  R  S  T  U  V  W  X 

A

ADMIN OPTION
with EXECUTE ANY TYPE, 7.1.3
aggregate functions
See user-defined aggregate functions
aliases
required for tables, 2.1.7.1
ALTER ANY TYPE privilege, 7.1.1
See also privileges
ALTER TABLE, 8.3.9
See also object types, evolving
storing XMLTypes and LOBs, 8.4
ALTER TYPE statement, 4.7.5.4, 8.3.8
See also object types, evolving
ANYDATA column
Storing XMLTypes and LOBs in, 8.4
ANYDATA data type, 8.6, 9.13.2
ANYDATA types, 8.4
ANYDATASET data type, 8.6
ANYTYPE data type, 8.6
arrays, A.3.6
size of VARRAYs, 5.1.4
assignments
across object types, 2.3.15
collections, 2.3.15.3
objects and REFs to objects, 2.3.15.1
atomic nulls, 2.1.1
object types in PL/SQL, 3.1.3
attribute value constructor, 2.2.3
attributes
leaf-level, 2.1.4, 8.1.1
modifying, 8.3.6
of object types, 1.3.1.1

B

bind variables
object types, 4.3
BULK COLLECT clause, 5.3.3

C

caches
object cache, 4.4, 4.5, 6.3, 7.1.5
object views, 6.3
capture avoidance rule, 2.1.7.1
CARDINALITY function, 5.3.5.1
CAST function, 2.4.1
character length semantics
object types, 2.1.2
COLLECT function, 5.3.5.2
collections
assigning, 2.3.15.3
assignments, 5.2
constructing, 1.3.1.7
constructor methods, 5.1.3
creating, 5.1.2
data types
DML on, 5.3.2
multilevel, 5.2, 9.4.1
constructing, 5.2.3
creating, 5.2.3
creating with REFs, 9.4.5
object views containing, 6.6.2
nested tables, 5.1.5
querying, 5.3.1, 9.4.1
See also varrays, nested tables
substitutable elements, 2.3.8.4
substituting
supported data types, 1.3.1.7
variable arrays (VARRAYs), 5.1.4
column objects, 1.3.1.4
indexes on, 2.1.4
versus row objects, 9.1.1
COLUMN_VALUE keyword, 5.2.1
columns
column objects, 1.3.1.4
hidden, 8.1.3, 8.2.1
qualifying in queries, 2.1.7
comparisons
methods, 2.2.1.2, A.3.1, A.3.6.4
nested tables, 5.3.4
compilation
of object types, 7.2.1
complete types, A.3.1
COMPRESS clause
nested tables, 9.4.4.1
constraints, A.3.4
object tables, 2.1.3
on Oracle objects, 9.10
REFs, 9.3.2
SCOPE FOR constraint, A.3.6.2
constructor methods, 5.1.3
constructors, 1.3.1.3, 2.2.3, 8.1.2
attribute values, 8.5.1
calling user-defined, 8.5.6
literal invocation, 2.2.3
literal invocation of, 2.2.3
methods, 2.2.3
overloading, 8.5.4
overriding, 8.5.4
system defined, 8.5.1
type evolution, 8.5.2
user-defined, 8.5.3, 8.5.4
with NEW keyword, 8.5.1
COUNT attribute of collection types, A.3.2.2
CREATE INDEX statement
object types, 2.1.4
CREATE OR REPLACE TYPE Table Dependencies, 7.2.4
CREATE OR REPLACE TYPE with FORCE option, 7.2.4
CREATE OR REPLACE TYPE with Type Dependencies, 7.2.4
CREATE TABLE statement
column object example, 1.3.1.2
object table example, 1.3.1.4, 2.1.3
CREATE TRIGGER statement
object table example, 2.1.5
CREATE TYPE privilege, 7.1.1
See also privileges
CREATE TYPE statement, 9.13.4.5
collection types, 1.3.1.7
dependent types, 7.2.1
example, 5.1.5
nested tables, 5.1.5
object types, 1.3.1.1, 1.3.1.1, A.3.1
varrays, 5.1.4, A.3.1
creating object types, 1.3.1.1
creating VARRAYs
containing references to LOBs, 5.1.8
CURSOR expression, 2.4.2

D

dangling REFs, 1.3.1.6.2, 1.3.1.6.3
data types
array types, 5.1.4
generic, 8.6
nested tables, 5.1.5
object types, 2.1.8
opaque, 8.6
transient, 8.6
database administrators (DBAs)
DBA role, 7.1.1
database links
and object types, 2.1.8
DBA role
user-defined types, 7.1.1
declarations
object in a PL/SQL block, 3.1.2
declaring objects in PL/SQL, 3.1
DEFAULT clause, 5.1.3
default values
collections, 5.1.3
object types, 5.1.3
DELETE privilege
for object tables, 7.1.5, 7.1.5
DEREF function, 2.4.3, 3.2.4
dereferencing, 1.3.1.6.3, A.3.2.2
implicit, 1.3.1.6.3, A.3.2.2
dot notation, 2.1.7
for object attributes in PL/SQL, 3.2.1
for object methods in PL/SQL, 3.2.2
using with methods, 2.2.1
DROP ANY TYPE privilege, 7.1.1
See also privileges
DROP TYPE statement
FORCE option, 7.2.6
dump files
Export and Import, 4.9.1
dynamic method dispatch, 2.3.6, 3.3
dynamic SQL, 3.4

E

editions
views
equal and not equal conditions
nested tables, 5.3.4
equipartitioning
nested tables
partitioning, 5.4
evolution
object types, 1.3.1.10
versus inheritance, 9.13.1
EXECUTE ANY TYPE privilege, 7.1.1, 7.1.3
See also privileges
EXECUTE privilege
object types, 7.1.3
See also privileges
executing SQL statements at run time, 3.4
export object types, 4.9.1
Export utility
object types, 4.9.1
EXTERNAL NAME phrase, 4.7.5

F

files
Export and Import dump file, 4.9.1
FINAL keyword, 2.3.2
modifying finality, 8.3.6, 9.11.3
FORCE keyword, 6.12.2
foreign keys
representing many-to-one entity relationship with, A.2.2.2
function-based indexes
on type methods, 9.5.4

G

generalized expression, 2.3.3.3
generalized method invocation, 2.3.3.3
generic data type, 8.6
generic programming, 8.6
guidelines
comparison methods, 2.2.1.2.3

I

implicit dereferencing, 1.3.1.6.3, A.3.2.2
import object types, 4.9.1
Import utility
object types, 4.9.1
importing object tables, 4.9.1
IN condition, 5.3.4.2
incomplete object types, 7.2.1
incomplete types, A.3.1
indexes
nested table, 5.1.5.1
object types, 2.1.4
on REFs, 2.1.4
type-discriminant column, 8.2.1
index-organized tables, 5.2.1
storing nested tables as, 5.2.1, 9.4.4.1
inheritance, 1.3.1.9
and overloading, 3.3
multiple
See type inheritance
single
versus evolution, 9.13.1
inheriting methods, 2.3.5
initializing objects in PL/SQL, 3.1
inner capture, 2.1.7.1
INSERT privilege
for object tables, 7.1.5, 7.1.5
instances
object type, 1.3.1.1
objects, 1.3.1.2
INSTANTIABLE keyword
CREATE TYPE, 2.3.4
modifying instantiability, 8.3.6
INSTEAD OF triggers
nested tables, 6.10.1
invoker-rights
object types, 9.6
invoking constructors, 2.2.3
IOTs
See index-based tables, 5.2.1
IS A SET condition, 5.3.4.6
IS EMPTY condition, 5.3.4.5
IS NOT A SET condition, 5.3.4.6
IS OF type predicate, 2.4.4

J

Java
object storage, 4.7.5
Oracle JDBC and Oracle objects, 4.7.1
Oracle SQLJ and Oracle objects, 4.7.2
with Oracle objects, 4.7
JDBC
See Oracle JDBC

K

keys
foreign keys, A.2.2.2

L

leaf-level attributes, 2.1.4, 8.1.1
scalar, 8.1.1
left correlation, 5.3.1.2
literal invocation of a method, 2.2.3.3
locators
returning nested tables as, 8.8, 9.4.4.3, 9.4.4.3.1, A.3.6.2
using a hint, 9.4.4.3.2
locks
object level locking, 4.4

M

managing
object types, 7
map methods, 9.2, A.3.1, A.3.6.4
comparing collections, 5.3.4.1
for comparing objects, 2.2.1.2.1
materialized views, 1.3.1.8, 9.9.2
MEMBER condition, 5.3.4.4
member methods, 1.3.1.3, 2.2.1
member procedures
with SELF IN OUT NOCOPY, 9.5.3
methods, 2.2.3, A.3.2
choosing a language for, 9.5.1
comparison, A.3.1, A.3.6.4
comparison methods, 2.2.1.2
in a type hierarchy, 2.2.1.2.4
constructor, 1.3.1.3
constructors, 1.3.1.3, 2.2.3, 8.1.2
dot notation, 2.2.1
dropping, 8.3.6
dynamic method dispatch, 2.3.6
execution privilege for, 7.1.2
final, 2.3.2
function-based indexes, 9.5.4
guidelines for comparison, 2.2.1.2.3
inheriting, 2.3.5
instantiability, 2.3.4
invoking, 2.2.1
map, 2.2.1.2.1, 9.2, A.3.1, A.3.6.4
map for comparing objects, 2.2.1.2.1
map required for collections, 5.3.4.1
member, 1.3.1.3, 2.2.1
object types, 1.3.1.3, 2.2
order, 2.2.1.2.2, 9.2, A.3.1, A.3.2.3
overloading, 2.3.3, 2.3.5, 2.3.5.1
overriding, 2.3.2, 2.3.3, 2.3.5, 2.3.5.2
PL/SQL, 4.3
redefining, 2.3.5.2
restrictions on overriding, 2.3.5.3
SELF parameter, 2.2.1.1
static, 1.3.1.3, 2.2.2, 9.5.2
modify_opaque_type clause, 8.4
multilevel collections
See collections, multilevel
varray storage, 5.2.2
multiple inheritance
multiple subtypes, 2.3.3.4
MULTISET EXCEPT operator, 5.3.5.3
MULTISET INTERSECT operator, 5.3.5.4
multiset operations
with nested tables, 5.3.5
MULTISET UNION operator, 5.3.5.5

N

name resolution
object types, 2.1.7
narrowing, 2.3.15.2, 2.4.8
nested cursor, A.3.6.4
nested tables, 9.4.4
adding to an object, 8.3.5
comparing, 5.3.4
COMPRESS clause, 9.4.4.1
creating, 5.1.2
creating indexes on, 9.4.4.2
equal and not equal conditions, 5.3.4
in an index-organized table, 5.2.1, 9.4.4.1
indexes, 5.1.5.1
INSTEAD OF triggers, 6.10.1
locators, 8.8, 9.4.4.3
multiset operations, 5.3.5
piecewise operations, 5.3.2.2
querying, 5.3.1, A.3.1
unnesting results, 5.3.1.2
returning as locators, 9.4.4.3, 9.4.4.3.1, A.3.6.2
specifying a storage name, 8.3.5
specifying storage in a tablespace, 5.1.5.2
storage, 5.2.1, 9.4.4.1, A.3.6.2
uniqueness in, A.3.6.2
updating in views, 6.10.1
versus varrays, A.3.1, A.3.1
NESTED_TABLE_GET_REFS hint, 9.4.4.3.2
NESTED_TABLE_ID, 5.2.1
NESTED_TABLE_ID keyword, 5.2.1, 9.4.4.2, A.3.6.2
.NET object extensions, 1.3.2
.NET stored procedures, 1.3.2
NEW keyword, 2.2.3
NLS_LENGTH_SEMANTICS initialization parameter, 2.1.2
NOCOPY compiler hint
methods, 2.2.1.1
performance issues, 9.5.3
use with member procedures, 9.5.3
use with SELF, 2.2.1.1, 9.5.3
NOT FINAL keyword, 2.3.2
NOT MEMBER condition, 5.3.4.4
nulls
atomic, 2.1.1
object types, 2.1.1

O

object cache
object views, 6.3
OCI, 4.4
privileges, 7.1.5
Pro*C, 4.5
object constructors
calling in PL/SQL, 3.2.2
passing parameters to in PL/SQL, 3.2.2
object identifier, 1.3.1.5, 6.2
object identifiers, A.3.5
column and index, 9.1.1.2
for object types, 8.1.2
primary-key based, 9.1.2.2
REFs, 9.1.2
storage, 9.1.2
system-generated, 9.1.2.1
object instances, 1.3.1.1, 1.3.1.2
object methods
calling in PL/SQL, 3.2.2
object replication
using logical standby, 9.8
object tables, 1.3.1.4, 9.1.1.2, A.3.3
constraints, 2.1.3
deleting values, A.3.6.5
importing, 4.9.1
indexes, 2.1.4
inserting values, A.3.6.3
querying, A.3.6.4
replicating, 9.9
row objects, 1.3.1.4
triggers, 2.1.5
virtual object tables, 6.1
object types, 1.1
adding a nested table attribute, 8.3.5
advantages, 1.2
altering a type, 8.3.5
assignments across, 2.3.15
attributes of, 1.3.1.1
character length semantics, 2.1.2
collection objects, 6.6
collections, 5.1
nested tables, 5.1.5
variable arrays (VARRAYs), 5.1.4
column objects, 1.3.1.4
column objects versus row objects, 9.1.1
comparison methods for, 2.2.1.2, A.3.1, A.3.6.4
constructor methods, 1.3.1.3, 8.1.2
constructor methods for, 2.2.3
creating, 1.3.1.1
creating subtypes of, 2.3.3.2
database key features, 1.3.1
declaring in a PL/SQL block, 3.1.2
dependencies, 7.2
dependents, 7.2.1, 8.3
evolution, 1.3.1.10
evolving, 8.3, 9.13.1
design considerations, 9.11
SQLJ types, 4.7.5.4
example of privileges, 7.1.4
Export and Import, 4.9.1
final, 9.11.3
FINAL or NOT FINAL, 2.3.2
in columns, 6.4
incomplete, 7.2, 7.2.1, 7.2.2
indexes on column objects, 2.1.4
indexing, 8.2.1
inheritance, 1.3.1.9, 2.3
initializing in PL/SQL, 3.1.3
instances, 1.3.1.1
instantiable, 2.3.4
invoker-rights, 9.6
key features, 1.3
locking in cache, 4.4
managing, 7
methods, 2.2, 2.2.1, A.3.2
methods in PL/SQL, 4.3
mutually dependent, 7.2.1
name resolution, 2.1.7
nested tables, 5.1.5
not final, 9.11.3
not instantiable, 2.3.4
nulls, 2.1.1
object references, 6.8
Oracle type translator, 4.5.4
performance tuning, 7.4
privileges, 7.1, 7.1.1
recompiling, 7.2.3
remote access to, 2.1.8, 6.11
row objects and object identifiers, 6.6
schema privileges, 7.1.2
See also type inheritance
specializing
SQLJ types, 4.7.5
storage, 8.1
substituting, 2.3.7
subtypes, 2.3.1
synonyms, 7.3
table aliases, 2.1.7.1
triggers, 2.1.5
use of table aliases, 2.1.7.1
utilities, 4.9
variable arrays (VARRAYs), 5.1.4
views, 1.3.1.8
object views, 1.3.1.8, 6
advantages of, 6.1
circular references, 6.12.1
defining REFs
for rows of object views, 6.2
hierarchies, 6.13, 9.13.3
privileges, 6.13.3
querying in, 6.13.2
modeling relationships, 6.9, 6.12
multilevel collections in, 6.6.2
nested tables, 6.10.1
null objects in, 6.5
OIDs with, 6.7
REFs to, 6.8
replicating, 9.9
updating through INSTEAD OF triggers, 6.10
OBJECT_ID pseudocolumn, 2.3.8.1
OBJECT_VALUE pseudocolumn, 2.3.8.1
object-relational model, A
advantages, 1.2
comparing objects, 9.2
constraints, 9.10
database key features, 1.3.1
design considerations, 9
embedded objects, A.3.6
key features, 1.3
methods, 1.3.1.3, 2.2
programmatic environments for, 4, 4.7
replication, 9.9
OCCI, 4.6
OCI
associative access, 4.4.1
for Oracle objects
building a program, 4.4.4
navigational access, 4.4.2
object cache, 4.4.3
OCIObjectFlush, 6.3
OCIObjectPin, 6.3
ODP.NET, Oracle Developer Tools for Visual Studio, 1.3.2
ODT, Microsoft common language, 1.3.2
OIDs, 9.1.2
See object identifiers
opaque data type, 8.6
opaque types and ANYDATA, 8.4
Oracle C++ Call Interface, 4.6
Oracle Data Provider for .NET, 1.3.2
Oracle JDBC
accessing Oracle object data, 4.7.1
Oracle objects
See object-relational model
Oracle SQLJ
creating custom Java classes, 4.7.4.1
data mapping for Oracle objects, 4.7.3
JPublisher, 4.7.4.1
support for Oracle objects, 4.7.2
Oracle type translator (OTT), 4.5.4
ORAData interface, 4.7.5.1
order methods, 2.2.1.2.2, 9.2, A.3.1, A.3.2.3
ORGANIZATION INDEX clause, 5.2.1
OTT, 4.5.4
outer-join syntax, 5.3.1.2, 5.3.1.4
overloading, 2.3.5
and inheritance, 3.3
methods, 2.3.3, 2.3.5.1
user-defined constructors, 8.5.4
overriding
methods, 2.3.3
user-defined constructors, 8.5.4
overriding methods, 2.3.5

P

parallel query
objects, 9.12
restrictions for Oracle objects, 9.12
view objects, 9.12
partitioning, 5.4
tables containing Oracle object, 5.4
piecewise operations on multilevel nested tables, 5.3.2.2
pkREFs, 8.1.5
PL/SQL
bind variables
object types, 4.3
object views, 6.3
using with objects, 1.3.1.3
polymorphism, 1.3.1.8, 9.13.2, 9.13.3
See also substitutability
POWERMULTISET function, 5.3.5.6
POWERMULTISET_BY_CARDINALITY function, 5.3.5.7
pragma RESTRICT_REFERENCES, A.3.1
primary-key-based REFs, 8.1.5
privileges
acquired by role on object types, 7.1.1
ALTER ANY TYPE on object types, 7.1.1
checked when pinning object types, 7.1.5
column level for object tables, 7.1.5
DELETE on object types, 7.1.5
DROP ANY TYPE on object types, 7.1.1
EXECUTE ANY TYPE on object types, 7.1.1, 7.1.3
EXECUTE ANY TYPE on object types with ADMIN OPTION, 7.1.3
EXECUTE on object types, 7.1.3
INSERT on object types, 7.1.5
object types in types or tables, 7.1.3
object types with CREATE TYPE, 7.1.1
object types with DELETE, 7.1.5
object types with INSERT, 7.1.5
object types with UPDATE, 7.1.5
on object types, 7.1, 7.1.1
SELECT on object types, 7.1.5
system on object types, 7.1.1
UNDER ANY TYPE on object types, 7.1.1
UNDER ANY VIEW on object types, 7.1.1
UPDATE on object types, 7.1.5, 7.1.5
Pro*C
embedded SQL with user-defined data types, 4.5
object cache, 4.5
Pro*C/C++
associative access, 4.5.1
converting between Oracle and C types, 4.5.3
navigational access, 4.5.2
user-defined data types, 4.4
programmatic environments
for Oracle objects, 4, 4.7

Q

queries
set membership, 9.4.4.4
unnesting, 9.4.1
varrays, 9.4.3

R

recompilation
object types, 7.2.3
redefining
methods, 2.3.5.2
REF attributes, 2.1.6
REF columns, 2.1.6
REF function, 2.4.5
manipulating objects in PL/SQL, 3.2.4
references, 1.3.1.6
references See REFs
REFs, 1.3.1.6
comparing, 1.3.1.6.5
constraints on, 2.1.6, 9.3.2
constructing from object identifiers, 8.1.2, A.3.6.3
dangling, 1.3.1.6.2, 1.3.1.6.3, 2.1.6
dereferencing, 3.2.4
dereferencing of, 1.3.1.6.3, A.3.2.2
implicit dereferencing of, 1.3.1.6.3, A.3.2.2
indexes on, 2.1.4
indexing, 9.3.3.1
object identifiers
obtaining, 1.3.1.6.4
pinning, 6.3, 7.1.5
scoped, 1.3.1.6.1, 2.1.6, 8.1.5, 9.3.3
size of, 8.1.5
storage, 9.3.1
substitutability, 2.3.8.3
substitutability in
use of table aliases, 2.1.7.1
WITH ROWID option, 9.3.4
remote databases
using with object types, 2.1.8
RESOURCE role
user-defined types, 7.1.1
return entire result sets
BULK COLLECT, 5.3.3
roles
DBA role, 7.1.1
RESOURCE role, 7.1.1
row objects
storage, 9.1.1.2
running examples in this guide, 1.3.1.1

S

sample schemas, hr sample schema, hr schema, sample schemas
hr, examples in this guide, 1.3.1.1
sample schemas, hr schema, Preface
schemas
object data types, 4.3
object types
qualifying column names, 2.1.7.1
SCOPE FOR constraint, A.3.6.2
scoped REFs, 1.3.1.6.1, 8.1.5
See also dereferencing, 2.4.3, 3.2.4
SELECT privilege
for object tables, 7.1.5
SELF parameter
methods, 2.2.1.1
SET function, 5.3.5.8
single inheritance
SQL
support for object types, 4.1
user-defined data types, 4.1
OCI, 4.4
SQLData interface, 4.7.5.1
SQLJ
See Oracle SQL
SQLJ object types, 4.7, 9.13.4.1
creating, 4.7.5.2
mapping Java classes, 4.7.5.3
See also object types, Oracle SQLJ
static dispatch, 2.3.3.3
static methods, 1.3.1.3, 2.2.2
storage, 9.1.2
column objects, 9.1.1.1
nested tables, 8.1.6
object tables, 8.1
REFs, 8.1.5
STORE AS clause, A.3.6.2
storing nested tables, 5.1.5.1
Storing XMLTypes and LOBs in an ANYDATA column, 8.4
SUBMULTISET condition, 5.3.4.3
subprograms
overloading and inheritance, 3.3
roles with invoker’s rights, 9.7
substitutability, 2.3.7
attributes
collections
column and row, 2.3.8, 8.2.1
constraining, 2.3.12
dependencies, 7.2.5
modifying, 2.3.13
narrowing, 2.3.15.2
OBJECT_ID, 2.3.8.1
OBJECT_VALUE, 2.3.8.1
restrictions on modifying, 2.3.14
turning off, 2.3.11
views, 2.3.8
views and, 9.13.3
widening, 2.3.15.1
substitutability of object types
with overloading, 3.3
substitutable columns
dropping subtypes, 2.3.10
subtypes
creating, 2.3.3
dropping in substitutable columns, 2.3.10
hierarchy
indexing attributes of, 8.2.2
multiple, 2.3.3.4
object types, 2.3.1
specializing, 9.13.1
with supertype attribute, 2.3.8.2
supertypes
attribute of subtype, 2.3.8.2
base in hierarchy
synonyms
object types, 7.3
SYS_TYPEID function, 2.4.6, 8.2.1
SYS.ANYDATA, 8.6
SYS.ANYDATASET, 8.6
SYS.ANYTYPE, 8.6
system privileges
ADMIN OPTION, 7.1.3
object types, 7.1.1
See also privileges

T

TABLE
function, 2.4.7
Table Dependencies, 7.2.4
TABLE expression, 5.1.5, 5.3.1.3
TABLE expression subqueries
restrictions, 5.3.1.2
TABLE expressions, 5.3.1.2, 9.4.1
tables
aliases, 2.1.7.1
constraints on object tables, 2.1.3
functions, 2.4.7
indexes on nested tables, 2.1.4
nested tables, 5.1.5
object
See object tables
object tables, 1.3.1.4
virtual, 6.1
qualifying column names, 2.1.7, 2.1.7.1
transient data type, 8.6
TREAT function, 2.3.8, 2.3.15.2, 2.4.4, 2.4.8, 8.2.2
triggers
INSTEAD OF triggers
object views and
object types, 2.1.5
type dependencies, 7.2.5
Type Dependencies, 7.2.4
type evolution, 1.3.1.10
See object types
type hierarchies
methods in, 2.2.1.2.4
type inheritance
finality, 2.3.2
instantiability, 2.3.4
methods, 2.3.5
object types
See inheritance
specializing subtypes, 2.3.1
typeids, 2.4.6, 8.2.1
types
See data types, object types

U

UNDER ANY TYPE privilege, 7.1.1
See also privileges
UNDER ANY VIEW privilege, 7.1.1
See also privileges
UNDER keyword
CREATE TYPE, 2.3.3
uninitialized object
how treated in PL/SQL, 3.1.3
unnesting queries, 9.4.1
unnesting queries to collections, 5.3.1.3
unnesting queries with multilevel collections, 5.3.1.4
UPDATE privilege
for object tables, 7.1.5, 7.1.5, 7.1.5
updates
object views, 6.10
UPGRADE..STORE AS, 8.3.5
user-defined aggregate functions, 8.7
user-defined constructors, 8.5.3, 8.5.4
user-defined data types, 1.1
See object types
user-defined types
and remote databases, 2.1.8
object-relational model, A
USING clause, 4.7.5
utilities supporting objects, 4.9

V

validation
failure, 8.3.7
object types, 8.3.6
VALUE function, 2.4.9, 3.2.2
variables
bind variables
object types, 4.3
object variables, 6.3
varrays, 5.1.4
accessing, 9.4.3
creating, 5.1.2
creating VARRAYs, 5.1.8
increasing the number of elements, 5.1.7
querying, 9.4.3
See also arrays, collections
storage, 5.2.2, 9.4.2
updating, 9.4.3
versus nested tables, A.3.1, A.3.1
views
object, 1.3.1.8
See also object views
substitutability, 2.3.8
updatability, 6.10

W

widening
and substitutability, 2.3.15.1

X

XML, 4.8
XMLType, 5.1.4
XMLType views, 4.8
XMLTypes and LOBs in an ANYDATA column, 8.4