Index

Symbols

.NET object extensions 1.3.2
.NET stored procedures 1.3.2

A

ADMIN OPTION
- with EXECUTE ANY TYPE 7.1.3
aggregate functions
- See: user-defined aggregate functions
aliases
- required for tables 2.1.8.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 8.3.8
- See also: object types, evolving
ANYDATA column
- Storing XMLTypes and LOBs in 8.4
ANYDATA data type 8.6
ANYDATASET data type 8.6
ANYDATA types 8.4
ANYTYPE data type 8.6
arrays
- size of VARRAYs 5.1.5
assignment narrowing 2.3.19.3
assignments
- across object types 2.3.19
- collections 2.3.19.4
- objects and REFs to objects 2.3.19.1
atomic nulls 2.1.1
- object types in PL/SQL 3.1.3
attributes
- leaf-level 2.1.5, 8.1.1
- modifying 8.3.7
- of object types 1.3.1.1
attribute value constructor 2.2.4

B

bind variables
- object types 4.3
BULK COLLECT clause 5.3.3

C

caches
- object cache 4.4.1, 4.5.1, 6.3, 7.1.5
- object views 6.3
capture avoidance rule 2.1.8.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 5.1
- See also: varrays, nested tables
- assigning 2.3.19.4
- assignments 5.2
- constructing 1.3.1.10
- constructor methods 5.1.3
- creating 5.1.2
- data types 5.1
- DML on 5.3.2
- multilevel 5.2, 9.4.1, 9.4.5.1
  - constructing 5.2.5
  - creating 5.2.5
  - creating with REFs 9.4.5, 9.4.5.2
  - object views containing 6.6.2
- nested tables 5.1.7
- querying 5.3.1, 9.4.1
- substitutable elements 2.3.12.5
- substituting 2.3.11
- supported data types 1.3.1.10
- variable arrays (VARRAYs) 5.1.5
COLUMN_VALUE keyword 5.2.1
column objects 1.3.1.4
- indexes on 2.1.5
- versus row objects 9.1.1
columns
- column objects 1.3.1.4
- hidden 8.1.3, 8.2.1
- qualifying in queries 2.1.8
comparisons
- methods 2.2.2.2
- nested tables 5.3.4
compilation
- of object types 7.2.1
constraints
- object tables 2.1.3
- on Oracle objects 9.10
- REFs 9.3.2
constructor methods 5.1.3
constructors 1.3.1.3, 2.2.4, 8.1.2
- attribute values 8.5.1
- calling user-defined 8.5.6
- literal invocation 2.2.4
- literal invocation of 2.2.4
- methods 2.2.4
- 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
CREATE INDEX statement
- object types 2.1.5
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.6
CREATE TYPE privilege 7.1.1
- See also: privileges
CREATE TYPE statement
- collection types 1.3.1.10
- dependent types 7.2.1
- example 5.1.7
- nested tables 5.1.7
- object types 1.3.1.1
- varrays 5.1.5
creating object types 1.3.1.1
creating VARRAYs
- containing references to LOBs 5.1.10
CURSOR expression 2.4.2

D

dangling REFs 1.3.1.6.2, 1.3.1.7
database administrators (DBAs)
- DBA role 7.1.1
database links
- and object types 2.1.9
data types
- array types 5.1.5
- generic 8.6
- nested tables 5.1.7
- object types 2.1.9
- opaque 8.6
- transient 8.6
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
DEREF
- dereferencing a ref with 1.3.1.7.1
dereferencing 1.3.1.7
- implicit 1.3.1.7
DEREF function 2.4.3, 3.2.5
dot notation 2.1.8
- for object attributes in PL/SQL 3.2.1
- for object methods in PL/SQL 3.2.2
- using with methods 2.2.2
DROP ANY TYPE privilege 7.1.1
- See also: privileges
DROP TYPE statement
- FORCE option 7.2.7
dump files
- Export and Import 4.9.1
dynamic method dispatch 2.3.10, 3.3
dynamic SQL 3.4

E

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

F

files
- Export and Import dump file 4.9.1
FINAL keyword 2.3.3
- modifying finality 8.3.7
FORCE keyword 6.13.2
function-based indexes
- on type methods 9.5.4

G

generalized expression 2.3.5.3
generalized method invocation 2.3.5.3
generic data type 8.6
generic programming 8.6
guidelines
- comparison methods 2.2.2.2.5

I

implicit dereferencing 1.3.1.7
importing object tables 4.9.1
import object types 4.9.1
Import utility
- object types 4.9.1
incomplete object types 7.2.1
IN condition 5.3.4.2
indexes
- nested table 5.1.7.2
- object types 2.1.5
- on REFs 2.1.5
- type-discriminant column 8.2.1
index-organized tables 5.2.1
- storing nested tables as 5.2.1.3
inheritance 1.3.1.12
- See: type inheritance
- and overloading 3.3
- multiple 2.3
- single 2.3
- versus evolution 9.13.1
inheriting methods 2.3.9
initializing objects in PL/SQL 3.1
inner capture 2.1.8.1
INSERT privilege
- for object tables 7.1.5
instances
- objects 1.3.1.2
- object type 1.3.1.1
INSTANTIABLE keyword
- CREATE TYPE 2.3.6
- modifying instantiability 8.3.7
INSTEAD OF triggers
- nested tables 6.11.1
invoker-rights
- object types 9.6
invoking constructors 2.2.4
IOTs
- See: index-based tables
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.3
- Oracle JDBC and Oracle objects 4.7.1
- with Oracle objects 4.7
JDBC
- See: Oracle JDBC

L

leaf-level attributes 2.1.5, 8.1.1
- scalar 8.1.1
left correlation 5.3.1.2
literal invocation of a method 2.2.4.3
locators
- returning nested tables as 8.8, 9.4.4.3, 9.4.4.3.1
- using a hint 9.4.4.3.2
locks
- object level locking 4.4.1

M

managing
- object types 7
map methods 9.2
- comparing collections 5.3.4.1
- for comparing objects 2.2.2.2.1
materialized views 1.3.1.11, 9.9.2
MEMBER condition 5.3.4.4
member methods 1.3.1.3, 2.2.2
member procedures
- with SELF IN OUT NOCOPY 9.5.3
methods 2.2.4
- choosing a language for 9.5.1
- comparison methods 2.2.2.2
  - in a type hierarchy 2.2.2.2.6
- constructor 1.3.1.3
- constructors 1.3.1.3, 2.2.4, 8.1.2
- creating maps 2.2.2.2.2
- dot notation 2.2.2
- dropping 8.3.7
- dynamic method dispatch 2.3.10
- execution privilege for 7.1.2
- final 2.3.3
- function-based indexes 9.5.4
- guidelines for comparison 2.2.2.2.5
- inheriting 2.3.9
- instantiability 2.3.6
- invoking 2.2.2
- map 2.2.2.2.1, 9.2
- map for comparing objects 2.2.2.2.1
- map required for collections 5.3.4.1
- member 1.3.1.3, 2.2.2
- object types 1.3.1.3, 2.2
- order 2.2.2.2.4, 9.2
- overloading 2.3.5, 2.3.9, 2.3.9.1
- overriding 2.3.3, 2.3.5, 2.3.9, 2.3.9.2
- PL/SQL 4.3
- redefining 2.3.9.2
- restrictions on overriding 2.3.9.3
- SELF parameter 2.2.2.1
- static 1.3.1.3, 2.2.3, 9.5.2
modify_opaque_type clause 8.4
multilevel collections
- See: collections, multilevel
- varray storage 5.2.2
multiple inheritance 2.3
multiple subtypes 2.3.5.6
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.8
narrowing 2.4.8
NESTED_TABLE_GET_REFS hint 9.4.4.3.2
NESTED_TABLE_ID 5.2.1
NESTED_TABLE_ID keyword 9.4.4.2
nested tables 9.4.4
- adding to an object 8.3.6
- comparing 5.3.4
- 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.3
- indexes 5.1.7.2
- INSTEAD OF triggers 6.11.1
- locators 8.8, 9.4.4.3
- multiset operations 5.3.5
- piecewise operations 5.3.2.2
- querying 5.3.1
  - unnesting results 5.3.1.2
- returning as locators 9.4.4.3, 9.4.4.3.1
- specifying a storage name 8.3.6
- specifying storage in a tablespace 5.1.7.3
- storage 5.2.1, 9.4.4.1
- updating in views 6.11.1
NEW keyword 2.2.4
NLS_LENGTH_SEMANTICS initialization parameter 2.1.2
NOCOPY compiler hint
- methods 2.2.2.1
- performance issues 9.5.3
- use with member procedures 9.5.3
- use with SELF 2.2.2.1, 9.5.3
NOT FINAL keyword 2.3.3
NOT MEMBER condition 5.3.4.4
nulls
- atomic 2.1.1
- object types 2.1.1

O

OBJECT_ID pseudocolumn 2.3.12.2
OBJECT_VALUE pseudocolumn 2.3.12.2
object cache
- object views 6.3
- OCI 4.4.1
- privileges 7.1.5
- Pro*C 4.5.1
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
- 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-relational model
- advantages 1.2
- comparing objects 9.2
- constraints 9.10
- database key features 1.3.1
- design considerations 9
- key features 1.3
- methods 1.3.1.3, 2.2
- programmatic environments for 4, 4.7
object replication
- using logical standby 9.8.2
object tables 1.3.1.4, 9.1.1.2
- constraints 2.1.3
- importing 4.9.1
- indexes 2.1.5
- row objects 1.3.1.4
- triggers 2.1.6
- virtual object tables 6.1
object types 1.1, 2.3
- See also: type inheritance
- adding a nested table attribute 8.3.6
- advantages 1.2
- altering a type 8.3.4, 8.3.6
- assignments across 2.3.19
- attributes of 1.3.1.1
- character length semantics 2.1.2
- collection objects 6.6
- collections 5.1
  - nested tables 5.1.7
  - variable arrays (VARRAYs) 5.1.5
- column objects 1.3.1.4
- column objects versus row objects 9.1.1
- comparison methods for 2.2.2.2
- constructor methods 1.3.1.3, 8.1.2
- constructor methods for 2.2.4
- creating 1.3.1.1
- creating subtypes of 2.3.5.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.13
- evolving 8.3, 9.13.1
  - design considerations 9.11
- example of privileges 7.1.4
- Export and Import 4.9.1
- FINAL or NOT FINAL 2.3.3
- in columns 6.4
- incomplete 7.2, 7.2.1, 7.2.2
- indexes on column objects 2.1.5
- indexing 8.2.1
- inheritance 1.3.1.12, 2.3
- initializing in PL/SQL 3.1.3
- instances 1.3.1.1
- instantiable 2.3.6
- invoker-rights 9.6
- key features 1.3
- locking in cache 4.4.1
- managing 7
- methods 2.2, 2.2.2
- methods in PL/SQL 4.3
- mutually dependent 7.2.1
- name resolution 2.1.8
- nested tables 5.1.7
- not instantiable 2.3.6
- nulls 2.1.1
- object references 6.8
- Oracle type translator 4.5.5
- performance tuning 7.4
- privileges 7.1, 7.1.1
- recompiling 7.2.3
- remote access to 2.1.9, 6.12
- row objects and object identifiers 6.6
- schema privileges 7.1.2
- specializing 1.3.1.12
- SQLJ types 4.7.3
- storage 8.1
- substituting 2.3.11
- subtypes 2.3.2
- synonyms 7.3
- table aliases 2.1.8.1
- triggers 2.1.6
- use of table aliases 2.1.8.1
- utilities 4.9
- variable arrays (VARRAYs) 5.1.5
- views 1.3.1.11
object views 1.3.1.11, 6
- advantages of 6.1
- circular references 6.13.1
- defining REFs
  - for rows of object views 6.2
- hierarchies 6.14, 9.13.3
  - privileges 6.14.3
  - querying in 6.14.2
- modeling relationships 6.10, 6.13
- multilevel collections in 6.6.2
- nested tables 6.11.1
- null objects in 6.5
- OIDs with 6.7
- REFs to 6.8
- updating through INSTEAD OF triggers 6.11
OCCI 4.6
OCI
- associative access 4.4.2
- for Oracle objects
  - building a program 4.4.5
- navigational access 4.4.3
- object cache 4.4.4
- 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
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
- data mapping for Oracle objects 4.7.2
Oracle type translator (OTT) 4.5.5
order methods 2.2.2.2.4, 9.2
ORGANIZATION INDEX clause 5.2.1
OTT 4.5.5
outer-join syntax 5.3.1.2, 5.3.1.5
overloading 2.3.9
- and inheritance 3.3
- methods 2.3.5, 2.3.9.1
- user-defined constructors 8.5.4
overriding
- methods 2.3.5
- user-defined constructors 8.5.4
overriding methods 2.3.9

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.6
PL/SQL
- bind variables
  - object types 4.3
- object views 6.3
- using with objects 1.3.1.3
polymorphism 1.3.1.11, 2.3.11, 9.13.2, 9.13.3
- See also: substitutability
POWERMULTISET_BY_CARDINALITY function 5.3.5.7
POWERMULTISET function 5.3.5.6
primary-key-based REFs 8.1.6
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 INSERT 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
Pro*C
- embedded SQL with user-defined data types 4.5.1
- object cache 4.5.1
Pro*C/C++
- associative access 4.5.2
- converting between Oracle and C types 4.5.4
- navigational access 4.5.3
- 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.9.2
REF attributes 2.1.7
REF columns 2.1.7
references 1.3.1.6
references See REFs 1.3.1.6
REF function 2.4.5
- manipulating objects in PL/SQL 3.2.5
REFs 1.3.1.6
- comparing 1.3.1.9
- constraints on 2.1.7, 9.3.2
- constructing from object identifiers 8.1.2
- dangling 1.3.1.6.2, 1.3.1.7, 2.1.7
- dereferencing 3.2.5
- dereferencing of 1.3.1.7
- implicit dereferencing of 1.3.1.7
- indexes on 2.1.5
- indexing 9.3.3.1
- obtaining 1.3.1.8
- pinning 6.3, 7.1.5
- scoped 1.3.1.6.1, 2.1.7, 8.1.6, 9.3.3
- size of 8.1.6
- storage 9.3.1
- substitutability 2.3.12.4
- substitutability in 2.3.11
- use of table aliases 2.1.8.1
- WITH ROWID option 9.3.4
remote databases
- using with object types 2.1.9
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

S

sample schemas, hr schema
schemas
- object data types 4.3
- object types 1.3.1.1
- qualifying column names 2.1.8.1
scoped REFs 1.3.1.6.1, 8.1.6
See also dereferencing 2.4.3, 3.2.5
SELECT privilege
- for object tables 7.1.5
SELF parameter
- methods 2.2.2.1
SET function 5.3.5.8
single inheritance 2.3
SQL
- support for object types 4.1
- user-defined data types 4.1
  - OCI 4.4.1
SQLJ
- See: Oracle SQL
SQLJ object types 4.7, 4.7.3, 9.13.4.1
- See also: object types, Oracle SQLJ
- creating 4.7.3.1
- mapping Java classes 4.7.3.2
static dispatch 2.3.5.3
static methods 1.3.1.3, 2.2.3
storage 9.1.2
- column objects 9.1.1.1
- nested tables 8.1.7
- object tables 8.1
- REFs 8.1.6
storing nested tables 5.1.7.2
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.11
- attributes 2.3.11
- collections 2.3.11
- column and row 2.3.12, 8.2.1
- constraining 2.3.16
- dependencies 7.2.6
- modifying 2.3.17
- narrowing 2.3.19.3
- OBJECT_ID 2.3.12.2
- OBJECT_VALUE 2.3.12.2
- restrictions on modifying 2.3.18
- turning off 2.3.15
- views 2.3.12
- views and 9.13.3
- widening 2.3.19.1
  - assignment widening 2.3.19.2
substitutability of object types
- with overloading 3.3
substitutable columns
- dropping subtypes 2.3.14
subtypes
- creating 2.3.5
- dropping in substitutable columns 2.3.14
- hierarchy 2.3
- indexing attributes of 8.2.2
- multiple 2.3.5.6
- object types 2.3.2
- specializing 9.13.1
- with supertype attribute 2.3.12.3
supertypes
- attribute of subtype 2.3.12.3
- base in hierarchy 2.3
synonyms
- object types 7.3
SYS_TYPEID function 2.4.6, 8.2.1
system privileges 7.1.1
- See also: privileges
- ADMIN OPTION 7.1.3
- object types 7.1.1

T

TABLE
- function 2.4.7
Table Dependencies 7.2.4
TABLE expression 5.1.7, 5.3.1.3
TABLE expressions 5.3.1.2, 9.4.1
TABLE expression subqueries
- restrictions 5.3.1.2
tables
- aliases 2.1.8.1
- constraints on object tables 2.1.3
- functions 2.4.7
- indexes on nested tables 2.1.5
- nested tables 5.1.7
- object tables 1.3.1.4
  - virtual 6.1
- qualifying column names 2.1.8, 2.1.8.1
transient data type 8.6
TREAT function 2.3.12, 2.3.19.3, 2.4.4, 2.4.8, 8.2.2
triggers
- INSTEAD OF triggers
  - object views and 6.11
- object types 2.1.6
type dependencies 7.2.6
Type Dependencies 7.2.4
type evolution 1.3.1.13
- See: object types
type hierarchies 1.3.1.12, 2.3
- methods in 2.2.2.2.6
typeids 2.4.6, 8.2.1
type inheritance
- See: inheritance
- finality 2.3.3
- instantiability 2.3.6
- methods 2.3.9
- object types 2.3
- specializing subtypes 2.3.2
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.5
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.5
UPDATE privilege
- for object tables 7.1.5
updates
- object views 6.11
UPGRADE..STORE AS 8.3.6
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.9
utilities supporting objects 4.9

V

validation
- object types 8.3.7
VALUE function 2.4.9, 3.2.2
variables
- bind variables
  - object types 4.3
- object variables 6.3
varrays 5.1.5
- accessing 9.4.3
- creating 5.1.2
- creating VARRAYs 5.1.10
- increasing the number of elements 5.1.9
- querying 9.4.3
- storage 5.2.2, 9.4.2
- updating 9.4.3
views 6.11
- See also: object views
- object 1.3.1.11
- substitutability 2.3.12
- updatability 6.11

W

widening
- and substitutability 2.3.19.1, 2.3.19.2

X

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