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

Active Server Pages, 4.7

ActiveX, 4.7

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

ALTER TYPE statement, 4.8.5.4, 8.3.8

See also object types, evolving

ANYDATA data type, 8.5, 9.12.2

ANYDATASET data type, 8.5

ANYTYPE data type, 8.5

arrays, A.3.6

size of VARRAYs, 5.1.4

ASP, 4.7

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.9

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.4.1

calling user-defined, 8.4.6

literal invocation, 2.2.3

literal invocation of, 2.2.3

methods, 2.2.3

overloading, 8.4.4

overriding, 8.4.4

system defined, 8.4.1

type evolution, 8.4.2

user-defined, 8.4.3, 8.4.4

with NEW keyword, 8.4.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.12.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

nested tables, 5.1.5

See also object types

transient and generic, 8.5

database administrators (DBAs)

DBA role, 7.1.1

database links

and object types

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.10.1

dynamic method dispatch, 2.3.6, 3.3

dynamic SQL, 3.4

---

E

equal and not equal conditions

nested tables, 5.3.4

equipartitioning

nested tables, 5.4

evolution

object types, 1.3.1.10

versus inheritance, 9.12.1

Excel, 4.7

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.10.1

Export utility

object types, 4.10.1

EXTERNAL NAME phrase, 4.8.5

---

F

features

new, Preface

files

Export and Import dump file, 4.10.1

FINAL keyword, 2.3.2

modifying finality, 8.3.6, 9.10.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

guidelines

comparison methods, 2.2.1.2.3

---

I

implicit dereferencing, 1.3.1.6.3, A.3.2.2

import object types, 4.10.1

Import utility

object types, 4.10.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 table (IOT), 5.2.1

index-organized tables

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.12.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 (index-organized tables), 5.2.1, 9.4.4.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.8.5

Oracle JDBC and Oracle objects, 4.8.1

Oracle SQLJ and Oracle objects, 4.8.2

with Oracle objects, 4.8

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.7, 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.8.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

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.7, 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 tables, 1.3.1.4, 9.1.1.2, A.3.3

constraints, 2.1.3

deleting values, A.3.6.5

indexes, 2.1.4

inserting values, A.3.6.3

querying, A.3.6.4

replicating, 9.8

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.12.1

design considerations, 9.10

SQLJ types, 4.8.5.4

example of privileges, 7.1.4

Export and Import, 4.10.1

final, 9.10.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.10.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, 6.11

row objects and object identifiers, 6.6

schema privileges, 7.1.2

See also type inheritance

specializing

SQLJ types, 4.8.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.10

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.12.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.8

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.9

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.8

replication, 9.8

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

Oracle C++ Call Interface, 4.6

Oracle Data Provider for .NET, 1.3.2

Oracle JDBC

accessing Oracle object data, 4.8.1

Oracle objects

See object-relational model

Oracle Objects for OLE

OraCollection interface, 4.7.3

OraObject interface, 4.7.1

OraRef interface, 4.7.2

support of object-relational features, 4.7

Oracle SQLJ

creating custom Java classes, 4.8.4.1

data mapping for Oracle objects, 4.8.3

JPublisher, 4.8.4.1

support for Oracle objects, 4.8.2

Oracle type translator (OTT), 4.5.4

OraCollection interface, 4.7.3

ORAData interface, 4.8.5.1

OraObject interface, 4.7.1

OraRef interface, 4.7.2

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.4.4

overriding

methods, 2.3.3

user-defined constructors, 8.4.4

overriding methods, 2.3.5

---

P

parallel query

objects, 9.11

restrictions for Oracle objects, 9.11

view objects, 9.11

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.12.2, 9.12.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.8

---

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

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.8.5.1

SQLJ

See Oracle SQL

SQLJ object types, 4.8, 9.12.4.1

creating, 4.8.5.2

mapping Java classes, 4.8.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

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.12.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.12.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.5

SYS.ANYDATASET, 8.5

SYS.ANYTYPE, 8.5

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

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.4

type dependencies, 7.2.5

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.6

user-defined constructors, 8.4.3, 8.4.4

user-defined data types

See also user-defined types

See object types

user-defined types

and remote databases

See also object-relational model

See object types

USING clause, 4.8.5

utilities supporting objects, 4.10

---

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

Visual Basic, 4.7

---

W

widening

and substitutability, 2.3.15.1

---

X

XMLType, 5.1.4