Index
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
- atomic nulls 2.1.1- object types in PL/SQL 3.1.3
 
- attributes
- attribute value constructor 2.2.4
C
- caches
- 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
- 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
- columns
- comparisons
- compilation - of object types 7.2.1
 
- constraints
- constructor methods 5.1.3
- constructors 1.3.1.3, 2.2.4, 8.1.2
- 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
- CREATE TRIGGER statement - object table example 2.1.6
 
- CREATE TYPE privilege 7.1.1- See also: privileges
 
- CREATE TYPE statement
- 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
- 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
- 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
- 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
 
 
- nested tables 
- evolution
- 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
 
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
- index-organized tables 5.2.1- storing nested tables as 5.2.1.3
 
- inheritance 1.3.1.12- See: type inheritance
 
- 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
- INSTANTIABLE keyword
- 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
M
- managing - object types 7
 
- map methods 9.2
- 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
- NOT FINAL keyword 2.3.3
- NOT MEMBER condition 5.3.4.4
- nulls
O
- OBJECT_ID pseudocolumn 2.3.12.2
- OBJECT_VALUE pseudocolumn 2.3.12.2
- object cache
- object constructors
- object identifier 1.3.1.5, 6.2
- object identifiers
- object instances 1.3.1.1, 1.3.1.2
- object methods - calling in PL/SQL 3.2.2
 
- object-relational model
- object replication - using logical standby 9.8.2
 
- object tables 1.3.1.4, 9.1.1.2
- 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
- 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
- OCCI 4.6
- OCI
- 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
- overriding
- overriding methods 2.3.9
P
- parallel query
- 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
- 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
- Pro*C/C++
- programmatic environments
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
- row objects - storage 9.1.1.2
 
S
- sample schemas, hr schema
- schemas
- 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
- SQLJ - See: Oracle SQL
 
- SQLJ object types 4.7, 4.7.3, 9.13.4.1- See also: object types, Oracle SQLJ
 
- static dispatch 2.3.5.3
- static methods 1.3.1.3, 2.2.3
- storage 9.1.2
- storing nested tables 5.1.7.2
- Storing XMLTypes and LOBs in an ANYDATA column 8.4
- SUBMULTISET condition 5.3.4.3
- subprograms
- 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
- supertypes
- synonyms - object types 7.3
 
- SYS_TYPEID function 2.4.6, 8.2.1
- system privileges 7.1.1- See also: privileges
 
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
- transient data type 8.6
- TREAT function 2.3.12, 2.3.19.3, 2.4.4, 2.4.8, 8.2.2
- triggers
- 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
 
- 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