Oracle9i Application Developer's Guide - Object-Relational Features -- Index

,methods

final, 2-36

Active Server Pages, 3-9

ActiveX, 3-9

ADMIN OPTION

with EXECUTE ANY TYPE, 4-3

aggregate functions

See user-defined aggregate functions

ALTER ANY TYPE privilege, 4-2

See also privileges

ALTER TABLE, 6-19

See also object types, evolving

ALTER TYPE

See also object types, evolving

ALTER TYPE statement, 3-22, 6-16

ANYDATA datatype, 6-30, 8-40

ANYDATASET datatype, 6-30

ANYTYPE datatype, 6-30

arrays, 9-24

size of VARRAYs, 2-21

variable (VARRAYs), 2-21

ASP, 3-9

atomic nulls, 2-8

attributes

leaf-level, 6-2

leaf-level scalar, 6-2

modifying, 6-14

of object types, 2-2

bind variables

user-defined types, 3-2

caches

object cache, 3-2, 3-7, 4-5

object views, 5-4

capture avoidance rule, 2-13

collections, 2-6, 2-21 to 2-33

assigning, 2-48

comparing, 2-26, 2-49

constructing, 2-7

creating, 2-26

DML on, 2-31

multi-level, 2-23, 8-12

constructing, 2-27

creating, 2-27

creating with REFs, 8-23

DML, 2-32

object views containing, 5-8

nested tables, 2-22

querying, 2-27, 8-12

See also varrays, nested tables

substituting in, 2-42

variable arrays (VARRAYs), 2-21

column objects

versus row objects, 8-3

COLUMN_VALUE keyword, 2-24

columns

column names

qualifying in queries, 2-14

column objects, 2-4

indexes, 2-11

hidden, 6-2, 6-5

qualifying in queries, 2-13

comparison methods, 2-17, 9-18

compilation of object types, 4-6

complex object retrieval

for Oracle Call Interface, 6-25

COMPRESS clause

nested tables, 8-18

CONNECT role

user-defined types, 4-2, 4-3

constraints, 9-23

object tables, 2-10

on Oracle objects, 8-36

REFs, 8-10

SCOPE FOR constraint, 9-28, 9-30

constructor methods, 2-15, 2-20, 6-2

literal invocation of, 2-9

COUNT attribute of collection types, 9-19

CREATE ANY TYPE privilege, 4-2

See also privileges

CREATE INDEX statement

object types, 2-11

CREATE TABLE statement

examples

column objects, 2-8, 2-14

nested tables, 2-23

object tables, 2-4, 2-11, 2-14, 2-23

CREATE TRIGGER statement

examples

object tables, 2-12

CREATE TYPE privilege, 4-2

See also privileges

CREATE TYPE statement, 8-43

incomplete types, 4-6

nested tables, 2-10, 2-22

object types, 2-4, 2-7, 2-8, 2-9, 2-14, 9-12

object views, 5-3

varrays, 2-21, 9-13

CREATE TYPEstatement

nested tables, 2-7

CREATE VIEW statement

examples

object views, 5-4

CustomDatum interface, 3-16

dangling REFs, 2-5, 2-6

database administrators (DBAs)

DBA role, 4-2

database links, 2-15

datatypes

array types, 2-21

nested tables, 2-22

See also object types, user-defined types

transient and generic, 6-30

DBA role

user-defined types, 4-2

default values

collections, 2-9

user-defined types, 2-9

DELETE privilege for object tables, 4-4, 4-5

DEREF function, 2-50

dereferencing, 2-6, 9-20

implicit, 2-6, 9-20

dot notation, 2-16

DROP ANY TYPE privilege, 4-2

See also privileges

DROP TYPE statement, 4-8

dump files

Export and Import, 4-10

Excel, 3-9

EXECUTE ANY TYPE privilege, 4-2, 4-3

See also privileges

EXECUTE privilege

user-defined types, 4-3

See also privileges

Export utility

user-defined types, 4-10

EXTERNAL NAME phrase, 3-15

FAQ

for Oracle objects, 7-1

features, new, xxvi

files

Export and Import dump file, 4-10

FINAL keyword, 2-36

modifying finality, 6-15, 8-38

FORCE keyword, 5-19

FORCE option, 4-8

foreign keys

representing many-to-one entity relationship with, 9-7

frequently asked questions

about Oracle objects, 7-1

function-based indexes

on type methods, 8-33

GRANT option for EXECUTE privilege, 4-3

granting

execute user-defined type, 4-3

implicit dereferencing, 2-6, 9-20

Import utility

user-defined types, 4-10

incomplete object types, 4-6, 9-12

indexes

on REFs, 2-11

type-discriminant column, 6-5

user-defined types, 2-11

index-organized tables

storing nested tables as, 2-25, 8-17

inheritance, 2-3

See<$Default Para Font

inner capture, 2-13

INSERT privilege for object tables, 4-4, 4-5

INSTANTIABLE keyword, 2-37

modifying instantiability, 6-15

INSTEAD OF triggers

nested tables, 5-14

invoker-rights

object types, 8-31

IS OF type predicate, 2-52

Java

Oracle JDBC and Oracle objects, 3-12

Oracle SQLJ and Oracle objects, 3-12

with Oracle objects, 3-11

Java object storage, 3-14

JDBC

See Oracle JDBC

JPublisher, 3-13

keys

foreign keys, 9-7

leaf-level attributes, 6-2

leaf-level scalar attributes, 6-2

literal invocation

constructor methods, 2-9

locators, 9-28

returning nested tables as, 6-34, 8-20

locks

object level locking, 3-3

map methods, 2-17, 8-8, 9-15

materialized views, 8-35

method dispatch, 2-40

methods, 2-3, 2-15, 9-19

execution privilege for, 4-2

choosing a language for, 8-29

comparison, 9-18

comparison methods, 2-17

in a type hierarchy, 2-19

constructor methods, 2-20, 6-2

literal invocation, 2-9

dropping, 6-14

function-based indexes, 8-33

inheriting, 2-38

instantiability, 2-37

invoking, 2-16

map, 2-17, 8-8, 9-15

member, 2-16

of object types, 2-2

order, 2-18, 8-8, 9-15, 9-21

overloading, 2-38

overriding, 2-36, 2-38, 2-39

PL/SQL, 3-2

SELF parameter, 2-16

static, 2-20, 8-30

multi-level collections

See collections, multi-level

narrowing, 2-47, 2-51

nested tables, 2-22, 8-16

COMPRESS clause, 8-18

creating, 2-26

creating indexes on, 8-19

DML operations on, 8-21

in an index-organized table, 2-25, 8-17

indexes, 2-11

INSTEAD OF triggers, 5-14

querying, 2-27, 9-16

unnesting results, 2-28

returning as locators, 8-20, 9-28

storage, 2-24, 8-16, 9-27

uniqueness in, 9-28

updating in views, 5-14

vs VARRAY, 9-16

vs varrays, 9-13

NESTED_TABLE_ID keyword, 2-25, 8-19, 9-27

new features, xxvi

nulls

atomic, 2-8

object types, 2-8

objec viewts

OIDs with, 5-9

object cache

flushing an object, 6-25

object views, 5-4

OCI, 3-2

privileges, 4-5

Pro*C, 3-7

object identifiers, 6-7, 9-24

for object types, 6-2

primary-key based, 8-8

REFs, 8-9

storage, 8-8

WITH OBJECT IDENTIFIER clause, 5-4

object instances, 2-2, 2-3

comparing, 2-48

object tables, 2-3, 8-7, 9-21

constraints, 2-10

deleting values, 9-37

indexes, 2-11

inserting values, 9-32

querying, 9-35

replicating, 8-35

row objects, 2-4

triggers, 2-12

virtual object tables, 5-2

object types

assignments across, 2-46

attributes of, 2-2

column objects, 2-4

indexes, 2-11

column objects vs. row objects, 8-3

comparison methods for, 2-17, 9-18

constructor methods for, 2-20, 6-2

creating, 2-7

creating subtypes of, 2-37

dependents, 4-5, 6-8

evolving, 6-8 to 6-20, 8-39

design considerations, 8-37

SQLJ types, 3-22

final/not final, 2-36, 8-38

incomplete, 4-6, 4-7, 9-12

indexing, 6-5

instantiable/not instantiable, 2-37

invoker-rights, 8-31

locking in cache, 3-3

methods of, 2-2, 9-19

PL/SQL, 3-2

mutually dependent, 4-5

Oracle type translator, 3-9

remote access to, 2-15, 5-15

row objects, 2-4

See also type inheritance

specializing, 2-3

SQLJ types, 3-14

substituting, 2-41

use of table aliases, 2-14

object views, 5-1 to 5-20

advantages of, 5-2

circular references, 5-17

defining, 5-3

hierarchies, 5-21, 8-40

privileges, 5-29

querying in, 5-28

modeling relationships, 5-12, 5-16

multi-level collections in, 5-8

nested tables, 5-14

null objects in, 5-6

REFs to, 5-11

replicating, 8-35

updating through INSTEAD OF triggers, 5-13

object-relational model, 9-1

comparing objects, 8-8

constraints, 8-36

design considerations, 8-1

embedded objects, 9-24

implementing with object tables, 9-12

limiations of relational model, 1-2

methods, 2-3, 2-15

new object format, 8-34

partitioning, 6-32

programmatic environments for, 3-1 to 3-11

replication, 8-35

objects

collection objects, 5-6

comparing, 2-48

in columns, 5-4

object references, 5-11

row objects and object identifiers, 5-6

OCCI, 3-6

OCI

associative access, 3-3

complex object retrieval (COR), 6-25

creating a new object, 6-21

deleting an object, 6-22

for Oracle objects

building a program, 3-5

initializing object manipulation, 6-20

lock options, 6-24

navigational access, 3-4

object cache, 3-4, 6-28

flushing an object, 6-25

OCIObjectFlush, 5-4

OCIObjectPin, 5-4

pinning and unpinning objects, 6-22

updating an object, 6-22

OIDs

See object identifiers

Oracle Call Interface

controlling object cache size, 6-22

Oracle JDBC

accessing Oracle object data, 3-12

Oracle objects

See object-relational model

Oracle Objects for OLE

OraCollection interface, 3-11

OraObject interface, 3-10

OraRef interface, 3-11

Oracle SQLJ

creating custom Java classes, 3-13

JPublisher, 3-13

support for Oracle objects, 3-12

Oracle type translator (OTT), 3-9

OraCollection interface, 3-11

ORAData interface, 3-16

OraObject interface, 3-10

OraRef interface, 3-11

order methods, 2-18, 8-8, 9-15, 9-21

OTT, 3-9

parallel query

restrictions for Oracle objects, 8-39

view objects, 6-33

partitioning

tables containing Oracle objects, 6-32

pkREFs, 6-4

PL/SQL

bind variables

user-defined types, 3-2

object views, 5-4

polymorphism, 2-33, 8-40

See also substitutability

pragma RESTRICT_REFERENCES, 9-18

primary-key-based REFs, 6-4

privileges

system

user-defined types, 4-2

user-defined types

acquired by role, 4-2

ALTER ANY TYPE, 4-2

checked when pinning, 4-5

column level for object tables, 4-5

CREATE ANY TYPE, 4-2

CREATE TYPE, 4-2

DELETE, 4-4, 4-5

DROP ANY TYPE, 4-2

EXECUTE, 4-3

EXECUTE ANY TYPE, 4-2, 4-3

EXECUTE ANY TYPE with ADMIN OPTION, 4-3

EXECUTE with GRANT option, 4-3

INSERT, 4-4, 4-5

SELECT, 4-4, 4-5

system privileges, 4-2

UPDATE, 4-4, 4-5

using, 4-3

Pro*C/C++

associative access, 3-8

converting between Oracle and C types, 3-8

navigational access, 3-8

user-defined datatypes, 3-2

programmatic environments

for Oracle objects, 3-1 to 3-11

queries

set membership, 8-21

unnesting, 8-12

varrays, 8-15

REF function, 2-50

REFs, 2-5

comparing, 2-49

constraints on, 2-12, 8-10

constructing from object identifiers, 6-2

dangling, 2-5, 2-6, 2-12

dereferencing of, 2-6, 9-20

for rows of object views, 5-3

implicit dereferencing of, 2-6, 9-20

indexes on, 2-11

indexing, 8-11

object identifiers, 9-24

obtaining, 2-6

pinning, 4-5, 5-4

scoped, 2-5, 2-12, 6-4, 8-10

size of, 6-4

storage, 8-10

substitutability and, 2-42, 2-45

use of table aliases, 2-14

WITH ROWID option, 8-12

RESOURCE role

user-defined types, 4-2, 4-3

returning nested tables as, 9-28

roles

CONNECT role, 4-2, 4-3

DBA role, 4-2

RESOURCE role, 4-2, 4-3

row objects, 2-4

storage, 8-7

rows

row objects, 2-4

schema names

qualifying column names, 2-14

schemas

user-defined datatypes, 3-2

user-defined types, 2-2

SCOPE FOR constraint, 9-28, 9-30

scoped REFs, 2-5, 6-4

SELECT privilege for object tables, 4-4, 4-5

SELF parameter, 2-16

SQL

user-defined datatypes, 3-2

embedded SQL, 3-7

OCI, 3-3

SQLData interface, 3-16

SQLJ

See Oracle SQLJ

SQLJ object types, ?? to ?? to 3-11, 8-41

creating, 3-16

mapping Java classes, 3-16, 3-22

SQLJ types, 3-14 to 3-24

See also object types, Oracle SQLJ

storage

column objects, 8-3

nested tables, 6-4

object tables, 6-2

REFs, 6-4

STORE AS clause, 9-27

substitutability, 2-41

attribute, 2-42

collections and, 2-42

column and row, 2-43, 6-5

constraining, 2-46

dependencies, 4-7

narrowing, 2-47

turning off, 2-45

views and, 2-43, 8-40

widening, 2-46

subtypes, 2-33, 2-44

creating, 2-36

indexing attributes of, 6-6

specializing, 8-39

supertypes, 2-33, 2-44

SYS_TYPEID function, 2-54, 6-5

system privileges

ADMIN OPTION, 4-3

user-defined types, 4-2

See also privileges

table aliases, 2-13

TABLE expressions, 2-28, 8-12

tables

nested tables, 2-22

indexes, 2-11

object

See object tables

object tables, 2-3

constraints, 2-10

indexes, 2-11

triggers, 2-12

virtual, 5-2

qualifying column names, 2-13, 2-14

TREAT, 2-43

TREAT function, 2-47, 2-51

triggers

INSTEAD OF triggers

object views and, 5-13

user-defined types, 2-12

type dependencies, 4-7

type evolution

See object types

type hierarchies, 2-33

methods in, 2-19

type hierarchy, 2-3

type inheritance, 2-33 to 2-49

finality, 2-36

instantiability, 2-37

See<$Default Para Font

specializing subtypes, 2-34

typeids, 2-54, 6-5

types

See datatypes, object types

UNDER keyword, 2-36

unnesting queries, 8-12

UPDATE privilege for object tables, 4-4, 4-5

updates

object views, 5-13

user-defined aggregate functions, 6-31

user-defined datatypes, 4-1 to ??

and remote databases, 2-15

collections

nested tables, 2-22

variable arrays (VARRAYs), 2-21

Export and Import, 4-10

incomplete types, 4-5

object types

use of table aliases, 2-14

privileges, 4-2

See also object-relational model

storage, 6-2

USING clause, 3-15

validatation, 6-15

validation, 6-12

VALUE function, 2-49

variables

bind variables

user-defined types, 3-2

object variables, 5-4

VARRAY

vs nested tables, 9-16

varrays, 2-21

accessing, 8-15

creating, 2-26

querying, 8-15

See also arrays, collections

storage, 2-25, 8-15

updating, 8-16

vs nested tables, 9-13

views

See also object views

substitutability, 2-43

updatability, 5-13

Visual Basic, 3-9

widening, 2-46

WITH OBJECT IDENTIFIER clause, 5-4

Index

Symbols

A

B

C

D

E

F

G

I

J

K

L

M

N

O

P

Q

R

S

T

U

V

W