Index

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

Symbols

  • .NET object extensions 1
  • .NET stored procedures 1

A

  • ADMIN OPTION
    • with EXECUTE ANY TYPE 1
  • aggregate functions
    • See: user-defined aggregate functions
  • aliases
    • required for tables 1
  • ALTER ANY TYPE privilege 1
    • See also: privileges
  • ALTER TABLE
    • storing XMLTypes and LOBs 1
  • ALTER TYPE statement 1
    • See also: object types, evolving
  • ANYDATA column
    • Storing XMLTypes and LOBs in 1
  • ANYDATA data type 1
  • ANYDATASET data type 1
  • ANYDATA types 1
  • ANYTYPE data type 1
  • arrays
    • size of VARRAYs 1
  • assignment narrowing 1
  • assignments
    • across object types 1
    • collections 1
    • objects and REFs to objects 1
  • atomic nulls
    • object types in PL/SQL 1
  • attributes
    • leaf-level 1 , 2
    • modifying 1
    • of object types 1
  • attribute value constructor 1

B

  • bind variables
    • object types 1
  • BULK COLLECT clause 1

C

  • caches
    • object cache 1 , 2 , 3 , 4
    • object views 1
  • capture avoidance rule 1
  • CARDINALITY function 1
  • CAST function 1
  • character length semantics
    • object types 1
  • COLLECT function 1
  • collections
    • assigning 1
    • assignments 1
    • constructing 1
    • constructor methods 1
    • creating 1
    • data types 1
    • DML on 1
    • multilevel
      • constructing 1
      • creating 1
      • creating with REFs 1 , 2
      • object views containing 1
    • nested tables 1
    • querying 1 , 2
    • substitutable elements 1
    • substituting 1
    • supported data types 1
    • variable arrays (VARRAYs) 1
  • COLUMN_VALUE keyword 1
  • column objects
    • indexes on 1
    • versus row objects 1
  • columns
    • column objects 1
    • hidden 1 , 2
    • qualifying in queries 1
  • comparisons
    • methods 1
    • nested tables 1
  • compilation
    • of object types 1
  • constraints
    • object tables 1
    • on Oracle objects 1
    • REFs 1
  • constructor methods 1
  • constructors
    • attribute values 1
    • calling user-defined 1
    • literal invocation 1
    • literal invocation of 1
    • methods 1
    • overloading 1
    • overriding 1
    • system defined 1
    • type evolution 1
    • user-defined 1 , 2
    • with NEW keyword 1
  • CREATE INDEX statement
    • object types 1
  • CREATE OR REPLACE TYPE Table Dependencies 1
  • CREATE OR REPLACE TYPE with FORCE option 1
  • CREATE OR REPLACE TYPE with Type Dependencies 1
  • CREATE TABLE statement
    • column object example 1
    • object table example 1 , 2
  • CREATE TRIGGER statement
    • object table example 1
  • CREATE TYPE privilege 1
    • See also: privileges
  • CREATE TYPE statement
    • collection types 1
    • dependent types 1
    • example 1
    • nested tables 1
    • object types 1
    • varrays 1
  • creating object types 1
  • creating VARRAYs
    • containing references to LOBs 1
  • CURSOR expression 1

D

  • dangling REFs 1 , 2
  • database administrators (DBAs)
    • DBA role 1
  • database links
    • and object types 1
  • data types
    • array types 1
    • generic 1
    • nested tables 1
    • object types 1
    • opaque 1
    • transient 1
  • DBA role
    • user-defined types 1
  • declarations
    • object in a PL/SQL block 1
  • declaring objects in PL/SQL 1
  • DEFAULT clause 1
  • default values
    • collections 1
    • object types 1
  • DELETE privilege
    • for object tables 1
  • DEREF
    • dereferencing a ref with 1
  • dereferencing
    • implicit 1
  • DEREF function 1 , 2
  • dot notation
    • for object attributes in PL/SQL 1
    • for object methods in PL/SQL 1
    • using with methods 1
  • DROP ANY TYPE privilege 1
    • See also: privileges
  • DROP TYPE statement
    • FORCE option 1
  • dump files
    • Export and Import 1
  • dynamic method dispatch 1 , 2
  • dynamic SQL 1

E

  • editions
    • views 1
  • equal and not equal conditions
    • nested tables 1
  • equipartitioning
    • nested tables
      • partitioning 1
  • evolution
    • object types 1
    • versus inheritance 1
  • EXECUTE ANY TYPE privilege 1 , 3
    • See also: privileges
  • EXECUTE privilege
    • object types 1
  • executing SQL statements at run time 1
  • export object types 1
  • Export utility
    • object types 1

F

  • files
    • Export and Import dump file 1
  • FINAL keyword
    • modifying finality 1
  • FORCE keyword 1
  • function-based indexes
    • on type methods 1

G

  • generalized expression 1
  • generalized method invocation 1
  • generic data type 1
  • generic programming 1
  • guidelines
    • comparison methods 1

I

  • implicit dereferencing 1
  • importing object tables 1
  • import object types 1
  • Import utility
    • object types 1
  • incomplete object types 1
  • IN condition 1
  • indexes
    • nested table 1
    • object types 1
    • on REFs 1
    • type-discriminant column 1
  • index-organized tables
    • storing nested tables as 1
  • inheritance
    • and overloading 1
    • multiple 1
    • single 1
    • versus evolution 1
  • inheriting methods 1
  • initializing objects in PL/SQL 1
  • inner capture 1
  • INSERT privilege
    • for object tables 1
  • instances
    • objects 1
    • object type 1
  • INSTANTIABLE keyword
    • CREATE TYPE 1
    • modifying instantiability 1
  • INSTEAD OF triggers
    • nested tables 1
  • invoker-rights
    • object types 1
  • invoking constructors 1
  • IOTs
    • See: index-based tables
  • IS A SET condition 1
  • IS EMPTY condition 1
  • IS NOT A SET condition 1
  • IS OF type predicate 1

J

  • Java
    • object storage 1
    • Oracle JDBC and Oracle objects 1
    • with Oracle objects 1
  • JDBC
    • See: Oracle JDBC

L

  • leaf-level attributes
    • scalar 1
  • left correlation 1
  • literal invocation of a method 1
  • locators
    • returning nested tables as 1 , 2 , 3
    • using a hint 1
  • locks
    • object level locking 1

M

  • managing
    • object types 1
  • map methods
    • comparing collections 1
    • for comparing objects 1
  • materialized views 1 , 2
  • MEMBER condition 1
  • member methods 1 , 2
  • member procedures
    • with SELF IN OUT NOCOPY 1
  • methods
    • choosing a language for 1
    • comparison methods
      • in a type hierarchy 1
    • constructor 1
    • constructors 1 , 2 , 3
    • creating maps 1
    • dot notation 1
    • dropping 1
    • dynamic method dispatch 1
    • execution privilege for 1
    • final 1
    • function-based indexes 1
    • guidelines for comparison 1
    • inheriting 1
    • instantiability 1
    • invoking 1
    • map 1 , 2
    • map for comparing objects 1
    • map required for collections 1
    • member 1 , 2
    • object types 1 , 2
    • order 1 , 2
    • overloading 1 , 2 , 3
    • overriding 1 , 2 , 3 , 4
    • PL/SQL 1
    • redefining 1
    • restrictions on overriding 1
    • SELF parameter 1
    • static 1 , 2 , 3
  • modify_opaque_type clause 1
  • multilevel collections
    • varray storage 1
  • multiple inheritance 1
  • multiple subtypes 1
  • MULTISET EXCEPT operator 1
  • MULTISET INTERSECT operator 1
  • multiset operations
    • with nested tables 1
  • MULTISET UNION operator 1

N

  • name resolution
    • object types 1
  • narrowing 1
  • NESTED_TABLE_GET_REFS hint 1
  • NESTED_TABLE_ID 1
  • NESTED_TABLE_ID keyword 1
  • nested tables
    • adding to an object 1
    • comparing 1
    • creating 1
    • creating indexes on 1
    • equal and not equal conditions 1
    • in an index-organized table 1
    • indexes 1
    • INSTEAD OF triggers 1
    • locators 1 , 2
    • multiset operations 1
    • piecewise operations 1
    • querying
      • unnesting results 1
    • returning as locators 1 , 2
    • specifying a storage name 1
    • specifying storage in a tablespace 1
    • storage 1 , 2
    • updating in views 1
  • NEW keyword 1
  • NLS_LENGTH_SEMANTICS initialization parameter 1
  • NOCOPY compiler hint
    • methods 1
    • performance issues 1
    • use with member procedures 1
    • use with SELF 1 , 2
  • NOT FINAL keyword 1
  • NOT MEMBER condition 1
  • nulls
    • atomic 1
    • object types 1

O

  • OBJECT_ID pseudocolumn 1
  • OBJECT_VALUE pseudocolumn 1
  • object cache
    • object views 1
    • OCI 1
    • privileges 1
    • Pro*C 1
  • object constructors
    • calling in PL/SQL 1
    • passing parameters to in PL/SQL 1
  • object identifier 1 , 2
  • object identifiers
    • column and index 1
    • for object types 1
    • primary-key based 1
    • REFs 1
    • storage 1
    • system-generated 1
  • object instances 1 , 2
  • object methods
    • calling in PL/SQL 1
  • object-relational model
    • advantages 1
    • comparing objects 1
    • constraints 1
    • database key features 1
    • design considerations 1
    • key features 1
    • methods 1 , 2
    • programmatic environments for 1 , 2
  • object replication
    • using logical standby 1
  • object tables
    • constraints 1
    • importing 1
    • indexes 1
    • row objects 1
    • triggers 1
    • virtual object tables 1
  • object types
    • adding a nested table attribute 1
    • advantages 1
    • altering a type 1 , 2
    • assignments across 1
    • attributes of 1
    • character length semantics 1
    • collection objects 1
    • collections
      • nested tables 1
      • variable arrays (VARRAYs) 1
    • column objects 1
    • column objects versus row objects 1
    • comparison methods for 1
    • constructor methods 1 , 2
    • constructor methods for 1
    • creating 1
    • creating subtypes of 1
    • database key features 1
    • declaring in a PL/SQL block 1
    • dependencies 1
    • dependents 1 , 2
    • evolution 1
    • evolving
      • design considerations 1
    • example of privileges 1
    • Export and Import 1
    • FINAL or NOT FINAL 1
    • in columns 1
    • incomplete 1 , 2 , 3
    • indexes on column objects 1
    • indexing 1
    • inheritance 1 , 2
    • initializing in PL/SQL 1
    • instances 1
    • instantiable 1
    • invoker-rights 1
    • key features 1
    • locking in cache 1
    • managing 1
    • methods 1 , 2
    • methods in PL/SQL 1
    • mutually dependent 1
    • name resolution 1
    • nested tables 1
    • not instantiable 1
    • nulls 1
    • object references 1
    • Oracle type translator 1
    • performance tuning 1
    • privileges 1 , 2
    • recompiling 1
    • remote access to 1 , 2
    • row objects and object identifiers 1
    • schema privileges 1
    • specializing 1
    • SQLJ types 1
    • storage 1
    • substituting 1
    • subtypes 1
    • synonyms 1
    • table aliases 1
    • triggers 1
    • use of table aliases 1
    • utilities 1
    • variable arrays (VARRAYs) 1
    • views 1
  • object views
    • advantages of 1
    • circular references 1
    • defining REFs
      • for rows of object views 1
    • hierarchies
      • privileges 1
      • querying in 1
    • modeling relationships 1 , 2
    • multilevel collections in 1
    • nested tables 1
    • null objects in 1
    • OIDs with 1
    • REFs to 1
    • updating through INSTEAD OF triggers 1
  • OCCI 1
  • OCI
    • associative access 1
    • for Oracle objects
      • building a program 1
    • navigational access 1
    • object cache 1
    • OCIObjectFlush 1
    • OCIObjectPin 1
  • ODP.NET, Oracle Developer Tools for Visual Studio 1
  • ODT, Microsoft common language 1
  • OIDs 1
  • opaque data type 1
  • opaque types and ANYDATA 1
  • Oracle C++ Call Interface 1
  • Oracle Data Provider for .NET 1
  • Oracle JDBC
    • accessing Oracle object data 1
  • Oracle objects
    • See: object-relational model
  • Oracle SQLJ
    • creating custom Java classes 1
    • data mapping for Oracle objects 1
    • JPublisher 1
  • Oracle type translator (OTT) 1
  • order methods 1 , 2
  • ORGANIZATION INDEX clause 1
  • OTT 1
  • outer-join syntax 1 , 2
  • overloading
    • and inheritance 1
    • methods 1 , 2
    • user-defined constructors 1
  • overriding
    • methods 1
    • user-defined constructors 1
  • overriding methods 1

P

  • parallel query
    • objects 1
    • restrictions for Oracle objects 1
    • view objects 1
  • partitioning
    • tables containing Oracle object 1
  • piecewise operations on multilevel nested tables 1
  • pkREFs 1
  • PL/SQL
    • bind variables
      • object types 1
    • object views 1
    • using with objects 1
  • polymorphism 1 , 2 , 3 , 4
    • See also: substitutability
  • POWERMULTISET_BY_CARDINALITY function 1
  • POWERMULTISET function 1
  • primary-key-based REFs 1
  • privileges
    • acquired by role on object types 1
    • ALTER ANY TYPE on object types 1
    • checked when pinning object types 1
    • column level for object tables 1
    • DELETE on object types 1
    • DROP ANY TYPE on object types 1
    • EXECUTE ANY TYPE on object types 1 , 2
    • EXECUTE ANY TYPE on object types with ADMIN OPTION 1
    • EXECUTE on object types 1
    • INSERT on object types 1
    • object types in types or tables 1
    • object types with CREATE TYPE 1
    • object types with INSERT 1
    • on object types 1 , 2
    • SELECT on object types 1
    • system on object types 1
    • UNDER ANY TYPE on object types 1
    • UNDER ANY VIEW on object types 1
    • UPDATE on object types 1
  • Pro*C
    • embedded SQL with user-defined data types 1
    • object cache 1
  • Pro*C/C++
    • associative access 1
    • converting between Oracle and C types 1
    • navigational access 1
    • user-defined data types 1
  • programmatic environments
    • for Oracle objects 1 , 2

Q

  • queries
    • set membership 1
    • unnesting 1
    • varrays 1

R

  • recompilation
    • object types 1
  • redefining
    • methods 1
  • REF attributes 1
  • REF columns 1
  • references 1
  • references See REFs 1
  • REF function
    • manipulating objects in PL/SQL 1
  • REFs
    • comparing 1
    • constraints on 1 , 2
    • constructing from object identifiers 1
    • dangling 1 , 2 , 3
    • dereferencing 1
    • dereferencing of 1
    • implicit dereferencing of 1
    • indexes on 1
    • indexing 1
    • obtaining 1
    • pinning 1 , 2
    • scoped 1 , 2 , 3 , 4
    • size of 1
    • storage 1
    • substitutability 1
    • substitutability in 1
    • use of table aliases 1
    • WITH ROWID option 1
  • remote databases
    • using with object types 1
  • RESOURCE role
    • user-defined types 1
  • return entire result sets
    • BULK COLLECT 1
  • roles
    • DBA role 1
    • RESOURCE role 1
  • row objects
    • storage 1

S

  • sample schemas, hr schema 1
  • schemas
    • object data types 1
    • object types 1
    • qualifying column names 1
  • scoped REFs 1 , 2
  • See also dereferencing 1 , 2
  • SELECT privilege
    • for object tables 1
  • SELF parameter
    • methods 1
  • SET function 1
  • single inheritance 1
  • SQL
    • support for object types 1
    • user-defined data types
      • OCI 1
  • SQLJ
    • See: Oracle SQL
  • SQLJ object types
    • creating 1
    • mapping Java classes 1
  • static dispatch 1
  • static methods 1 , 2
  • storage
    • column objects 1
    • nested tables 1
    • object tables 1
    • REFs 1
  • storing nested tables 1
  • Storing XMLTypes and LOBs in an ANYDATA column 1
  • SUBMULTISET condition 1
  • subprograms
    • overloading and inheritance 1
    • roles with invoker’s rights 1
  • substitutability
    • attributes 1
    • collections 1
    • column and row 1 , 2
    • constraining 1
    • dependencies 1
    • modifying 1
    • narrowing 1
    • OBJECT_ID 1
    • OBJECT_VALUE 1
    • restrictions on modifying 1
    • turning off 1
    • views 1
    • views and 1
    • widening
      • assignment widening 1
  • substitutability of object types
    • with overloading 1
  • substitutable columns
    • dropping subtypes 1
  • subtypes
    • creating 1
    • dropping in substitutable columns 1
    • hierarchy 1
    • indexing attributes of 1
    • multiple 1
    • object types 1
    • specializing 1
    • with supertype attribute 1
  • supertypes
    • attribute of subtype 1
    • base in hierarchy 1
  • synonyms
    • object types 1
  • SYS_TYPEID function 1 , 2
  • system privileges
    • ADMIN OPTION 1
    • object types 1

T

  • TABLE
    • function 1
  • Table Dependencies 1
  • TABLE expression 1 , 2
  • TABLE expressions 1 , 2
  • TABLE expression subqueries
    • restrictions 1
  • tables
    • aliases 1
    • constraints on object tables 1
    • functions 1
    • indexes on nested tables 1
    • nested tables 1
    • object tables
      • virtual 1
    • qualifying column names 1 , 2
  • transient data type 1
  • TREAT function 1 , 2 , 3 , 4 , 5
  • triggers
    • INSTEAD OF triggers
      • object views and 1
    • object types 1
  • type dependencies 1
  • Type Dependencies 1
  • type evolution 1
    • See: object types
  • type hierarchies
    • methods in 1
  • typeids 1 , 2
  • type inheritance
    • finality 1
    • instantiability 1
    • methods 1
    • object types 1
    • specializing subtypes 1
  • types
    • See: data types, object types

U

  • UNDER ANY TYPE privilege 1
    • See also: privileges
  • UNDER ANY VIEW privilege 1
    • See also: privileges
  • UNDER keyword
    • CREATE TYPE 1
  • uninitialized object
    • how treated in PL/SQL 1
  • unnesting queries 1
  • unnesting queries to collections 1
  • unnesting queries with multilevel collections 1
  • UPDATE privilege
    • for object tables 1
  • updates
    • object views 1
  • UPGRADE..STORE AS 1
  • user-defined aggregate functions 1
  • user-defined constructors 1 , 2
  • user-defined data types 1
    • See: object types
  • user-defined types
    • and remote databases 1
  • utilities supporting objects 1

V

  • validation
    • object types 1
  • VALUE function 1 , 2
  • variables
    • bind variables
      • object types 1
    • object variables 1
  • varrays
    • accessing 1
    • creating 1
    • creating VARRAYs 1
    • increasing the number of elements 1
    • querying 1
    • storage 1 , 2
    • updating 1
  • views
    • object 1
    • substitutability 1
    • updatability 1

W

  • widening
    • and substitutability 1 , 2

X

  • XML 1
  • XMLType 1
  • XMLTypes and LOBs in an ANYDATA column 1
  • XMLType views 1