Index

Symbols  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.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
  • 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
  • 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

B

  • bind variables
    • object types 4.3
  • BULK COLLECT clause 5.3.3

C


D

  • dangling REFs 1.3.1.6.2, 1.3.1.7
  • database administrators (DBAs)
  • database links
  • 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 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
  • dump files
    • Export and Import 4.9.1
  • dynamic method dispatch 2.3.10, 3.3
  • dynamic SQL 3.4

E

  • editions
  • equal and not equal conditions
  • equipartitioning
    • nested tables
      • partitioning 5.4
  • evolution
  • EXECUTE ANY TYPE privilege 7.1.1, 7.1.3
    • See also: privileges
  • EXECUTE privilege 7.1.3
    • See also: privileges
  • executing SQL statements at run time 3.4
  • export object types 4.9.1
  • Export utility

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

G

  • generalized expression 2.3.5.3
  • generalized method invocation 2.3.5.3
  • generic data type 8.6
  • generic programming 8.6
  • guidelines

I

  • implicit dereferencing 1.3.1.7
  • importing object tables 4.9.1
  • import object types 4.9.1
  • Import utility
  • incomplete object types 7.2.1
  • IN condition 5.3.4.2
  • indexes
  • index-organized tables 5.2.1
  • 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
    • CREATE TYPE 2.3.6
    • modifying instantiability 8.3.7
  • INSTEAD OF triggers
  • 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


M


N


O


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


R


S


T


U

  • UNDER ANY TYPE privilege 7.1.1
    • See also: privileges
  • UNDER ANY VIEW privilege 7.1.1
    • See also: privileges
  • UNDER keyword
  • 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
  • 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


W


X

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