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, 3-9

ActiveX, 3-9

ADMIN OPTION

with EXECUTE ANY TYPE, 2-11

ALTER ANY TYPE privilege, 2-10

See also privileges

arrays, 9-26

size of VARRAYs, 1-8

variable (VARRAYs), 1-8

ASP, 3-9

atomic nulls, 2-2

attributes

leaf-level, 7-1

leaf-level scalar, 7-1

of object types, 1-3

---

B

bind variables

user-defined types, 3-2

---

C

caches

object cache, 2-13, 3-2, 3-6

object views, 5-4

capture avoidance rule, 2-7

collections

nested tables, 1-9

nesting, 6-20

querying, 6-12

variable arrays (VARRAYs), 1-8

column objects

vs. row objects, 6-1

columns

column names

qualifying in queries, 2-7

column objects, 1-6

indexes, 2-4

qualifying in queries, 2-6

comparison methods, 1-4, 9-20

compilation of object types, 2-14

complex object retrieval

for Oracle Call Interface, 7-9

COMPRESS clause

nested tables, 6-16

CONNECT role

user-defined types, 2-11

constraints, 9-25

object tables, 2-3

on Oracle objects, 6-37

REFs, 6-9

SCOPE FOR constraint, 9-30, 9-32

constructor methods, 1-4, 7-2

literal invocation of, 2-3

COUNT attribute of collection types, 9-21

CREATE ANY TYPE privilege, 2-10

See also privileges

CREATE INDEX statement

object types, 2-5

CREATE TABLE statement

examples

column objects, 1-11, 2-7

nested tables, 1-10

object tables, 1-5, 1-10, 2-4, 2-7

CREATE TRIGGER statement

examples

object tables, 2-5

CREATE TYPE command

nested tables, 1-9, 1-11

CREATE TYPE privilege, 2-10

See also privileges

CREATE TYPE statement

incomplete types, 2-14

nested tables, 2-3

object types, 1-10, 2-2, 2-3, 2-7, 9-14

object views, 5-3

varrays, 1-9, 9-15

CREATE VIEW statement

examples

object views, 5-4

---

D

dangling REFs, 1-7

database administrators (DBAs)

DBA role, 2-11

datatypes

array types, 1-8

nested tables, 1-9

object types, 1-2

DBA role

user-defined types, 2-11

default values

user-defined types, 2-3

DELETE privilege for object tables, 2-12, 2-13

dependencies

object type definitions, 2-14, 2-15

dereferencing, 1-7, 9-22

implicit, 1-7, 9-22

dot notation, 1-3

DROP ANY TYPE privilege, 2-11

See also privileges

DROP TYPE statement

FORCE option, 2-15

dump files

Export and Import, 2-16

---

E

Excel, 3-9

EXECUTE ANY TYPE privilege, 2-11

See also privileges

EXECUTE privilege

user-defined types, 2-11

See also privileges

EXECUTE user-defined type, 2-11

Export utility

user-defined types, 2-16

---

F

FAQ

for Oracle objects, 8-1

files

Export and Import dump file, 2-16

FORCE option

object type dependencies, 2-15

foreign keys

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

frequently asked questions

about Oracle objects, 8-1

function-based indexes

returning values of type methods, 6-30

---

G

GRANT option for EXECUTE privilege, 2-11

granting

execute user-defined type, 2-11

---

I

implicit dereferencing, 1-7, 9-22

Import utility

user-defined types, 2-16

incomplete object types, 2-14, 9-14

indexes

on REFs, 2-4

user-defined types, 2-4

index-organized tables

storing nested tables as, 6-15

inheritance, 1-10

dual subtype/super-type reference, 6-36

subtype contains super-type, 6-33

super-type contains all subtypes, 6-35

inner capture, 2-7

INSERT privilege for object tables, 2-12, 2-13

INSTEAD OF triggers

nested tables, 5-11

invoker-rights

object types, 6-29

---

J

Java

Oracle JDBC and Oracle objects, 3-12

Oracle SQLJ and Oracle objects, 3-12

with Oracle objects, 3-12

JDBC

See Oracle JDBC

---

K

keys

foreign keys, 9-7

---

L

leaf-level attributes, 7-1

leaf-level scalar attributes, 7-1

literal invocation

constructor methods, 2-3

locators, 9-30

returning nested tables as, 6-18

locks

object level locking, 3-3

---

M

map methods, 1-5, 6-7, 9-17

methods, 1-3

choosing a language for, 6-26

comparison, 9-20

comparison methods, 1-4

constructor methods, 1-4

literal invocation, 2-3

function-based indexes, 6-30

map, 6-7, 9-17

of object types, 1-3, 9-21

constructor methods, 7-2

execution privilege for, 2-11

map methods, 1-5

order methods, 1-5

PL/SQL, 3-2

selfish style of invocation, 1-4

use of empty parentheses with, 2-8

order, 6-7, 9-17, 9-23

static, 6-28

---

N

nested tables, 1-9, 6-14

COMPRESS clause, 6-16

creating indexes on, 6-17

DML operations on, 6-19

in an index-organized table, 6-15

indexes, 2-4

INSTEAD OF triggers, 5-11

querying, 9-18

returning as locators, 6-18, 9-30

storage, 6-14, 9-29

uniqueness in, 9-30

updating in views, 5-11

vs VARRAY, 9-18

vs varrays, 9-15

NESTED_TABLE_ID, 6-17, 9-29

nulls

atomic, 2-2

object types, 2-2

---

O

object cache

flushing an object, 7-9

object views, 5-4

OCI, 3-2

privileges, 2-13

Pro*C, 3-6

object identifiers, 9-26

for object types, 7-2

primary-key based, 6-7

REFs, 6-8

storage, 6-7

WITH OBJECT IDENTIFIER clause, 5-4

object tables, 1-5, 6-7, 9-23

constraints, 2-3

deleting values, 9-39

indexes, 2-4

inserting values, 9-34

querying, 9-37

row objects, 1-6

triggers, 2-5

virtual object tables, 5-2

object types, 1-2

attributes of, 1-3

column objects, 1-6

indexes, 2-4

column objects vs. row objects, 6-1

comparison methods for, 1-4, 9-20

constructor methods for, 1-4, 7-2

incomplete, 2-14, 9-14

invoker-rights, 6-29

locking in cache, 3-3

methods of, 1-3, 9-21

method calls, 2-8

PL/SQL, 3-2

mutually dependent, 2-14

Oracle type translator, 3-8

purchase order example, 1-10

row objects, 1-6

use of table aliases, 2-7

object views, 5-1 to 5-18

advantages of, 5-2

defining, 5-3

nested tables, 5-11

updating through INSTEAD OF triggers, 5-11

object-relational model, 9-1

comparing objects, 6-7

constraints, 6-37

design considerations, 6-1

embedded objects, 9-26

implementing with object tables, 9-14

inheritance, 1-10

limiations of relational model, 9-11

methods, 1-3

new object format, 6-31

partitioning, 7-14

programmatic environments for, 3-1 to ??

replication, 6-31

type evolution, 6-38

objects

collection objects, 5-6

in columns, 5-4

object references, 5-9

row objects and object identifiers, 5-6

OCI

associative access, 3-3

complex object retrieval (COR), 7-9

creating a new object, 7-4

deleting an object, 7-5

for Oracle objects

building a program, 3-5

initializing object manipulation, 7-4

lock options, 7-8

navigational access, 3-4

object cache, 3-4, 7-11

flushing an object, 7-9

OCIObjectFlush, 5-4

OCIObjectPin, 5-4

pinning and unpinning objects, 7-6

updating an object, 7-5

OIDs

See object identifiers

Oracle Call Interface

controlling object cache size, 7-5

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-10

Oracle SQLJ

creating custom Java classes, 3-13

JPublisher, 3-13

support for Oracle objects, 3-12

Oracle type translator (OTT), 3-8

OraCollection interface, 3-11

OraObject interface, 3-10

OraRef interface, 3-10

order methods, 1-5, 6-7, 9-17, 9-23

OTT, 3-8

---

P

parallel query

restrictions for Oracle objects, 6-38

parentheses, use of in method calls, 2-8

partitioning

tables containing Oracle objects, 7-14

pkREFs, 7-2

PL/SQL

bind variables

user-defined types, 3-2

object views, 5-4

user-defined datatypes, 3-2

pragma RESTRICT_REFERENCES, 9-20

primary-key-based REFs, 7-2

privileges

system

user-defined types, 2-10

user-defined types

acquired by role, 2-11

ALTER ANY TYPE, 2-10

checked when pinning, 2-13

column level for object tables, 2-14

CREATE ANY TYPE, 2-10

CREATE TYPE, 2-10

DELETE, 2-12, 2-13

DROP ANY TYPE, 2-11

EXECUTE, 2-11

EXECUTE ANY TYPE, 2-11

EXECUTE ANY TYPE with ADMIN OPTION, 2-11

EXECUTE with GRANT option, 2-11

INSERT, 2-12, 2-13

SELECT, 2-12, 2-13

system privileges, 2-10

UPDATE, 2-12, 2-13

using, 2-11, 2-15

Pro*C/C++

associative access, 3-6

converting between Oracle and C types, 3-7

navigational access, 3-6

user-defined datatypes, 3-2

programmatic environments

for Oracle objects, 3-1 to 3-12

---

Q

queries

set membership, 6-18

unnesting, 6-12

varrays, 6-14

---

R

REFs, 1-6

constraints on, 6-9

constructing from object identifiers, 7-2

dangling, 1-7

dereferencing of, 1-7, 9-22

for rows of object views, 5-3

implicit dereferencing of, 1-7, 9-22

indexes on, 2-4

indexing, 6-10

mutually dependent types, 2-14

object identifiers, 9-26

pinning, 2-13, 5-4

scoped, 1-7, 6-9, 7-2

size of, 7-2

storage, 6-9

use of table aliases, 2-7

WITH ROWID option, 6-11

RESOURCE role

user-defined types, 2-11

returning nested tables as, 9-30

REVOKE command

object types and dependencies, 2-15

REVOKE statement

FORCE option, 2-15

roles

CONNECT role, 2-11

DBA role, 2-11

RESOURCE role, 2-11

row objects, 1-6

storage, 6-7

rows

row objects, 1-6

---

S

schema names

qualifying column names, 2-7

schemas

user-defined datatypes, 3-2

user-defined types, 1-2

SCOPE FOR constraint, 9-30, 9-32

scoped REFs, 1-7, 7-2

SELECT privilege for object tables, 2-12, 2-13

selfish style of method invocation, 1-4

SQL

user-defined datatypes, 3-1

embedded SQL, 3-6

OCI, 3-2

SQLJ

See Oracle SQLJ

storage

nested tables, 7-3

object tables, 7-1

REFs, 7-2

STORE AS clause, 9-29

system privileges

ADMIN OPTION, 2-11

user-defined types, 2-10

See also privileges

---

T

TABLE syntax, 6-12

tables

nested tables, 1-9

indexes, 2-4

object

See object tables

object tables, 1-5

constraints, 2-3

indexes, 2-4

triggers, 2-5

virtual, 5-2

qualifying column names, 2-6, 2-7

triggers

INSTEAD OF triggers

object views and, 5-11

user-defined types, 2-5

type evolution, 6-38

types

See datatypes, object types

---

U

unnesting queries, 6-12

UPDATE privilege for object tables, 2-12, 2-13

updates

object views, 5-11

user-defined datatypes, 2-1 to 2-16

collections

nested tables, 1-9

variable arrays (VARRAYs), 1-8

Export and Import, 2-15

incomplete types, 2-14

object types, 1-2

use of table aliases, 2-7

privileges, 2-10

See also object-relational model

storage, 7-1

---

V

variables

bind variables

user-defined types, 3-2

object variables, 5-4

VARRAY

vs nested tables, 9-18

varrays, 1-8

accessing, 6-14

querying, 6-14

See also arrays, collections

storage, 6-13

updating, 6-14

vs nested tables, 9-15

views

See also object views

updatability, 5-11

Visual Basic, 3-9

---

W

WITH OBJECT IDENTIFIER clause, 5-4