Skip Headers
Oracle® Database Advanced Application Developer's Guide
11g Release 2 (11.2)

E41502-04
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
PDF · Mobi · ePub

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, 1.3.2.1
3GL (third-generation language), 6.7.4
64-bit IEEE 754 format, 1.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, 19.1.3
schema object dependency and, 19.1.3.2
address of row
See rowid
ADT
editions and, 19.1.1.2
resetting evolved, 19.1.1.3
AFTER SUSPEND trigger, 2.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, 1.5.7
ANYDATA data type, 1.5.6
ANYDATASET data type, 1.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, 1.9.1
arithmetic operation
with datetime data type, 1.4.4
with native floating-point data type, 1.3.4
ASP (Active Server Pages), 10.4
assignment
data type conversion during, 1.8.1, 1.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, 2.8
trigger as, 2.9.2.1

B

backward compatibility
LONG and LONG RAW data types for, 1.5.3.2
RESTRICT_REFERENCES pragma for, 6.9.4.4
BATCH commit redo option, 2.2.4
BFILE data type, 1.5.3.1
binary format, 1.3.2.1
binary internal ROWID format, 1.7.2.3
binary large object (BLOB) data type, 1.5.3.1
binary number, 1.3.2
BINARY_DOUBLE data type, 1.3
BINARY_FLOAT data type, 1.3
BLOB data type, 1.5.3.1
block, anonymous, 6.1.1
branch, 15.1.1
built-in function
See SQL function
bulk binding, 6.1.2.14
when to use, 6.1.2.15
business rule, 5

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, 1.2.2
specifying length of, 1.2.1
values stored, 1.2
character data type class, 18.10.2.4
character data types, 1.2
character large object (CLOB) data type, 1.5.3.1
CHECK constraint
compared to NOT NULL constraint, 5.12.4
designing, 5.12.2
multiple, 5.12.3
naming, 5.13.2
restrictions on, 5.12.1
when to use, 5.12
client notification, 16.2.3
client/server architecture, 13.1.1
CLOB data type, 1.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
when to use, 5.5
multiple foreign key constraints on, 5.8.3
specifying length of, 1.2.1
commit redo management, 2.2.4
COMMIT statement, 2.2.3
committing transaction, 2.2.3
comparison operator, 1.3.3
compile-time error, handling
for multilanguage program, 14.11
concurrency
serializable transaction for, 2.7
under explicit locking, 2.5.5
conditional expression represented as data, 1.6
connection pool, 13.6.1
constraint, 5
altering, 5.15
CHECK
See CHECK constraint
compared to trigger, 5.1
crossedition trigger and
collisions, 19.3.4.1.1
dropping, 19.3.6
deferring checking of, 5.8.4
disabling
effect of, 5.14
existing, 5.14.5, 5.14.5
new, 5.14.3, 5.14.3
reasons for, 5.14.1
dropping, 5.17, 5.17
editioning view and, 19.2.6
enabling
effect of, 5.14
existing, 5.14.4
new, 5.14.2
exception to, 5.14.7
FOREIGN KEY
See FOREIGN KEY constraint
minimizing overhead of, 5.9
naming, 5.13.2
NOT NULL
See NOT NULL constraint
on view, 5
PRIMARY KEY
See PRIMARY KEY constraint
privileges needed for defining, 5.13.1
referential integrity
See FOREIGN KEY constraint
renaming, 5.16
UNIQUE
See UNIQUE constraint
viewing definition of, 5.19
violating, 5.14.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, 18.4
actualization and, 19.1.3
crossedition trigger, 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, 1.4.1
current edition, 19.1.6
cursor, 2.4
canceling, 2.4.5
closing, 2.4.4
crossedition trigger and, 19.4
number in session, 2.4.1
Oracle XA application and, 15.3.4
rerunning statement with, 2.4.2
schema object dependency and, 18.11
scrollable, 2.4.3
See also cursor variable
cursor variable, 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, 5
See also constraint
data type, 1.1
ANSI, 1.5.7
DB2, 1.5.7
dynamic, 1.5.6
external, 1.1
family of, 1.9.3
for character data, 1.2
for datetime data, 1.4
for geographic data, 1.5.1
for large amount of data, 1.5.3
for multimedia data, 1.5.2
for numeric data, 1.3
for spatial data, 1.5.1
for XML data, 1.5.5
object, 13.11.3
of formal subprogram parameter, 6.1.2.2.2
SQL/DS, 1.5.7
data type class, 18.10.2.4
data type conversion, 1.8
of ANSI and IBM data types, 1.5.7
of datetime data types, 1.4.5
of native floating-point data types, 1.3.5
date
default format for, 1.4.1
default value for, 1.4.3
displaying
current, 1.4.1
in nondefault format, 1.4.2
inserting in nondefault format, 1.4.2
See also datetime data types
datetime data type class, 18.10.2.4
datetime data types, 1.4
arithmetic operations with, 1.4.4
conversion functions for, 1.4.5
importing, exporting, and comparing, 1.4.6
DB2 data type, 1.5.7
DBMS_DEBUG package, 6.6.8
DBMS_DEBUG_JDWP package, 6.6.7
DBMS_FLASHBACK package, 12.7
DBMS_FLASHBACK.TRANSACTION_BACKOUT procedure, 12.8
DBMS_HPROF package, 8.2
DBMS_LOCK package, 2.6
DBMS_OUTPUT package, 6.6.4
DBMS_PARALLEL_EXECUTE package, 19.3.5
DBMS_STATS package, 12.11
DBMS_TYPES package, 1.5.6
DBMS_XA package, 15.3.10
DDL statement
Flashback Data Archive and, 12.9.6
ineffective, 18.4
Oracle XA and, 15.5.4.2
processing, 2.1
that generates notification, 11.3.2
deadlock, undetected, 2.6
debugging
PL/SQL Server Pages, 10.10
subprograms, 6.6
decimal number, 1.3.2
default column value, 5.5
default subprogram parameter value, 6.1.2.2.5
deferring constraint checks, 5.8.4
definer’s-rights subprogram, 6.7.1
denormal floating-point number, 1.3.2.1
dependency mode, 18.10
dependent object
See schema object dependency
dependent transaction, 12.8.1
descendent edition, 19.1.2
DETERMINISTIC function, 6.9.4.2
function-based index and, 4.4.2
RPC signature and, 18.10.2
dirty read, 2.7.1
disabling constraint
effect of, 5.14
existing, 5.14.5
new, 5.14.3
reasons for, 5.14.1
dispatcher thread, A.2
distributed database
FOREIGN KEY constraint and, 5.11
remote dependency management and, 18.9
distributed query, runtime error in, 6.5.3
distributed transaction, 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, 2.5, 2.5
domain index, 4.3
double-precision IEEE 754 format, 1.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, 1.5.6

E

edition, 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, 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, 9.2.1.2
how to use, 9.4
enabling constraint
effect of, 5.14
existing, 5.14.4
new, 5.14.2
enabling editions for a user, 19.1.1.3
encoding scheme, adding, 17.3.4
environment, programming, 13
EPC (Electronic Product Code), 17.7.2.1
error handling
compile-time, 6.4
for multilanguage program, 14.11
runtime
See runtime error handling
exception
IEEE 754 standard
not raised, 1.3.2.2
raised during conversion, 1.3.5
in multilanguage program, 14.11
to constraint, 5.14.7
unhandled, 6.5.2
user-defined, 6.5.1
See also runtime error handling
EXCLUSIVE MODE option of LOCK TABLE statement, 2.5.2.4
EXPR data type, 1.9.2
expression
conditional, represented as data, 1.6
evaluation of, during data type conversion, 1.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, 1.7.2.2
external binary internal ROWID format, 1.7.2.3
external data type, 1.1
external large object (BFILE) data type, 1.5.3.1
external subprogram, 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, 1.9.3, 1.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, 1.4.1
Flashback Data Archive, 12.9
Flashback Transaction, 12.8
FLASHBACK_TRANSACTION_QUERY view, 12.5
floating-point data type, 1.3
range and precision of, 1.3.2.1
See also native floating-point data type
floating-point number
components of, 1.3.1
denormal, 1.3.2.1
format of, 1.3.2
rounding, 1.3.2
subnormal, 1.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, 5.8
distributed databases and, 5.11
dropping, 5.17
editioned view and, 19.1.1.2
enabling, 5.18
Flashback Transaction and, 12.8.1
indexing, 5.10
multiple, 5.8.3
naming, 5.13.2
NOT NULL constraint on, 5.8.2, 5.8.2
NULL value and, 5.8.1
privileges needed to create, 5.18.4
referential integrity enforced by, 5.18.5
UNIQUE constraint on, 5.8.2, 5.8.2
without other constraints, 5.8.2
foreign key dependency, 12.8.1
foreign rowid, 1.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, 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
PARALLEL_ENABLE, 6.9.4.2, 6.9.4.2
RPC signature and, 18.10.2
purity of, 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, 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, 1.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, 2.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, 1.3.4
IBM CICS, 15.1.1
IBM Transarc Encina, 15.1.1
Identity Code Package, 17
IEEE 754 format, 1.3
See Also native floating-point data type
IEEE 754 standard
exception
not raised, 1.3.2.2
raised during conversion, 1.3.5
OCI support for datatypes of, 1.3.6.1
special values supported by, 1.3.2.2
IGNORE_ROW_ON_DUPKEY_INDEX hint, 19.3.4.1.1
IMMEDIATE commit redo option, 2.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, 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, 1.3.2.2, 1.3.2.2
inherited object, 19.1.3
dropping, 19.1.3.1
initialization parameter
DML_LOCKS, 2.5
FIXED_DATE, 1.4.1
NLS_DATE_FORMAT, 1.4.1
OPEN_CURSORS, 2.4.1
integer data type class, 18.10.2.4
integrity constraint
See constraint
integrity of data, 5
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, 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, 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
unique
See UNIQUE constraint

L

Large Object (LOB), 1.5.3.1
Oracle Objects for OLE support for, 13.11.3
leaf edition, 19.1.2
LGWR (log writer process), 2.2.4, 2.2.4
libunit, 14.2
lightweight queue, 16.3
loadpsp utility, 10.6
LOB
See Large Object (LOB)
LOCK TABLE statement, 2.5.2
SELECT FOR UPDATE statement with, 2.5.5
locking row explicitly, 2.5.4
locking table
explicitly, 2.5
implicitly, 2.5.3
log writer process (LGWR), 2.2.4
logical rowid, 1.7.3
LONG and LONG RAW data types, 1.5.3.2
loose coupling, 15.1.1

M

main transaction, 2.8
maximum availability of table, 19.2.1
metacharacter in regular expression, 3.1
metadata for SQL operator or function, 1.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, 2.5.2
serialized
See serializable transaction
subprogram parameter, 6.1.2.2.1
MODIFY CONSTRAINT clause of ALTER TABLE statement, 5.15
modifying
See altering
monitor thread, A.2
multilanguage program, 14.1
error or exception in, 14.11
multiline mode, 3.2
multilingual data, 3.4.2
multimedia data, 1.5.2
multithreaded extproc agent, A

N

name resolution, 18.7
editions and, 19.1.3.2
NaN (not a number), 1.3.2.2
national character large object (NCLOB) data type, 1.5.3.1
native execution, compiling subprogram for, 6.2
native floating-point data type, 1.3
arithmetic operation with, 1.3.4
binary format for, 1.3.2.1
clients that support, 1.3.6
comparison operator for, 1.3.3
conversion functions for, 1.3.5
special values for, 1.3.2.2
NCHAR data type
specifying length of, 1.2.1
values stored, 1.2
NCLOB data type, 1.5.3.1
negative infinity, 1.3.2.2
negative zero, 1.3.2.2
new features, Preface
NLS_DATE_FORMAT initialization parameter, 1.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, 1.3.2.1
NOT NULL constraint
compared to CHECK constraint, 5.12.4
naming, 5.13.2
on FOREIGN KEY constraint, 5.8.2, 5.8.2
when to use, 5.4
NOWAIT commit redo option, 2.2.4
NOWAIT option of LOCK TABLE statement, 2.5.2
NULL value
FOREIGN KEY constraint and, 5.8.1
function-based index and, 4.4
indexing and, 5.4
number
binary, 1.3.2
decimal, 1.3.2
rounding, 1.3.2
NUMBER data type, 1.3
number data type class, 18.10.2.4
numeric data types, 1.3
NVARCHAR2 data type
specifying length of, 1.2.1
values stored, 1.2

O

object
actual, 19.1.3
dependent
See schema object dependency
editioned, 19.1.1
inherited, 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, 1.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, 2.4.1
operator
comparison, 1.3.3
in regular expression, 3.4
greedy, 3.4.1
nongreedy, 3.4.3
metadata for, 1.9
relational, 1.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
Oracle Advanced Queuing (AQ), 16.2.2
Oracle C++ Call Interface, 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, 13.7
building application with, 13.7.4
commit redo action in, 2.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, 6.1.2.13
for writing low-level debugging code, 6.6.6
runtime error raised by, 6.5
Oracle Expression Filter, 1.6
Oracle Flashback Query, 12.3
Oracle Flashback Technology, 12.1
application development features, 12.1.1
configuring database for, 12.2
database administration features, 12.1.2
performance guidelines for, 12.11
Oracle Flashback Transaction Query, 12.5
Oracle Flashback Version Query, 12.4
Oracle JDBC, 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, 6.6.3
Oracle SQLJ and, 13.4.3.1
Oracle JPublisher, 13.4.5
Oracle JVM, 13.4.1
Oracle Lock Management services, 2.6
Oracle Multimedia, 1.5.2
Oracle Objects for OLE, 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, 13.4.3
compared to Oracle JDBC, 13.4.4
Oracle JDeveloper and, 13.4.3.1
Oracle Text, 1.5.4, 1.5.4
Oracle Total Recall, 12.9
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, 2.9
overloaded subprogram, 6.1.2.8

P

package, 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, 6.1.2.13
for writing low-level debugging code, 6.6.6
runtime 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, 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, 1.5.3.1
persistent queue, 16.3
phantom read, 2.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, 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, 6.1
stored, 6.1.2
PL/SQL Web Toolkit, 9.2.2
pool, connection, 13.6.1
positive infinity, 1.3.2.2
positive zero, 1.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, 13.6
compared to Oracle Call Interface, 13.8
Oracle XA and, 15.3.4
PRIMARY KEY constraint, 5.6
dropping, 5.17
Flashback Transaction and, 12.8.1
naming, 5.13.2
primary key dependency, 12.8.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.13.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, 13.6.1
native floating-point data type support in, 1.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, 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
runtime 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, 1.5.3.2
raw data type class, 18.10.2.4
READ COMMITTED transaction isolation level
compared to SERIALIZABLE, 2.7.4.2
in Oracle Database, 2.7.1
transaction interactions with, 2.7.1
read consistency
statement-level, 2.3
transaction-level, 2.3
locking tables explicitly for, 2.5
read-only transaction for, 2.3
read lock, 2.7.3
READ UNCOMMITTED transaction isolation level
in Oracle Database, 2.7.1
transaction interactions with, 2.7.1
read-only editioning view, 19.2.1
read-only transaction, 2.3
read-write editioning view, 19.2.1
redefinition, edition-based, 19
redo information for transaction, 2.2.4
redo management, 2.2.4
referenced object
See schema object dependency
referential integrity
serializable transactions and, 2.7.3
trigger for enforcing, 2.7.3
referential integrity constraint
See FOREIGN KEY constraint
REGEXP_COUNT function, 3.2
REGEXP_INSTR function, 3.2
REGEXP_LIKE condition, 3.2
REGEXP_REPLACE function, 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, 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, 1.3.3
remote dependency management, 18.9
remote procedure call dependency management, 18.10
repeatable read, 2.3
read-only transaction for, 2.3
REPEATABLE READ transaction isolation level
in Oracle Database, 2.7.1
locking tables explicitly for, 2.5
transaction interactions with, 2.7.1
required public information, 15.1.2
rerunning SQL statement, 2.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, 1.7.2.1
result cache, 6.1.2.7
resumable storage allocation, 2.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, 2.2.5
rolling back transaction, 2.2.5
root edition, 19.1.2
roundiing floating-point numbers, 1.3.2
routine
See subprogram
row
address of
See rowid
locking explicitly, 2.5.4
ROW EXCLUSIVE MODE option of LOCK TABLE statement, 2.5.2.1, 2.5.2.1
ROW SHARE MODE option of LOCK TABLE statement, 2.5.2.1
rowid, 1.7
foreign, 1.7.3
logical, 1.7.3
universal (urowid), 1.7.3
ROWID data type, 1.7.2
ROWID pseudocolumn, 1.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, 1.4.1
rule on queue, 16.3
rules engine, 16.3
runtime error handling, 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, 2.9
for user-defined exception, 6.5.1
See also exception

S

SAVEPOINT statement, 2.2.6, 2.2.6
schema object dependency, 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, 2.4.3
searchable text, 1.5.4
SELECT FOR UPDATE statement, 2.5.4
LOCK TABLE statement with, 2.5.5
referential integrity and
inside trigger, 2.7.3
outside trigger, 2.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, 2.7
interaction with, 2.7.1
referential integrity and, 2.7.3
SERIALIZABLE transaction isolation level
compared to READ COMMITTED, 2.7.4.2
in Oracle Database, 2.7.1
transaction interactions with, 2.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.8.4
SET TRANSACTION statement with READ ONLY option, 2.3
SHARE MODE option of LOCK TABLE statement, 2.5.2.2
SHARE ROW EXCLUSIVE MODE option of LOCK TABLE statement, 2.5.2.3
shared SQL area, 2.1
side effects of function, controlling, 6.9.4
signature checking, 18.9.1
single-precision IEEE 754 format, 1.3.2.1
spatial data, 1.5.1
SQL area, shared, 2.1
SQL data type
See data type
SQL function
display type of, 1.9.2
for data type conversion, 1.4.5
metadata for, 1.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, 2.1
stages of, 2.1
system management statement, 2.1, 2.1
rerunning, 2.4.2
static, 6.9.4.4.2
SQL/DS data type, 1.5.7
SQLJ
See Oracle SQLJ
SQLT_BDOUBLE data type, 1.3.6.1
SQLT_BFLOAT data type, 1.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, 2.3
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, 2.9
stored PL/SQL unit, 6.1.2
subnormal floating-point number, 1.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, 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, 1.4.1
system management statement, 2.1, 2.1

T

table
locking
choosing strategy for, 2.5.2
explicitly, 2.5
implicitly, 2.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, 1.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, 1.4.3
default value for, 1.4.3
displaying
current, 1.4.1
in nondefault format, 1.4.3
inserting in nondefault format, 1.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, 2.8
trigger as, 2.9.2.1
choosing isolation level for, 2.7.4.2
committing, 2.2.3
dependent, 12.8.1
distributed, 15.1.1
how it works, 6.8.2
global, 15.1.1
grouping operations into, 2.2.1
improving performance of, 2.2.2
main, 2.8, 2.8
read-only, 2.3
redo entry for, 2.2.4
rolling back, 2.2.5
savepoints for, 2.2.6
serializable
See serializable transaction
statements in, 2.2.6
transaction interaction
kinds of, 2.7.1
serializable transaction and, 2.7.1
transaction isolation level and, 2.7.1
transaction isolation level
choosing, 2.7.4.2
setting, 2.7.2
transaction interaction and, 2.7.1
transaction manager (TM), 15.1.1
transaction processing monitor (TPM), 15.1.1
transaction set consistency, 2.7.4.1
transaction-level read consistency, 2.3
locking tables explicitly for, 2.5
read-only transaction for, 2.3
transform, 19.3.1
applying, 19.3.5
trigger, 6.1.2.16
AFTER SUSPEND, 2.9.2.1
as autonomous transaction, 2.9.2.1
compared to constraint, 5.1
crossedition
See crossedition trigger
enforcing referential integrity with, 2.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, 2.6
undo data, 12.1
UNDO_RETENTION parameter, 2.3
undoing transaction, 2.2.5
unhandled exception, 6.5.2
Unicode
character literals and, 1.2.1
regular expressions and, 3.3
UNIQUE constraint
crossedition trigger and, 19.3.4.1.1
dropping, 5.17
naming, 5.13.2
on FOREIGN KEY constraint, 5.8.2, 5.8.2
when to use, 5.7
universal rowid (urowid), 1.7.3
unrepeatable read, 2.7.1
upgrading applications online
See edition-based redefinition
UROWID data type, 1.7.3
user interface, 13.2.1
stateful and stateless, 13.2.2
user lock, 2.6
user-defined exception, 6.5.1
user-defined type, as subprogram parameter, 6.1.2.2.4
UTLLOCKT.SQL script, 2.6.2

V

VARCHAR data type class, 18.10.2.4
VARCHAR2 data type
compared to CHAR data type, 1.2.2
specifying length of, 1.2.1, 1.2.1
values stored, 1.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
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, 2.2.4
WAIT option of LOCK TABLE statement, 2.5.2, 2.5.2
web application, 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, 2.2.5
wrap utility, debugging and, 6.6.5
write-ability of editioning view, 19.2.3
write-after-write dependency, 12.8.1

X

xa_open string, 15.3.3
XMLType data type, 1.5.5
X/Open Distributed Transaction architecture, 15.1
X/Open Distributed Transaction Processing (DTP) architecture, 15.1

Y

YY datetime format element, 1.4.2