Index

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

A

Active Server Pages, 4.6

ActiveX, 4.6

ADMIN OPTION

with EXECUTE ANY TYPE, 6.1.3

aggregate functions

See user-defined aggregate functions

ALTER ANY TYPE privilege, 6.1.1

See also privileges

ALTER TABLE, 7.3.6

See also object types, evolving

ALTER TYPE statement, 4.7.5.4, 7.3.5

See also object types, evolving

ANYDATA datatype, 7.4, 8.11.2

ANYDATASET datatype, 7.4

ANYTYPE datatype, 7.4

arrays, 9.3.6

size of VARRAYs, 3.1.3

variable (VARRAYs), 3.1.3

ASP, 4.6

atomic nulls, 2.1.1

attributes

leaf-level, 7.1.1

leaf-level scalar, 7.1.1

modifying, 7.3.3

of object types, 1.3.1.1

B

bind variables

user-defined types, 4.2

C

caches

object cache, 4.3, 4.4, 5.3, 6.1.5

object views, 5.3

capture avoidance rule, 2.1.7.1

CARDINALITY function, 3.2.4.1

CAST function, 2.4.1

COLLECT function, 3.2.4.2

collections

assigning, 2.3.15.2

comparing, 3.1.10.2, 3.2.3

constructing, 1.3.1.10

creating, 3.1.1

datatypes

DML on, 3.2.2

multilevel, 3.1.10, 8.4.1

constructing, 3.1.10.3

creating, 3.1.10.3

creating with REFs, 8.4.5

DML, 3.2.2.1

object views containing, 5.6.2

nested tables, 3.1.4

querying, 3.2.1, 8.4.1

See also varrays, nested tables

substituting in, 2.3.7

supported datatypes, 1.3.1.10

variable arrays (VARRAYs), 3.1.3

column objects

versus row objects, 8.1.1

COLUMN_VALUE keyword, 3.1.10.1

columns

column objects, 1.3.1.7

hidden, 7.1.3, 7.2.1

indexes on column objects, 2.1.4

qualifying in queries, 2.1.7

qualifying names in queries, 2.1.7.1

comparison methods, 9.3.1, 9.3.6.4

comparisons

collections, 3.2.3

methods, 2.2.2

compilation of object types, 6.2

COMPRESS clause

nested tables, 8.4.4.1

CONNECT role

user-defined types, 6.1.1, 6.1.4

constraints, 9.3.4

object tables, 2.1.3

on Oracle objects, 8.8

REFs, 8.3.2

SCOPE FOR constraint, 9.3.6.2

constructor methods, 1.3.1.3, 2.2.4, 7.1.2

literal invocation of, 2.2.4

constructors

methods, 2.2.4

user-defined, 7.3.9, 7.3.10

COUNT attribute of collection types, 9.3.2.2

CREATE ANY TYPE privilege, 6.1.1

See also privileges

CREATE INDEX statement

object types, 2.1.4

CREATE TABLE statement

examples

column objects, 1.3.1.2

object tables, 1.3.1.6, 2.1.3

CREATE TRIGGER statement

examples

object tables, 2.1.5

CREATE TYPE privilege, 6.1.1

See also privileges

CREATE TYPE statement, 8.11.4.5

collection types, 1.3.1.10

example, 3.1.4

incomplete types, 6.2

nested tables, 2.2.4, 3.1.4

object types, 1.3.1.1, 1.3.1.2, 2.1.1, 2.2.4, 9.3.1

varrays, 3.1.3, 9.3.1

creating VARRAYs

containing references to LOBs, 3.1.9

CURSOR expression, 2.4.2

D

dangling REFs, 1.3.1.9, 1.3.1.9

database administrators (DBAs)

DBA role, 6.1.1

database links, 2.1.8

datatypes

array types, 3.1.3

nested tables, 3.1.4

See also object types, user-defined types

transient and generic, 7.4

DBA role

user-defined types, 6.1.1

default values

collections, 3.1.2

user-defined types, 3.1.2

DELETE privilege for object tables, 6.1.5, 6.1.5

DEREF function, 2.4.3

dereferencing, 1.3.1.9, 9.3.2.2

implicit, 1.3.1.9, 9.3.2.2

dot notation, 2.2.1

DROP ANY TYPE privilege, 6.1.1

See also privileges

DROP TYPE statement, 6.2.3.1

dump files

Export and Import, 6.6

E

equal and not equal conditions

nested tables, 3.2.3.1

Excel, 4.6

EXECUTE ANY TYPE privilege, 6.1.1, 6.1.3

See also privileges

EXECUTE privilege

user-defined types, 6.1.3

See also privileges

Export utility

user-defined types, 6.6

EXTERNAL NAME phrase, 4.7.5

F

files

Export and Import dump file, 6.6

FINAL keyword, 2.3.2

modifying finality, 7.3.3, 8.9.3

FORCE keyword, 5.12.2

FORCE option, 6.2.3.1

foreign keys

representing many-to-one entity relationship with, 9.2.2.2

function-based indexes

on type methods, 8.5.4

G

GRANT option for EXECUTE privilege, 6.1.3

granting

execute user-defined type, 6.1.3

I

implicit dereferencing, 1.3.1.9, 9.3.2.2

Import utility

user-defined types, 6.6

IN condition, 3.2.3.2

incomplete object types, 6.2

indexes

on REFs, 2.1.4

type-discriminant column, 7.2.1

user-defined types, 2.1.4

index-organized tables

storing nested tables as, 3.1.10.1, 8.4.4.1

inheritance, 1.3.1.4

See type inheritance

inner capture, 2.1.7.1

INSERT privilege for object tables, 6.1.5, 6.1.5

INSTANTIABLE keyword, 2.3.4

modifying instantiability, 7.3.3

INSTEAD OF triggers

nested tables, 5.10.1

invoker-rights

object types, 8.6

IS A SET condition, 3.2.3.6

IS EMPTY condition, 3.2.3.5

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

JPublisher, 4.7.4

K

keys

foreign keys, 9.2.2.2

L

leaf-level attributes, 7.1.1

scalar, 7.1.1

literal invocation

constructor methods, 2.2.4

locators

returning nested tables as, 7.6.1, 8.4.4.3, 8.4.4.3, 9.3.6.2

using a hint, 8.4.4.3

locks

object level locking, 4.3

M

managing

object types, 6

map methods, 2.2.2.1, 8.2, 9.3.1, 9.3.6.4

comparing collections, 3.2.3.1

for comparing objects, 2.2.2.1

materialized views, 8.7.2

MEMBER condition, 3.2.3.4

methods, 1.3.1.3, 2.2, 9.3.2

choosing a language for, 8.5.1

comparison, 9.3.1

comparison methods, 2.2.2

in a type hierarchy, 2.2.2.4

constructor methods, 2.2.4, 7.1.2

literal invocation, 2.2.4

dropping, 7.3.3

dynamic method dispatch, 2.3.6

execution privilege for, 6.1.2

final, 2.3.2

function-based indexes, 8.5.4

inheriting, 2.3.5

instantiability, 2.3.4

invoking, 2.2.1

map, 2.2.2.1, 8.2, 9.3.1

map for comparing objects, 2.2.2.1

map required for collections, 3.2.3.1

member, 2.2.1

of object types, 1.3.1.1

order, 2.2.2.2, 8.2, 9.3.1, 9.3.2.3

overloading, 2.3.5

overriding, 2.3.2, 2.3.5, 2.3.5.2

PL/SQL, 4.2

SELF parameter, 2.2.1

static, 2.2.3, 8.5.2

methods, comparison, 9.3.6.4

methods, map, 9.3.6.4

multilevel collections

See collections, multilevel

MULTISET EXCEPT operator, 3.2.4.3

MULTISET INTERSECT operator, 3.2.4.4

multiset operations

with nested tables, 3.2.4

MULTISET UNION operator, 3.2.4.5

N

narrowing, 2.3.15.1, 2.4.8

nested cursor, 9.3.6.4

nested tables, 3.1.4, 8.4.4

COMPRESS clause, 8.4.4.1

creating, 3.1.1

creating indexes on, 8.4.4.2

equal and not equal conditions, 3.2.3.1

in an index-organized table, 3.1.10.1, 8.4.4.1

indexes, 2.1.4

INSTEAD OF triggers, 5.10.1

multiset operations, 3.2.4

querying, 3.2.1, 9.3.1

unnesting results, 3.2.1.2

returning as locators, 8.4.4.3, 8.4.4.3, 9.3.6.2

specifying storage in a tablespace, 3.1.5

storage, 3.1.10.1, 8.4.4.1, 9.3.6.2

uniqueness in, 9.3.6.2

updating in views, 5.10.1

versus VARRAY, 9.3.1

vs varrays, 9.3.1

NESTED_TABLE_GET_REFS hint, 8.4.4.3

NESTED_TABLE_ID keyword, 3.1.10.1, 8.4.4.2, 9.3.6.2

NLS_LENGTH_SEMANTICS initialization parameter, 2.1.2

NOCOPY compiler hint, 2.2.1

performance issues, 8.5.3

NOT MEMBER condition, 3.2.3.4

nulls

atomic, 2.1.1

object types, 2.1.1

O

object cache

object views, 5.3

OCI, 4.3

privileges, 6.1.5

Pro*C, 4.4

object identifiers, 1.3.1.6, 1.3.1.6, 8.1.2, 9.3.5

column and index, 8.1.1.2

for object types, 7.1.2

primary-key based, 8.1.2.1

REFs, 8.1.2

storage, 8.1.2

object instances, 1.3.1.1, 1.3.1.2

comparing, 2.3.16.1

object tables, 1.3.1.6, 8.1.1.2, 9.3.3

constraints, 2.1.3

deleting values, 9.3.6.5

indexes, 2.1.4

inserting values, 9.3.6.3

querying, 9.3.6.4

replicating, 8.7

row objects, 1.3.1.7

triggers, 2.1.5

virtual object tables, 5.1

object types, 1.1

assignments across, 2.3.15

attributes of, 1.3.1.1

column objects, 1.3.1.7

column objects versus row objects, 8.1.1

comparison methods for, 2.2.2, 9.3.1

constructor methods for, 2.2.4, 7.1.2

creating, 1.3.1.2

creating subtypes of, 2.3.3

dependents, 6.2, 7.3

evolving, 7.3, 8.11.1

design considerations, 8.9

SQLJ types, 4.7.5.4

FINAL or NOT FINAL, 2.3.2

final/not final, 8.9.3

incomplete, 6.2, 6.2.1

indexes on column objects, 2.1.4

indexing, 7.2.1

instantiable/not instantiable, 2.3.4

invoker-rights, 8.6

locking in cache, 4.3

managing, 6

methods of, 1.3.1.1, 9.3.2

PL/SQL, 4.2

mutually dependent, 6.2

Oracle type translator, 4.4.4

remote access to, 2.1.8, 5.11

row objects, 1.3.1.7

See also type inheritance

specializing, 1.3.1.4

SQLJ types, 4.7.5

substituting, 2.3.7

use of table aliases, 2.1.7.1

object types, comparison methods for, 9.3.6.4

object views, 5

advantages of, 5.1

circular references, 5.12.1

defining, 5.2

hierarchies, 5.13, 8.11.3

privileges, 5.13.3

querying in, 5.13.2

modeling relationships, 5.9, 5.12

multilevel collections in, 5.6.2

nested tables, 5.10.1

null objects in, 5.5

OIDs with, 5.7

REFs to, 5.8

replicating, 8.7

updating through INSTEAD OF triggers, 5.10

OBJECT_ID pseudocolumn, 2.3.8.1

OBJECT_VALUE pseudocolumn, 2.3.8.1

object-relational model, 9

comparing objects, 8.2

constraints, 8.8

design considerations, 8

embedded objects, 9.3.6

limitations of relational model, 1.2

methods, 1.3.1.3, 2.2

partitioning, 7.6

programmatic environments for, 4, 4.7

replication, 8.7

objects

collection objects, 5.6

comparing, 2.3.16.1

in columns, 5.4

object references, 5.8

row objects and object identifiers, 5.6

OCCI, 4.5

OCI

associative access, 4.3.1

for Oracle objects

building a program, 4.3.4

navigational access, 4.3.2

object cache, 4.3.3

OCIObjectFlush, 5.3

OCIObjectPin, 5.3

OIDs, 1.3.1.6

See object identifiers

Oracle JDBC

accessing Oracle object data, 4.7.1

Oracle objects

See object-relational model

Oracle Objects for OLE

OraCollection interface, 4.6.3

OraObject interface, 4.6.1

OraRef interface, 4.6.2

support of object-relational features, 4.6

Oracle SQLJ

creating custom Java classes, 4.7.4

JPublisher, 4.7.4

support for Oracle objects, 4.7.2

Oracle type translator (OTT), 4.4.4

OraCollection interface, 4.6.3

ORAData interface, 4.7.5.1

OraObject interface, 4.6.1

OraRef interface, 4.6.2

order methods, 2.2.2.2, 8.2, 9.3.1, 9.3.2.3

OTT, 4.4.4

P

parallel query

objects, 8.10

restrictions for Oracle objects, 8.10

view objects, 8.10

partitioning

tables containing Oracle objects, 7.6

pkREFs, 7.1.5

PL/SQL

bind variables

user-defined types, 4.2

object views, 5.3

polymorphism, 2.3, 8.11.2, 8.11.3

See also substitutability

POWERMULTISET function, 3.2.4.6

POWERMULTISET_BY_CARDINALITY function, 3.2.4.7

pragma RESTRICT_REFERENCES, 9.3.1

primary-key-based REFs, 7.1.5

privileges

system

user-defined types, 6.1.1

user-defined types

acquired by role, 6.1.1

ALTER ANY TYPE, 6.1.1

checked when pinning, 6.1.5

column level for object tables, 6.1.5

CREATE ANY TYPE, 6.1.1

CREATE TYPE, 6.1.1

DELETE, 6.1.5, 6.1.5

DROP ANY TYPE, 6.1.1

EXECUTE, 6.1.3

EXECUTE ANY TYPE, 6.1.1, 6.1.3

EXECUTE ANY TYPE with ADMIN OPTION, 6.1.3

EXECUTE with GRANT option, 6.1.3

INSERT, 6.1.5, 6.1.5

SELECT, 6.1.5, 6.1.5

system privileges, 6.1.1

UPDATE, 6.1.5, 6.1.5

using, 6.1.3

Pro*C/C++

associative access, 4.4.1

converting between Oracle and C types, 4.4.3

navigational access, 4.4.2

user-defined datatypes, 4.3

programmatic environments

for Oracle objects, 4, 4.7

Q

queries

set membership, 8.4.4.4

unnesting, 8.4.1

varrays, 8.4.3

R

REF function, 2.4.5

references See REFs

REFs, 1.3.1.9

comparing, 2.3.16.2

constraints on, 2.1.6, 8.3.2

constructing from object identifiers, 7.1.2

dangling, 1.3.1.9, 1.3.1.9, 2.1.6

dereferencing of, 1.3.1.9, 9.3.2.2

for rows of object views, 5.2

implicit dereferencing of, 1.3.1.9, 9.3.2.2

indexes on, 2.1.4

indexing, 8.3.3.1

object identifiers

obtaining, 1.3.1.9

pinning, 5.3, 6.1.5

scoped, 1.3.1.9, 2.1.6, 7.1.5, 8.3.3

size of, 7.1.5

storage, 8.3.1

substitutability and, 2.3.7, 2.3.8.3

use of table aliases, 2.1.7.1

WITH ROWID option, 8.3.4

REFs, constructing from object identifiers, 9.3.6.3

RESOURCE role

user-defined types, 6.1.1, 6.1.4

roles

CONNECT role, 6.1.1, 6.1.4

DBA role, 6.1.1

RESOURCE role, 6.1.1, 6.1.4

row objects, 1.3.1.7

storage, 8.1.1.2

S

schemas

qualifying column names, 2.1.7.1

user-defined datatypes, 4.2

user-defined types, 1.3.1.1

SCOPE FOR constraint, 9.3.6.2

scoped REFs, 1.3.1.9, 7.1.5

SELECT privilege for object tables, 6.1.5, 6.1.5

SELF parameter, 2.2.1

SET function, 3.2.4.8

SQL

user-defined datatypes, 4.1

embedded SQL, 4.4

OCI, 4.3

SQLData interface, 4.7.5.1

SQLJ

See Oracle SQL

SQLJ object types, 4.7, 8.11.4.1

creating, 4.7.5.2

mapping Java classes, 4.7.5.3

See also object types, Oracle SQLJ

storage

column objects, 8.1.1.1

nested tables, 7.1.6

object tables, 7.1

REFs, 7.1.5

STORE AS clause, 9.3.6.2

SUBMULTISET condition, 3.2.3.3

substitutability, 2.3.7

attribute, 2.3.7

collections and, 2.3.7

column and row, 2.3.8, 7.2.1

constraining, 2.3.12

dependencies, 6.2.3

narrowing, 2.3.15.1

OBJECT_ID, 2.3.8.1

OBJECT_VALUE, 2.3.8.1

turning off, 2.3.11

views and, 2.3.8, 8.11.3

widening, 2.3.15.1

subtypes, 2.3, 2.3.8.2

creating, 2.3.3

indexing attributes of, 7.2.2

specializing, 8.11.1

supertypes, 2.3, 2.3.8.2

SYS_TYPEID function, 2.4.6, 7.2.1

SYS.ANYDATA, 7.4

SYS.ANYDATASET, 7.4

SYS.ANYTYPE, 7.4

system privileges

ADMIN OPTION, 6.1.3

user-defined types, 6.1.1

See also privileges

T

TABLE

function, 2.4.7

TABLE expressions, 3.2.1.2, 8.4.1

tables

aliases, 2.1.7.1

functions, 2.4.7

nested tables, 3.1.4

indexes, 2.1.4

object

See object tables

object tables, 1.3.1.6

constraints, 2.1.3

indexes, 2.1.4

triggers, 2.1.5

virtual, 5.1

qualifying column names, 2.1.7, 2.1.7.1, 2.1.7.1

TREAT function, 2.3.8, 2.3.15.1, 2.4.4, 2.4.8, 7.2.2

triggers

INSTEAD OF triggers

object views and, 5.10

user-defined types, 2.1.5

type dependencies, 6.2.3

type evolution

See object types

type hierarchies, 1.3.1.4, 2.3

methods in, 2.2.2.4

type inheritance, 2.3

finality, 2.3.2

instantiability, 2.3.4

See inheritance

specializing subtypes, 2.3.1

typeids, 2.4.6, 7.2.1

types

See datatypes, object types

U

UNDER keyword, 2.3.3

unnesting queries, 8.4.1

UPDATE privilege for object tables, 6.1.5, 6.1.5

updates

object views, 5.10

user-defined aggregate functions, 7.5

user-defined constructors, 7.3.9, 7.3.10

user-defined datatypes

See also user-defined types

user-defined types, 1.1

and remote databases, 2.1.8

collections

nested tables, 3.1.4

variable arrays (VARRAYs), 3.1.3

example of privileges, 6.1.4

Export and Import, 6.6

incomplete types, 6.2

managing, 6

object types

use of table aliases, 2.1.7.1

performance tuning, 6.4

privileges, 6.1

See also object types

See also object-relational model

storage, 7.1

synonyms, 6.3

tools, 6.5

utilities, 6.6

USING clause, 4.7.5

V

validation

failure, 7.3.4

object types, 7.3.3

VALUE function, 2.4.9

variables

bind variables

user-defined types, 4.2

object variables, 5.3

varrays, 3.1.3

accessing, 8.4.3

creating, 3.1.1

creating VARRAYs, 3.1.9

increasing the number of elements, 3.1.8

querying, 8.4.3

See also arrays, collections

storage, 3.1.6, 8.4.2

updating, 8.4.3

versus nested tables, 9.3.1

vs nested tables, 9.3.1

views

See also object views

substitutability, 2.3.8

updatability, 5.10

Visual Basic, 4.6

W

widening

and substitutability, 2.3.15.1