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