Skip Headers
Oracle® Database Application Developer's Guide - Object-Relational Features
10g Release 2 (10.2)

Part Number B14260-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page
Previous
View PDF

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
aliases
required for tables, 2.1.7.1
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, A.3.6
size of VARRAYs, 3.1.3
variable (VARRAYs), 3.1.3
ASP, 4.6
assignments
across object types, 2.3.15
collections, 2.3.15.2
objects and REFs to objects, 2.3.15.1
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
object 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
character length semantics
object types, 2.1.2
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
DML on multilevel, 3.2.2.1
multilevel, 3.1.10, 8.4.1
constructing, 3.1.10.3
creating, 3.1.10.3
creating with REFs, 8.4.5
object views containing, 5.6.2
nested tables, 3.1.4
querying, 3.2.1, 8.4.1
See also varrays, nested tables
substitutable elements, 2.3.8.4
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
comparisons
collections, 2.3.16.1, 3.2.3
methods, 2.2.2, A.3.1, A.3.6.4
object types, 2.3.16.1
REFs, 2.3.16.1
compilation
of object types, 6.2
COMPRESS clause
nested tables, 8.4.4.1
constraints, A.3.4
object tables, 2.1.3
on Oracle objects, 8.8
REFs, 8.3.2
SCOPE FOR constraint, A.3.6.2
constructor methods, 1.3.1.3, 1.3.1.3, 2.2.4, 7.1.2
literal invocation of, 2.2.4
constructors
attribute values, 7.3.7
calling user-defined, 7.3.12
methods, 2.2.4
overloading, 7.3.10
overriding, 7.3.10
system defined, 7.3.7
type evolution, 7.3.8
user-defined, 7.3.9, 7.3.10
with NEW keyword, 7.3.7
COUNT attribute of collection types, A.3.2.2
CREATE ANY TYPE privilege, 6.1.1
See also privileges
CREATE INDEX statement
object types, 2.1.4
CREATE TABLE statement
column object example, 1.3.1.2
object table example, 1.3.1.6
object table examples, 2.1.3
CREATE TRIGGER statement
object table example, 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
dependent types, 6.2
example, 3.1.4
nested tables, 3.1.4
object types, 1.3.1.1, 1.3.1.2, A.3.1
varrays, 3.1.3, A.3.1
creating object types, 1.3.1.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
and object types, 2.1.8
datatypes
array types, 3.1.3
nested tables, 3.1.4
See also object types
transient and generic, 7.4
DBA role
user-defined types, 6.1.1
DEFAULT clause, 3.1.2
default values
collections, 3.1.2
object 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, A.3.2.2
implicit, 1.3.1.9, A.3.2.2
dot notation
using with methods, 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
dynamic method dispatch, 2.3.6

E

equal and not equal conditions
nested tables, 3.2.3.1
evolution
object types, 1.3.1.5
Excel, 4.6
EXECUTE ANY TYPE privilege, 6.1.1, 6.1.3
See also privileges
EXECUTE privilege
object types, 6.1.3
See also privileges
Export utility
object types, 6.6
EXTERNAL NAME phrase, 4.7.5

F

features
new, Preface
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, A.2.2.2
function-based indexes
on type methods, 8.5.4

G

GRANT option for EXECUTE privilege, 6.1.3
granting
execute object type, 6.1.3
guidelines
comparison methods, 2.2.2.3

I

implicit dereferencing, 1.3.1.9, A.3.2.2
Import utility
object types, 6.6
IN condition, 3.2.3.2
incomplete object types, 6.2
indexes
nested table, 3.1.4
object types, 2.1.4
on REFs, 2.1.4
type-discriminant column, 7.2.1
index-organized tables
storing nested tables as, 3.1.10.1, 8.4.4.1
inheritance, 1.3.1.4
See type inheritance
inheriting methods, 2.3.5
inner capture, 2.1.7.1
INSERT privilege
for object tables, 6.1.5, 6.1.5
instances
object type, 1.3.1.1
objects, 1.3.1.2
INSTANTIABLE keyword
CREATE TYPE, 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 NOT A SET condition, 3.2.3.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
JPublisher, 4.7.4

K

keys
foreign keys, A.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, A.3.6.2
using a hint, 8.4.4.3
locks
object level locking, 4.3

M

managing
object types, 6
map methods, 8.2, A.3.1, A.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
member methods, 1.3.1.3, 2.2.1
member procedures
with SELF IN OUT NOCOPY, 8.5.3
methods, A.3.2
choosing a language for, 8.5.1
comparison, A.3.1, A.3.6.4
comparison methods, 2.2.2
in a type hierarchy, 2.2.2.4
constructor, 1.3.1.3
constructor methods, 7.1.2
literal invocation, 2.2.4
constructors, 1.3.1.3, 2.2.4
dot notation, 2.2.1
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
guidelines for comparison, 2.2.2.3
inheriting, 2.3.5
instantiability, 2.3.4
invoking, 2.2.1
map, 2.2.2.1, 8.2, A.3.1, A.3.6.4
map for comparing objects, 2.2.2.1
map required for collections, 3.2.3.1
member, 1.3.1.3, 2.2.1
object types, 1.3.1.3, 2.2
of object types, 1.3.1.1
order, 2.2.2.2, 8.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.2
redefining, 2.3.5.2
restrictions on overriding, 2.3.5.3
SELF parameter, 2.2.1
static, 1.3.1.3, 2.2.3, 8.5.2
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

name resolution
object types, 2.1.7
narrowing, 2.3.15.1, 2.4.8
nested cursor, A.3.6.4
nested tables, 3.1.4, 8.4.4
adding to an object, 7.3.2
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, 3.1.4
INSTEAD OF triggers, 5.10.1
multiset operations, 3.2.4
querying, 3.2.1, A.3.1
unnesting results, 3.2.1.2
returning as locators, 8.4.4.3, 8.4.4.3, A.3.6.2
specifying a storage name, 7.3.2
specifying storage in a tablespace, 3.1.5
storage, 3.1.10.1, 8.4.4.1, A.3.6.2
uniqueness in, A.3.6.2
updating in views, 5.10.1
versus VARRAY, A.3.1
versus varrays, A.3.1
NESTED_TABLE_GET_REFS hint, 8.4.4.3
NESTED_TABLE_ID keyword, 3.1.10.1, 8.4.4.2, A.3.6.2
NLS_LENGTH_SEMANTICS initialization parameter, 2.1.2
NOCOPY compiler hint
methods, 2.2.1
performance issues, 8.5.3
use with member procedures, 8.5.3
use with SELF, 2.2.1, 8.5.3
NOT FINAL keyword, 2.3.2
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, A.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, 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, 8.7
row objects, 1.3.1.7
triggers, 2.1.5
virtual object tables, 5.1
object types, 1.1
adding a nested table attribute, 7.3.2
advantages, 1.2
altering a type, 7.3.1, 7.3.2
assignments across, 2.3.15
attributes of, 1.3.1.1
character length semantics, 2.1.2
collection objects, 5.6
collections, 3.1
nested tables, 3.1.4
variable arrays (VARRAYs), 3.1.3
column objects, 1.3.1.7
column objects versus row objects, 8.1.1
comparing, 2.3.16.1
comparison methods for, 2.2.2, A.3.1, A.3.6.4
constructor methods, 1.3.1.3
constructor methods for, 2.2.4, 7.1.2
creating, 1.3.1.1, 1.3.1.2
creating subtypes of, 2.3.3
database key features, 1.3.1
dependencies, 6.2
dependents, 6.2, 7.3
evolution, 1.3.1.5
evolving, 7.3, 8.11.1
design considerations, 8.9
SQLJ types, 4.7.5.4
example of privileges, 6.1.4
Export and Import, 6.6
final, 8.9.3
FINAL or NOT FINAL, 2.3.2
in columns, 5.4
incomplete, 6.2, 6.2.1
incomplete types, 6.2
indexes on column objects, 2.1.4
indexing, 7.2.1
inheritance, 1.3.1.4, 2.3
instances, 1.3.1.1
instantiable, 2.3.4
invoker-rights, 8.6
key features, 1.3
locking in cache, 4.3
managing, 6
methods, 2.2, 2.2.1
methods in PL/SQL, 4.2
methods of, 1.3.1.1, A.3.2
mutually dependent, 6.2
name resolution, 2.1.7
nested tables, 3.1.4
not final, 8.9.3
not instantiable, 2.3.4
nulls, 2.1.1
object references, 5.8
Oracle type translator, 4.4.4
performance tuning, 6.4
privileges, 6.1
recompiling, 6.2.2
remote access to, 2.1.8, 5.11
row objects, 1.3.1.7
row objects and object identifiers, 5.6
schema privileges, 6.1.2
See also type inheritance
specializing, 1.3.1.4
SQLJ types, 4.7.5
storage, 7.1
substituting, 2.3.7
subtypes, 2.3.1
synonyms, 6.3
table aliases, 2.1.7.1
tools, 6.5
triggers, 2.1.5
use of table aliases, 2.1.7.1
utilities, 6.6
variable arrays (VARRAYs), 3.1.3
views, 1.3.1.8
object views, 1.3.1.8, 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, A
advantages, 1.2
comparing objects, 8.2
constraints, 8.8
database key features, 1.3.1
design considerations, 8
embedded objects, A.3.6
key features, 1.3
methods, 1.3.1.3, 2.2
partitioning, 7.6
programmatic environments for, 4, 4.7
replication, 8.7
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 C++ Call Interface, 4.5
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
data mapping for Oracle objects, 4.7.3
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, A.3.1, A.3.2.3
OTT, 4.4.4
overloading
methods, 2.3.3, 2.3.5.1
user-defined constructors, 7.3.10
overloading methods, 2.3.5
overriding
methods, 2.3.3
user-defined constructors, 7.3.10
overriding methods, 2.3.5

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
object types, 4.2
object views, 5.3
using with objects, 1.3.1.6
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, A.3.1
primary-key-based REFs, 7.1.5
privileges
acquired by role on object types, 6.1.1
ALTER ANY TYPE on object types, 6.1.1
checked when pinning object types, 6.1.5
column level for object tables, 6.1.5
CREATE ANY TYPE on object types, 6.1.1
DELETE on object types, 6.1.5
DROP ANY TYPE on object types, 6.1.1
EXECUTE ANY TYPE on object types, 6.1.1, 6.1.3
EXECUTE ANY TYPE on object types with ADMIN OPTION, 6.1.3
EXECUTE on object types, 6.1.3
EXECUTE on object types with GRANT option, 6.1.3
INSERT on object types, 6.1.5
object types in types or tables, 6.1.3
object types with CREATE TYPE, 6.1.1
object types with DELETE, 6.1.5
object types with INSERT, 6.1.5
object types with SELECT, 6.1.5
object types with UPDATE, 6.1.5
on object types, 6.1
SELECT on object types, 6.1.5
system on object types, 6.1.1
UNDER ANY TYPE on object types, 6.1.1
UNDER ANY VIEW on object types, 6.1.1
UPDATE on object types, 6.1.5
Pro*C
embedded SQL with user-defined datatypes, 4.4
object cache, 4.4
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

recompilation
object types, 6.2.2
redefining
methods, 2.3.5.2
REF attributes, 2.1.6
REF columns, 2.1.6
REF function, 2.4.5
references, 1.3.1.9
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, A.3.6.3
dangling, 1.3.1.9, 1.3.1.9, 2.1.6
dereferencing of, 1.3.1.9, A.3.2.2
for rows of object views, 5.2
implicit dereferencing of, 1.3.1.9, A.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, 2.3.7, 2.3.8.3
use of table aliases, 2.1.7.1
WITH ROWID option, 8.3.4
remote databases
using with object types, 2.1.8
RESOURCE role
user-defined types, 6.1.1, 6.1.4
roles
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
object datatypes, 4.2
object types, 1.3.1.1
qualifying column names, 2.1.7.1
SCOPE FOR constraint, A.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
methods, 2.2.1
SET function, 3.2.4.8
SQL
support for object types, 4.1
user-defined datatypes, 4.1
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
static methods, 1.3.1.3, 2.2.3
storage
column objects, 8.1.1.1
nested tables, 7.1.6
object tables, 7.1
REFs, 7.1.5
STORE AS clause, A.3.6.2
SUBMULTISET condition, 3.2.3.3
substitutability, 2.3.7
attributes, 2.3.7
collections, 2.3.7
column and row, 2.3.8, 7.2.1
constraining, 2.3.12
dependencies, 6.2.3
modifying, 2.3.13
narrowing, 2.3.15.1
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, 8.11.3
widening, 2.3.15.1
substitutable columns
dropping subtypes, 2.3.10
subtypes
creating, 2.3.3
dropping in substitutable columns, 2.3.10
hierarchy, 2.3
indexing attributes of, 7.2.2
object types, 2.3.1
specializing, 8.11.1
with supertype attribute, 2.3.8.2
supertypes
attribute of subtype, 2.3.8.2
base in hierarchy, 2.3
synonyms
object types, 6.3
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
object 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, 2.1.7.1
constraints on object tables, 2.1.3
functions, 2.4.7
indexes on nested tables, 2.1.4
indexes on object tables, 2.1.4
nested tables, 3.1.4
object
See object tables
object tables, 1.3.1.6
virtual, 5.1
qualifying column names, 2.1.7, 2.1.7.1, 2.1.7.1
triggers on object tables, 2.1.5
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
object 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
finality, 2.3.2
instantiability, 2.3.4
methods, 2.3.5
object types, 2.3
See inheritance
specializing subtypes, 2.3.1
typeids, 2.4.6, 7.2.1
types
See datatypes, object types

U

UNDER ANY TYPE privilege, 6.1.1
See also privileges
UNDER ANY VIEW privilege, 6.1.1
See also privileges
UNDER keyword
CREATE TYPE, 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
See object types
user-defined types
and remote databases, 2.1.8
See also object-relational model
See object types
USING clause, 4.7.5

V

validation
failure, 7.3.4
object types, 7.3.3
VALUE function, 2.4.9
variables
bind variables
object 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, A.3.1, A.3.1
views
object, 1.3.1.8
See also object views
substitutability, 2.3.8
updatability, 5.10
Visual Basic, 4.6

W

widening
and substitutability, 2.3.15.1