Index

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

---

Symbols

%ROWTYPE attribute, 6.1.2.2.3

%TYPE attribute, 6.1.2.2.3

---

Numerics

32-bit IEEE 754 format, 2.3.2.1

3GL (third-generation language), 6.7.4

64-bit IEEE 754 format, 2.3.2.1

---

A

Abstract Data Type (ADT)

editions and, 19.1.1.2

resetting evolved, 19.1.1.3

Active Server Pages (ASP), 10.4

actual object, 19.1.3

actualization

in general, 19.1.3

schema object dependency and, 19.1.3.2

address of row (rowid), 2.7

ADT

editions and, 19.1.1.2

resetting evolved, 19.1.1.3

AFTER SUSPEND trigger, 1.9.2.1

agent, 16.3

Agent Control Utility (agtctl)

commands

in shell mode, A.3.3

in single-line mode, A.3.2

list of, A.3.1

extproc administration and, A.3

extproc architecture and, A.2

aggregate function, 6.11

altering application online

See edition-based redefinition

ancestor edition, 19.1.2

anonymous block, 6.1.1

ANSI data type, 2.5.7

ANYDATA data type, 2.5.6

ANYDATASET data type, 2.5.6

AP (application program), 15.1.1

application architecture, 13.1

application domain index, 4.3

application program (AP), 15.1.1

application SQL, 19.3.3.2.3

APPLYING_CROSSEDITION_TRIGGER function, 19.3.4.1.1

AQ (Oracle Advanced Queuing), 16.2.2

archive

See Flashback Data Archive

ARGn data type, 2.9.1

arithmetic operation

with datetime data type, 2.4.4

with native floating-point data type, 2.3.4

ASP (Active Server Pages), 10.4

assignment

data type conversion during, 2.8.1, 2.8.1

reported by PL/Scope, 7.6

attribute

%ROWTYPE, 6.1.2.2.3

%TYPE, 6.1.2.2.3

Java STATIC class, 6.9.4.3

auditing policy, editioning view and, 19.5.1

Automatic Undo Management system, 12.1

autonomous transaction

in general, 1.8

trigger as, 1.9.2.1

---

B

backward compatibility

LONG and LONG RAW data types for, 2.5.3.2

RESTRICT_REFERENCES pragma for, 6.9.4.4

BATCH commit redo option, 1.2.4

BFILE data type, 2.5.3.1

binary format, 2.3.2.1

binary internal ROWID format, 2.7.2.3

binary large object (BLOB) data type, 2.5.3.1

binary number, 2.3.2

BINARY_DOUBLE data type, 2.3

BINARY_FLOAT data type, 2.3

BLOB data type, 2.5.3.1

block, anonymous, 6.1.1

branch, 15.1.1

built-in function

See SQL function

bulk binding

in general, 6.1.2.14

when to use, 6.1.2.15

---

C

C external subprogram

callback with, 14.13

global variable in, 14.13.6

interface between PL/SQL and, 14.5.2

invoking, 14.10.4

loading, 14.4.2

passing parameter to, 14.9

publishing, 14.7

running, 14.10

service routine and, 14.12

See also external subprogram

C++ Class Library, 13.11.5

call specification

for external subprogram, 14.3

location of, 14.8

CALL statement, 14.10

calling subprogram

See invoking subprogram

cascading invalidation, 18.4

CHANGE_DUPKEY_ERROR_INDEX hint, 19.3.4.1.1

CHAR data type

compared to VARCHAR2 data type, 2.2.2

specifying length of, 2.2.1

values stored, 2.2

character data type class, 18.10.2.4

character data types, 2.2

character large object (CLOB) data type, 2.5.3.1

CHECK constraint

compared to NOT NULL constraint, 5.6.4

designing, 5.6.2

multiple, 5.6.3

naming, 5.7.2

restrictions on, 5.6.1

when to use, 5.6

client notification, 16.2.3

client/server architecture, 13.1.1

CLOB data type, 2.5.3.1

coarse-grained invalidation, 18.4

collection

edition and, 19.1.1.2

referenced by DML statement, 6.1.2.15.1

referenced by FOR loop, 6.1.2.15.3

referenced by SELECT statement, 6.1.2.15.2

column

default value for

setting, 5.1.6

when to use, 5.1.5

multiple foreign key constraints on, 5.2.3

specifying length of, 2.2.1

commit redo management, 1.2.4

COMMIT statement, 1.2.3

committing transaction, 1.2.3

comparison operator, 2.3.3

compile-time error, handling

in general, 6.4

for multilanguage program, 14.11

composite FOREIGN KEY constraint, 5.2

concurrency

serializable transaction for, 1.7

under explicit locking, 1.5.5

conditional expression represented as data, 2.6

connection pool, 13.6.1

constraint

in general, 5.1

altering, 5.9

CHECK

See CHECK constraint

crossedition trigger and

collisions, 19.3.4.1.1

dropping, 19.3.6

deferring checking of, 5.2.4

disabling

effect of, 5.8

existing, 5.8.5, 5.8.5

new, 5.8.3, 5.8.3

reasons for, 5.8.1

dropping, 5.11, 5.11

editioning view and, 19.2.6

enabling

effect of, 5.8

existing, 5.8.4

new, 5.8.2

enforcing business rule with, 5.1.1

exception to, 5.8.7

FOREIGN KEY

See FOREIGN KEY constraint

minimizing overhead of, 5.3

naming, 5.7.2

NOT NULL

See NOT NULL constraint

on view, 5.1.9

PRIMARY KEY

See PRIMARY KEY constraint

privileges needed for defining, 5.7.1

renaming, 5.10

UNIQUE

See UNIQUE constraint

viewing definition of, 5.13

violating, 5.8.7

Continuous Query Notification (CQN), 11

converting data types

See data type conversion

copying on change, 19.1.3

coupling, 15.1.1

CQ_NOTIFICATION$_DESCRIPTOR object, 11.8.1

CQ_NOTIFICATION$_QUERY object, 11.8.3

CQ_NOTIFICATION$_REG_INFO object, 11.6.6.2

CQ_NOTIFICATION$_ROW object, 11.8.4

CQ_NOTIFICATION$_TABLE object, 11.8.2

CQN (Continuous Query Notification), 11

CREATE OR REPLACE optimization

in general, 18.4

actualization and, 19.1.3

crossedition trigger

in general, 19.3

creating, 19.3.4

displaying information about, 19.4

dropping, 19.3.6

execution of, 19.3.3.4

forward, 19.3.1

interaction with editions, 19.3.3

read-only editioning view and, 19.2.1

read-write editioning view and, 19.2.1

reverse, 19.3.2

sharing child cursor and, 19.4

crossedition trigger SQL

forward, 19.3.3.2.1

reverse, 19.3.3.2.2

cross-session PL/SQL function result cache, 6.1.2.7

current date and time, displaying, 2.4.1

current edition, 19.1.6

cursor

in general, 1.4

canceling, 1.4.5

closing, 1.4.4

crossedition trigger and, 19.4

number in session, 1.4.1

Oracle XA application and, 15.3.4

rerunning statement with, 1.4.2

schema object dependency and, 18.11

scrollable, 1.4.3

See also cursor variable

cursor variable

in general, 6.3

declaring, 6.3.1

examples of, 6.3.2

opening, 6.3.1

---

D

data definition language statement

See DDL statement

data integrity

See constraint

data type

in general, 2.1

ANSI, 2.5.7

DB2, 2.5.7

dynamic, 2.5.6

external, 2.1

family of, 2.9.3

for character data, 2.2

for datetime data, 2.4

for geographic data, 2.5.1

for large amount of data, 2.5.3

for multimedia data, 2.5.2

for numeric data, 2.3

for spatial data, 2.5.1

for XML data, 2.5.5

object, 13.11.3

of formal subprogram parameter, 6.1.2.2.2

SQL/DS, 2.5.7

data type class, 18.10.2.4

data type conversion

in general, 2.8

of ANSI and IBM data types, 2.5.7

of datetime data types, 2.4.5

of native floating-point data types, 2.3.5

date

default format for, 2.4.1

default value for, 2.4.3

displaying

current, 2.4.1

in nondefault format, 2.4.2

inserting in nondefault format, 2.4.2

See also datetime data types

datetime data type class, 18.10.2.4

datetime data types

in general, 2.4

arithmetic operations with, 2.4.4

conversion functions for, 2.4.5

importing, exporting, and comparing, 2.4.6

DB2 data type, 2.5.7

DBMS_DEBUG package, 6.6.8

DBMS_DEBUG_JDWP package, 6.6.7

DBMS_FLASHBACK package, 12.8

DBMS_FLASHBACK.TRANSACTION_BACKOUT procedure, 12.9

DBMS_HPROF package, 8.2

DBMS_LOCK package, 1.6

DBMS_OUTPUT package, 6.6.4

DBMS_PARALLEL_EXECUTE package, 19.3.5

DBMS_STATS package, 12.12

DBMS_TYPES package, 2.5.6

DBMS_XA package, 15.3.10

DDL statement

Flashback Data Archive and, 12.10.6

ineffective, 18.4

Oracle XA and, 15.5.4.2

processing, 1.1

that generates notification, 11.3.2

deadlock, undetected, 1.6

debugging

PL/SQL Server Pages, 10.10

subprograms, 6.6

decimal number, 2.3.2

default column value

setting, 5.1.6

when to use, 5.1.5

default subprogram parameter value, 6.1.2.2.5

deferring constraint checks, 5.2.4

definer's-rights subprogram, 6.7.1

denormal floating-point number, 2.3.2.1

dependency mode, 18.10

dependent object

See schema object dependency

dependent transaction, 12.9.1

descendent edition, 19.1.2

DETERMINISTIC function

in general, 6.9.4.2

function-based index and, 4.4.2

RPC signature and, 18.10.2

dirty read, 1.7.1

disabling constraint

effect of, 5.8

existing, 5.8.5

new, 5.8.3

reasons for, 5.8.1

dispatcher thread, A.2

distributed database

FOREIGN KEY constraint and, 5.5

remote dependency management and, 18.9

distributed query, run-time error in, 6.5.3

distributed transaction

in general, 15.1.1

how it works, 6.8.2

DLL (dynamic link library), 14.2

DML statement

bulk binding for, 6.1.2.15.1

parallel, 6.9.4.3

that references collection, 6.1.2.15.1

DML_LOCKS initialization parameter, 1.5, 1.5

domain index, 4.3

double-precision IEEE 754 format, 2.3.2.1

drivers, Oracle JDBC, 13.4.2.1

DTP (X/Open Distributed Transaction architecture), 15.1

dynamic link library (DLL), 14.2

dynamic registration, 15.1.1

dynamic SQL statement, 6.9.4.4.2

dynamically typed data, 2.5.6

---

E

edition

in general, 19.1

ancestor, 19.1.2

creating, 19.1.2

crossedition triggers and, 19.3.3

current, 19.1.6

descendent, 19.1.2

displaying information about, 19.4

enabling for a user, 19.1.1.3

leaf, 19.1.2

making available

to all users, 19.1.5

to some users, 19.1.4

ora$base, 19.1, 19.1.2

retiring, 19.1.7

root, 19.1.2

session, 19.1.6

visibility of trigger in, 19.3.3.1

editionable schema object type, 19.1.1.1

edition-based redefinition, 19

editioned object, 19.1.1

editioning view

in general, 19.2

auditing policy and, 19.5.1

changing base table of, 19.2.5

changing write-ability of, 19.2.3

covering table with, 19.5.1

creating, 19.2.1

displaying information about, 19.4

partition-extended name for, 19.2.2

preparing application for, 19.5.1

read-only, 19.2.1

read-write, 19.2.1

replacing, 19.2.4

SQL optimizer hint and, 19.2.7

editions-enabled user, 19.1.1.3

Electronic Product Code (EPC), 17.7.2.1

embedded PL/SQL gateway

in general, 9.2.1.2

how to use, 9.4

enabling constraint

effect of, 5.8

existing, 5.8.4

new, 5.8.2

enabling editions for a user, 19.1.1.3

encoding scheme, adding, 17.3.4

enforcing business rules

with application logic, 5.1.2

with constraints, 5.1.1

environment, programming, 13

EPC (Electronic Product Code), 17.7.2.1

error handling

compile-time

in general, 6.4

for multilanguage program, 14.11

run-time

See run-time error handling

exception

IEEE 754 standard

not raised, 2.3.2.2

raised during conversion, 2.3.5

in multilanguage program, 14.11

to constraint, 5.8.7

unhandled, 6.5.2

user-defined, 6.5.1

See also run-time error handling

EXCLUSIVE MODE option of LOCK TABLE statement, 1.5.2.4

EXPR data type, 2.9.2

expression

conditional, represented as data, 2.6

evaluation of, during data type conversion, 2.8.2

index built on

See function-based index

regular

See regular expression

expression directive in PSP script, 10.5.7

extended internal ROWID format, 2.7.2.2

external binary internal ROWID format, 2.7.2.3

external data type, 2.1

external large object (BFILE) data type, 2.5.3.1

external subprogram

in general, 14.2

call specification for, 14.3

debugging, 14.13.4

loading, 14.4

publishing, 14.5

external transaction manager, 15.1.1

extproc agent, A

---

F

families of data types, 2.9.3, 2.9.3

fine-grained auditing (FGA) policy, editioning view and, 19.5.1

fine-grained invalidation, 18.4

firing order of triggers, 19.3.3.3

FIXED_DATE initialization parameter, 2.4.1

Flashback Data Archive, 12.10

Flashback Transaction, 12.9

FLASHBACK_TRANSACTION_QUERY view, 12.5

floating-point data type

in general, 2.3

range and precision of, 2.3.2.1

See also native floating-point data type

floating-point number

components of, 2.3.1

denormal, 2.3.2.1

format of, 2.3.2

rounding, 2.3.2

subnormal, 2.3.2.1

FOR loop

bulk binding for, 6.1.2.15.3

that references collection, 6.1.2.15.3

FORCE option of ALTER USER statement, 19.1.1.3

FOREIGN KEY constraint

composite, 5.2

distributed databases and, 5.5

dropping, 5.11

editioned view and, 19.1.1.2

enabling, 5.12

Flashback Transaction and, 12.9.1

indexing, 5.4

multiple, 5.2.3

naming, 5.7.2

NOT NULL constraint on, 5.2.2, 5.2.2

NULL value and, 5.2.1

privileges needed to create, 5.12.4

referential integrity enforced by, 5.12.5

UNIQUE constraint on, 5.2.2, 5.2.2

without other constraints, 5.2.2

foreign key dependency, 12.9.1

foreign rowid, 2.7.3

formal subprogram parameter, data type of, 6.1.2.2.2

forward crossedition trigger, 19.3.1

forward crossedition trigger SQL, 19.3.3.2.1

function

aggregate, 6.11

built-in

See SQL function

controlling side effects of, 6.9.4

DETERMINISTIC

in general, 6.9.4.2

function-based index and, 4.4.2

RPC signature and, 18.10.2

invoking from SQL statement, 6.9

MGD_ID ADT, 17.3.3

OCI or OCCI, 13.7.2

overloaded, 6.9.4.4.3

PARALLEL_ENABLE, 6.9.4.2

in general, 6.9.4.2

RPC signature and, 18.10.2

purity of

in general, 6.9.4

RPC signature and, 18.10.2

result-cached, 6.1.2.7

returning large amount of data from, 6.10

SQL

See SQL function

See also subprogram

function result cache, 6.1.2.7

function-based index

in general, 4.4

editioned function and, 19.1.1.2

examples of, 4.4.3

optimizer and, 4.4, 4.4.1

---

G

Geographic Information System (GIS) data, 2.5.1

global transaction, 15.1.1

global variable, in C external subprogram, 14.13.6

greedy operator in regular expression, 3.4.1

group commit, 1.2.4

---

H

hierarchical profiler, 8

host language, 13.6

host program, 13.6

hot rollover, 19

HTML syntax error in PSP script, 10.5.1.3

---

I

IA-32 and IA-64 instruction set architecture, 2.3.4

IBM CICS, 15.1.1

IBM Transarc Encina, 15.1.1

Identity Code Package, 17

IEEE 754 standard

data type

See native floating-point data type

exception

not raised, 2.3.2.2

raised during conversion, 2.3.5

OCI support for datatypes of, 2.3.6.1

special values supported by, 2.3.2.2

IGNORE_ROW_ON_DUPKEY_INDEX hint, 19.3.4.1.1

IMMEDIATE commit redo option, 1.2.4

IN OUT subprogram parameter mode, 6.1.2.2.1

IN subprogram parameter mode, 6.1.2.2.1

independent transaction

See autonomous transaction

index

in general, 4

domain, 4.3

edition-based redefinition and, 19.2.6

function-based

See function-based index

on MGD_ID column, 17.3.2

infinity, 2.3.2.2, 2.3.2.2

inherited object

in general, 19.1.3

dropping, 19.1.3.1

initialization parameter

DML_LOCKS, 1.5

FIXED_DATE, 2.4.1

NLS_DATE_FORMAT, 2.4.1

OPEN_CURSORS, 1.4.1

integer data type class, 18.10.2.4

integrity of data

See constraint

interface

between PL/SQL and C, 14.5.2

between PL/SQL and Java, 14.5.1

OraDatabase, 13.11.2.3

program, 13.2

TX, 15.1.1

user

in general, 13.2.1

stateful or stateless, 13.2.2

See also Oracle Call Interface

invalidation

cascading, 18.4

coarse-grained, 18.4

fine-grained, 18.4

of dependent object, 18.4

of package, 6.1.2.12

invoker's-rights subprogram, 6.7.1

invoking subprogram

in general, 6.7

from 3GL application, 6.7.4

from subprogram, 6.7.3

from trigger, 6.7.3

interactively from Oracle Database tools, 6.7.2

through embedded PL/SQL gateway, 9.4.4

isolation level

See transaction isolation level

---

J

Java class method

calling, 14.10.3

interface between PL/SQL and, 14.5.1

loading, 14.4.1

publishing, 14.6

See also external subprogram

Java Database Connectivity

See Oracle JDBC

Java language

compared to PL/SQL, 13.5

Oracle Database support for, 13.4

STATIC class attribute of, 6.9.4.3

Java Server Pages (JSP), 10.4

Java Virtual Machine

See Oracle JVM

JavaScript, 10.9.5

JDBC

See Oracle JDBC

JSP (Java Server Pages), 10.4

JVM

See Oracle JVM

---

K

key

foreign

See FOREIGN KEY constraint

primary

See PRIMARY KEY constraint

referential integrity

See FOREIGN KEY constraint

unique

See UNIQUE constraint

---

L

Large Object (LOB)

in general, 2.5.3.1

Oracle Objects for OLE support for, 13.11.3

leaf edition, 19.1.2

LGWR (log writer process), 1.2.4, 1.2.4

libunit, 14.2

lightweight queue, 16.3

loadpsp utility, 10.6

LOB

See Large Object (LOB)

LOCK TABLE statement

in general, 1.5.2

SELECT FOR UPDATE statement with, 1.5.5

locking row explicitly, 1.5.4

locking table

explicitly, 1.5

implicitly, 1.5.3

log writer process (LGWR), 1.2.4

logical rowid, 2.7.3

LONG and LONG RAW data types, 2.5.3.2

loose coupling, 15.1.1

---

M

main transaction, 1.8

maximum availability of table, 19.2.1

metacharacter in regular expression, 3.1

metadata for SQL operator or function, 2.9

MGD_ID ADT, 17.1

MGD_ID database ADT function, 17.3.3

mod_plsql module, 9.2.1.1

mode

agtctl command, A.3

dependency, 18.10

lock, 1.5.2

serialized

See serializable transaction

subprogram parameter, 6.1.2.2.1

MODIFY CONSTRAINT clause of ALTER TABLE statement, 5.9

modifying

See altering

monitor thread, A.2

multilanguage program

in general, 14.1

error or exception in, 14.11

multiline mode, 3.2

multilingual data, 3.4.2

multimedia data, 2.5.2

multithreaded extproc agent, A

---

N

name resolution

in general, 18.7

editions and, 19.1.3.2

NaN (not a number), 2.3.2.2

national character large object (NCLOB) data type, 2.5.3.1

native execution, compiling subprogram for, 6.2

native floating-point data type

in general, 2.3

arithmetic operation with, 2.3.4

binary format for, 2.3.2.1

clients that support, 2.3.6

comparison operator for, 2.3.3

conversion functions for, 2.3.5

rounding, 2.3.2

special values for, 2.3.2.2

NCHAR data type

specifying length of, 2.2.1

values stored, 2.2

NCLOB data type, 2.5.3.1

negative infinity, 2.3.2.2

negative zero, 2.3.2.2

new features, Preface

NLS_DATE_FORMAT initialization parameter, 2.4.1

noneditionable schema object type, 19.1.1.1

noneditioned object, 19.1.1

nongreedy operator in regular expression, 3.4.3

nonpersistent queue, 16.3

normalized significand, 2.3.2.1

NOT NULL constraint

compared to CHECK constraint, 5.6.4

naming, 5.7.2

on FOREIGN KEY constraint, 5.2.2, 5.2.2

when to use, 5.1.4

NOWAIT commit redo option, 1.2.4

NOWAIT option of LOCK TABLE statement, 1.5.2

NULL value and FOREIGN KEY constraint, 5.2.1

number

binary, 2.3.2

decimal, 2.3.2

rounding, 2.3.2

NUMBER data type, 2.3

number data type class, 18.10.2.4

numeric data types, 2.3

NVARCHAR2 data type

specifying length of, 2.2.1

values stored, 2.2

---

O

object

actual, 19.1.3

dependent

See schema object dependency

editioned, 19.1.1

inherited

in general, 19.1.3

dropping, 19.1.3.1

large

See Large Object (LOB)

noneditioned, 19.1.1

potentially editioned, 19.1.1

referenced

See schema object dependency

size limit for PL/SQL stored, 6.1.2.9

object change notification, 11.1

object data type, 13.11.3

object type

See schema object type

OCCI

See Oracle C++ Call Interface

OCI

See Oracle Call Interface

OCIAnyData and OCIAnyDataSet interfaces, 2.5.6

ODC (Oracle Data Control), 13.11.4

ODP.NET, 13.9

online application upgrade

See edition-based redefinition

OO4O

See Oracle Objects for OLE

OPEN_CURSORS initialization parameter, 1.4.1

operator

comparison, 2.3.3

in regular expression

in general, 3.4

greedy, 3.4.1

nongreedy, 3.4.3

metadata for, 2.9

relational, 2.3.3

optimizer

editioning view and, 19.2.7

function-based index and, 4.4, 4.4.1

RPC signature and, 18.10.2

ora$base edition, 19.1, 19.1.2

ORA_ROWSCN pseudocolumn, 12.7

Oracle Advanced Queuing (AQ), 16.2.2

Oracle C++ Call Interface

in general, 13.7

building application with, 13.7.4

kinds of functions in, 13.7.2

procedural and nonprocedural elements of, 13.7.3

Oracle Call Interface

in general, 13.7

building application with, 13.7.4

commit redo action in, 1.2.4

compared to precompiler, 13.8

kinds of functions in, 13.7.2

procedural and nonprocedural elements of, 13.7.3

with Oracle XA, 15.3.5

Oracle Data Control (ODC), 13.11.4

Oracle Data Provider for .NET, 13.9

Oracle data type

See data type

Oracle Database package

in general, 6.1.2.13

for writing low-level debugging code, 6.6.6

run-time error raised by, 6.5

Oracle Expression Filter, 2.6

Oracle Flashback Query, 12.3

Oracle Flashback Technology

in general, 12.1

application development features, 12.1.1

configuring database for, 12.2

database administration features, 12.1.2

performance guidelines for, 12.12

Oracle Flashback Transaction Query, 12.5

Oracle Flashback Version Query, 12.4

Oracle JDBC

in general, 13.4.2

compared to Oracle SQLJ, 13.4.4

sample program

2.0, 13.4.2.2

pre-2.0, 13.4.2.3

Oracle JDeveloper

in general, 6.6.3

Oracle SQLJ and, 13.4.3.1

Oracle JPublisher, 13.4.5

Oracle JVM, 13.4.1

Oracle Lock Management services, 1.6

Oracle Multimedia, 2.5.2

Oracle Objects for OLE

in general, 13.11

Automation Server, 13.11.1

C++ Class Library, 13.11.5

object data type support, 13.11.3

object model, 13.11.2

Oracle RAC and Oracle XA, 15.5.3

Oracle SQLJ

in general, 13.4.3

compared to Oracle JDBC, 13.4.4

Oracle JDeveloper and, 13.4.3.1

Oracle Text, 2.5.4, 2.5.4

Oracle Total Recall, 12.10

Oracle Tuxedo, 15.1.1

Oracle Virtual Private Database (VPD) policy, editioning view and, 19.5.1

Oracle XA

Oracle RAC and, 15.5.3

subprograms, 15.2

when to use, 15

OUT subprogram parameter mode, 6.1.2.2.1

out-of-space error, 1.9

overloaded subprogram, 6.1.2.8

---

P

package

in general, 6.1.2.8

advantages of, 6.1.2.8

body of, 6.1.2.8

creating, 6.1.2.10

invalidation of, 6.1.2.12

naming, 6.1.2.11

Oracle Database

in general, 6.1.2.13

for writing low-level debugging code, 6.6.6

run-time error raised by, 6.5

privileges needed to create, 6.1.2.10.2

privileges needed to drop, 6.1.2.10.2

session state and, 18.4.1

size limit for, 6.1.2.9

specification of, 6.1.2.8

synonym for, 6.8.1

package invalidation and, 6.1.2.12

package subprogram, 6.1.2

parallel DML statement, 6.9.4.3

parallel query, 6.9.4.3

PARALLEL_ENABLE function

in general, 6.9.4.2

RPC signature and, 18.10.2

parameter

initialization

See initialization parameter

subprogram

See subprogram parameter

parameter mode, 6.1.2.2.1

partition-extended editioning view name, 19.2.2

persistent LOB instance, 2.5.3.1

persistent queue, 16.3

phantom read, 1.7.1

PL/Scope tool, 7

plshprof utility, 8.5

PL/SQL function result cache, 6.1.2.7

PL/SQL gateway, 9.2.1

PL/SQL hierarchical profiler, 8

PL/SQL language

in general, 13.3

compared to Java, 13.5

PL/SQL object

CREATE OR REPLACE and, 18.4

PL/SQL Server Pages

characteristics of, 10.5.1

elements of, 10.5

loading, 10.6

script error in, 10.5.1.3

PL/SQL unit

in general, 6.1

stored, 6.1.2

PL/SQL Web Toolkit, 9.2.2

pool, connection, 13.6.1

positive infinity, 2.3.2.2

positive zero, 2.3.2.2

POSIX standard for regular expressions

operators defined in, 3.4.1

Oracle SQL and, 3.3

Oracle SQL multilingual extensions to, 3.4.2

Oracle SQL PERL-influenced extensions to, 3.4.3

potentially editioned object, 19.1.1

precompiler

in general, 13.6

compared to Oracle Call Interface, 13.8

Oracle XA and, 15.3.4

PRIMARY KEY constraint

in general, 5.1.7

dropping, 5.11

Flashback Transaction and, 12.9.1

naming, 5.7.2

primary key dependency, 12.9.1

privileges

for creating package, 6.1.2.3

for creating subprogram, 6.1.2.3

for debugging subprogram, 6.6.5

for defining constraint, 5.7.1

for dropping package, 6.1.2.5

for dropping packages, 6.1.2.10.2

for dropping subprogram, 6.1.2.5

for Oracle Flashback Technology, 12.2.5

for running subprogram, 6.7.1

revoked, object dependency and, 18.4.2

Pro*C/C++ precompiler

in general, 13.6.1

native floating-point data type support in, 2.3.6.3

Pro*COBOL precompiler, 13.6.2

procedure

PL/SQL Server Pages and, 10.5.3

See also subprogram

product code, 17.7.2

profiler, 8

program interface, 13.2

programming environment, 13

PSP

See PL/SQL Server Pages

public information, required, 15.1.2

publish-subscribe model, 16

purity of function

in general, 6.9.4

RPC signature and, 18.10.2

---

Q

quality-of-service flag, 11.6.6.2

query

parallel, 6.9.4.3

registering for Continuous Query Notification, 11.6

run-time error in distributed, 6.5.3

query result change notification, 11.2

queue, 16.3

---

R

Radio Frequency Identification (RFID) technology, 17.7.1

RAISE statement, 6.5.1

RAW data type, 2.5.3.2

raw data type class, 18.10.2.4

READ COMMITTED transaction isolation level

compared to SERIALIZABLE, 1.7.4.2

in Oracle Database, 1.7.1

transaction interactions with, 1.7.1

read consistency, 1.5

statement-level, 1.3

transaction-level

in general, 1.3

locking tables explicitly for, 1.5

read-only transaction for, 1.3

read lock, 1.7.3

READ UNCOMMITTED transaction isolation level

in Oracle Database, 1.7.1

transaction interactions with, 1.7.1

read-only editioning view, 19.2.1

read-only transaction, 1.3

read-write editioning view, 19.2.1

redefinition, edition-based, 19

redo information for transaction, 1.2.4

redo management, 1.2.4

referenced object

See schema object dependency

referential integrity

serializable transactions and, 1.7.3

trigger for enforcing, 1.7.3

referential integrity key

See FOREIGN KEY constraint

REGEXP_COUNT function, 3.2

REGEXP_INSTR function, 3.2

REGEXP_LIKE condition, 3.2

REGEXP_REPLACE function

in general, 3.2

back reference operator in, 3.4.1

REGEXP_SUBSTR function, 3.2

registration

dynamic, 15.1.1

for Continuous Query Notification, 11.6

in publish-subscribe model, 16.3

static, 15.1.1

regular expression

in general, 3

in Oracle SQL, 3.2

in SQL statement, 3.5

metacharacter in, 3.1

POSIX standard and

See POSIX standard for regular expressions

Unicode and, 3.3

relational operator, 2.3.3

remote dependency management, 18.9

remote procedure call dependency management, 18.10

repeatable read

in general, 1.3

read-only transaction for, 1.3

REPEATABLE READ transaction isolation level

in Oracle Database, 1.7.1

transaction interactions with, 1.7.1

repeatable reads

locking tables explicitly for, 1.5

required public information, 15.1.2

rerunning SQL statement, 1.4.2

resource manager (RM), 15.1.1

RESTRICT_REFERENCES pragma

for backward compatibility, 6.9.4.4

overloaded functions and, 6.9.4.4.3

static and dynamic SQL statements and, 6.9.4.4.2

restricted internal ROWID format, 2.7.2.1

result cache, 6.1.2.7

resumable storage allocation, 1.9

RETENTION GUARANTEE clause for undo tablespace, 12.2.1

RETENTION option of ALTER TABLE statement, 12.2.4

reverse crossedition trigger, 19.3.2

reverse crossedition trigger SQL, 19.3.3.2.2

RFID (Radio Frequency Identification) technology, 17.7.1

RM (resource manager), 15.1.1

ROLLBACK statement, 1.2.5

rolling back transaction, 1.2.5

root edition, 19.1.2

roundiing floating-point numbers, 2.3.2

routine

See subprogram

row

address of (rowid), 2.7

locking explicitly, 1.5.4

ROW EXCLUSIVE MODE option of LOCK TABLE statement, 1.5.2.1, 1.5.2.1

ROW SHARE MODE option of LOCK TABLE statement, 1.5.2.1

rowid

in general, 2.7

foreign, 2.7.3

logical, 2.7.3

universal (urowid), 2.7.3

ROWID data type, 2.7.2

ROWID pseudocolumn

in general, 2.7

CQN and, 11.6.2.3

See also rowid

ROWTYPE_MISMATCH exception, 6.3.2

RPC dependency management, 18.10

RPC-signature dependency mode, 18.10.2

RR datetime format element, 2.4.1

rule on queue, 16.3

rules engine, 16.3

run-time error handling

in general, 6.5

for distributed query, 6.5.3

for PL/SQL Server Pages (PSP) script, 10.5.1.3

for remote subprogram, 6.5.4

for storage allocation error, 1.9

for user-defined exception, 6.5.1

See also exception

---

S

SAVEPOINT statement, 1.2.6, 1.2.6

schema object dependency

in general, 18

actualization and, 19.1.3.2

in distributed database, 18.9

invalidation and, 18.4

on nonexistence of other objects, 18.7

revoked privileges and, 18.4.2

shared pool and, 18.11

schema object type

editionable, 19.1.1.1

noneditionable, 19.1.1.1

scrollable cursor, 1.4.3

searchable text, 2.5.4

SELECT FOR UPDATE statement

in general, 1.5.4

LOCK TABLE statement with, 1.5.5

referential integrity and

inside trigger, 1.7.3

outside trigger, 1.7.3

SELECT statement

bulk binding for, 6.1.2.15.2

referencing collection with, 6.1.2.15.2

with AS OF clause, 12.3

with FOR UPDATE clause

See SELECT FOR UPDATE statement

with VERSIONS BETWEEN clause, 12.4

semi-available table, 19.2.1

serendipitous change, 19.3.5

data transformation collisions and, 19.3.4.1.1

identifying, 19.3.4.1.1

serializable transaction

for concurrency control, 1.7

interaction with, 1.7.1

referential integrity and, 1.7.3

SERIALIZABLE transaction isolation level

compared to READ COMMITTED, 1.7.4.2

in Oracle Database, 1.7.1

transaction interactions with, 1.7.1

See also serializable transaction

server-side programming, 13.1.2

service routine, C external subprogram and, 14.12

session edition, 19.1.6

session state, 18.4.1

session variable, 6.7.2

SET CONSTRAINTS statement, 5.2.4

SET TRANSACTION statement

with READ ONLY option, 1.3

SHARE MODE option of LOCK TABLE statement, 1.5.2.2

SHARE ROW EXCLUSIVE MODE option of LOCK TABLE statement, 1.5.2.3

shared SQL area, 1.1

side effects of function, controlling, 6.9.4

signature checking, 18.9.1

single-precision IEEE 754 format, 2.3.2.1

spatial data, 2.5.1

SQL area, shared, 1.1

SQL data type

See data type

SQL function

display type of, 2.9.2

for data type conversion, 2.4.5

metadata for, 2.9

SQL optimizer hint and editioning view, 19.2.7

SQL statement

application, 19.3.3.2.3

crossedition trigger

forward, 19.3.3.2.1

reverse, 19.3.3.2.2

dynamic, 6.9.4.4.2

invoking PL/SQL function from, 6.9

processing

DDL statement, 1.1

stages of, 1.1

system management statement, 1.1, 1.1

rerunning, 1.4.2

static, 6.9.4.4.2

SQL/DS data type, 2.5.7

SQLJ

See Oracle SQLJ

SQLT_BDOUBLE data type, 2.3.6.1

SQLT_BFLOAT data type, 2.3.6.1

standalone subprogram, 6.1.2

state

session, 18.4.1

user interface and, 13.2.2

web application and, 9.6.8

statement

See SQL statement

statement-level read consistency, 1.3, 1.5

static registration, 15.1.1

static SQL statement, 6.9.4.4.2

static variable, in C external subprogram, 14.13.7

statistics

for application, 8

for identifier, 7

storage allocation error, 1.9

stored PL/SQL unit, 6.1.2

subnormal floating-point number, 2.3.2.1

subprogram

compiling for native execution, 6.2

creating, 6.1.2.3

definer's-rights, 6.7.1

editioned, 19.1.1.2

exception-handling, 6.5.1

external

See external subprogram

invoker's-rights, 6.7.1

invoking

See invoking subprogram

naming, 6.1.2.1

Oracle XA, 15.2

overloaded, 6.1.2.8

package, 6.1.2

parameter of

See subprogram parameter

privileges needed to debug, 6.6.5

privileges needed to run, 6.7.1

remote, 6.5.4

size limit for, 6.1.2.9

standalone, 6.1.2

synonym for, 6.8.1

See also function and procedure

subprogram parameter

in general, 6.1.2.2

composite variable as, 6.1.2.2.4

data type of formal, 6.1.2.2.2

default value of, 6.1.2.2.5

mode of, 6.1.2.2.1

subscriber, 16.3

subscription services, 16.3

synonym

CREATE OR REPLACE and, 18.4

for package, 6.8.1

for subprogram, 6.8.1

public, for editioned object, 19.1.1.2

SYSDATE function, 2.4.1

system management statement, 1.1, 1.1

---

T

table

locking

choosing strategy for, 1.5.2

explicitly, 1.5

implicitly, 1.5.3

with maximum availability, 19.2.1

with semi-availability, 19.2.1

Tag Data Translation Markup Language Schema, 17.1

task thread, A.2

temporary LOB instance, 2.5.3.1

thin client configuration, 13.1.3

third-generation language (3GL), 6.7.4

thread

dispatcher, A.2

monitor, A.2

Oracle XA library, 15.3.9

task, A.2

three-tier architecture, 13.1.3

tight coupling, 15.1.1

time

default format for, 2.4.3

default value for, 2.4.3

displaying

current, 2.4.1

in nondefault format, 2.4.3

inserting in nondefault format, 2.4.3

See also datetime data types

time stamp checking, 18.9.1

time-stamp dependency mode, 18.10.1

TM (transaction manager), 15.1.1

TPM (transaction processing monitor), 15.1.1

transaction

autonomous

in general, 1.8

trigger as, 1.9.2.1

choosing isolation level for, 1.7.4.2

committing, 1.2.3

dependent, 12.9.1

distributed

in general, 15.1.1

how it works, 6.8.2

global, 15.1.1

grouping operations into, 1.2.1

improving performance of, 1.2.2

main, 1.8, 1.8

read-only, 1.3

redo entry for, 1.2.4

rolling back, 1.2.5

savepoints for, 1.2.6

serializable

See serializable transaction

statements in, 1.2.6

transaction interaction

kinds of, 1.7.1

serializable transaction and, 1.7.1

transaction isolation level and, 1.7.1

transaction isolation level

choosing, 1.7.4.2

setting, 1.7.2

transaction interaction and, 1.7.1

transaction manager (TM), 15.1.1

transaction processing monitor (TPM), 15.1.1

transaction set consistency, 1.7.4.1

transaction-level read consistency

in general, 1.3

locking tables explicitly for, 1.5

read-only transaction for, 1.3

transform

in general, 19.3.1

applying, 19.3.5

trigger

in general, 6.1.2.16

AFTER SUSPEND, 1.9.2.1

as autonomous transaction, 1.9.2.1

crossedition

See crossedition trigger

enforcing referential integrity with, 1.7.3

in edition

firing order of, 19.3.3.3

visibility of, 19.3.3.1

what kind can fire, 19.3.3.2

invoking subprogram from, 6.7.3

size limit for, 6.1.2.9

TRUST keyword in RESTRICT_REFERENCES pragma, 6.9.4.4.1

two-phase commit protocol, 15.1.1

two-tier architecture, 13.1.3

TX interface, 15.1.1

type attribute, 6.1.2.2.3

---

U

undetected deadlock, 1.6

undo data, 12.1

UNDO_RETENTION parameter, 1.3

undoing transaction, 1.2.5

unhandled exception, 6.5.2

Unicode

character literals and, 2.2.1

regular expressions and, 3.3

UNIQUE constraint

crossedition trigger and, 19.3.4.1.1

dropping, 5.11

naming, 5.7.2

on FOREIGN KEY constraint, 5.2.2, 5.2.2

when to use, 5.1.8

universal rowid (urowid), 2.7.3

unrepeatable read, 1.7.1

upgrading applications online

See edition-based redefinition

UROWID data type, 2.7.3

user interface

in general, 13.2.1

stateful and stateless, 13.2.2

user lock, 1.6

user-defined exception, 6.5.1

user-defined type, as subprogram parameter, 6.1.2.2.4

UTLLOCKT.SQL script, 1.6.2

---

V

VARCHAR data type class, 18.10.2.4

VARCHAR2 data type

compared to CHAR data type, 2.2.2

specifying length of, 2.2.1, 2.2.1

values stored, 2.2

variable

cursor

See cursor variable

in C external subprogram

global, 14.13.6

static, 14.13.7

VERSIONS_ENDSCN pseudocolumn, 12.4

VERSIONS_ENDTIME pseudocolumn, 12.4

VERSIONS_OPERATION pseudocolumn, 12.4

VERSIONS_STARTSCN pseudocolumn, 12.4

VERSIONS_STARTTIME pseudocolumn, 12.4

VERSIONS_XID pseudocolumn, 12.4

view

constraint on, 5.1.9

editioned

FOREIGN KEY constraint and, 19.1.1.2

materialized view and, 19.1.1.2

editioning

See editioning view

VPD policy, editioning view and, 19.5.1

---

W

WAIT commit redo option, 1.2.4

WAIT option of LOCK TABLE statement, 1.5.2, 1.5.2

web application

in general, 9.1

implementing, 9.2

state and, 9.6.8

web page

See also PL/SQL Server Pages

web services, 13.4.7

web toolkit

See PL/SQL Web Toolkit

WORK option of ROLLBACK statement, 1.2.5

wrap utility, debugging and, 6.6.5

write-ability of editioning view, 19.2.3

write-after-write dependency, 12.9.1

---

X

xa_open string, 15.3.3

XMLType data type, 2.5.5

X/Open Distributed Transaction architecture, 15.1

X/Open Distributed Transaction Processing (DTP) architecture, 15.1

---

Y

YY datetime format element, 2.4.2