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

Part Number E17125-03
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
View PDF

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  Z 

Symbols

%ROWTYPE attribute, 6.1.2.2.3
%TYPE attribute, 6.1.2.2.3

Numerics

32-bit IEEE 754 format, 2.3.1
3GL (third-generation language), 6.7.4
64-bit IEEE 754 format, 2.3.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
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 isolation level
See isolation level
ANSI/IDO data types, 2.5.7
AnyData data type, 2.5.6
AnyDataSet data type, 2.5.6
AnyType data type, 2.5.6
AP (application program), 15.1.1
application architecture, 13.1
application program (AP), 15.1.1
application SQL, 19.3.3.2.3
APPLYING_CROSSEDITION_TRIGGER function, 19.3.4.1.2
AQ (Oracle Advanced Queuing), 16.2.2
archive
See Flashback Data Archive
ARGn data type, 2.9
arithmetic operation
with date and time data type, 2.4.5
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, 1.9

B

backward compatibility
LONG and LONG RAW data types for, 2.2.1
RESTRICT_REFERENCES pragma for, 6.9.4.4
BATCH commit redo option, 1.3.4
BFILE data type, 2.5.3
binary format, 2.3.2.1
binary large object (BLOB) data type, 2.5.3
binary number, 2.3.2
binary ROWID, 2.7.2.3
BINARY_DOUBLE data type, 2.3.1
BINARY_FLOAT data type, 2.3.1
BLOB data type, 2.5.3
block, anonymous, 6.1.1
branch, 15.1.1
built-in function
display type of, 2.9
in regular expression, 3.1.3
metadata for, 2.9, 2.9
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
century, 2.4.3
CHANGE_DUPKEY_ERROR_INDEX hint, 19.3.4.1.2
CHAR data type, compared to VARCHAR2 data type, 2.2.3
character data type class, 18.10.2.4
character data types, 2.2.1
character large object (CLOB) data type, 2.5.3
character literal in SQL statement, 2.2.4
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
cluster, creating index for, 4.2.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.2
commit redo management, 1.3.4
COMMIT statement, 1.3.3
committing transaction, 1.3.3
comparison operators, 2.3.3
compile-time error, handling
in general, 6.4
for multilanguage program, 14.11
composite FOREIGN KEY constraint, 5.2
composite index, 4.2.5
concurrency
serializable transaction for, 1.8
under explicit locking, 1.6.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.2
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, 2.4.2
current edition, 19.1.6
cursor
in general, 1.5
canceling, 1.5.5
closing, 1.5.4
crossedition trigger and, 19.4
number in session, 1.5.1
Oracle XA application and, 15.3.4
rerunning statement with, 1.5.2
schema object dependency and, 18.11
scrollable, 1.5.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 manipulation language statement
See DML statement
data type
in general, 2.1
ANSI/ISO, 2.5.7
DB2, 2.5.7
dynamic, 2.5.6
external, 2.1
family of, 2.9
for character data, 2.2
for date and time data, 2.4
for numeric data, 2.3
for specialized data, 2.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 data types, 2.5.7
of ANSI/ISO data types, 2.5.7
of date and time data types, 2.4.6
of DB2 data types, 2.5.7
of native floating-point data types, 2.3.5
of SQL/DS data types, 2.5.7
date and time data types
in general, 2.4.1
arithmetic operations with, 2.4.5
converting, 2.4.6
exporting, 2.4.7
importing, 2.4.7
DATE data type, 2.4.1
date data type class, 18.10.2.4
date format
changing default, 2.4.3
default, 2.4.2
DB2 data types, 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.7
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.2.1
that generates notification, 11.3.2
deadlock, undetected, 1.7
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
dependent object
See schema object dependency
dependent transaction, 12.9.1
DESC keyword, 4.5.1
descendent edition, 19.1.2
DETERMINISTIC function
in general, 6.9.4.2
index and, 4.5.2
RPC signature and, 18.10.2
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
processing, 1.1
that references collection, 6.1.2.15.1
DML_LOCKS initialization parameter, 1.6, 1.6
domain index, 4.4
drivers, Oracle JDBC, 13.4.2.1
DROP INDEX statement, 4.2.7
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
evolved Abstract Data Type (ADT)
resetting, 19.1.1.3
exception
IEEE 754 format
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.6.2.4
EXPR data type, 2.9
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 ROWID, 2.7.2.2
external binary ROWID, 2.7.2.3
external data type, 2.1
external large object (BFILE) data type, 2.5.3
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
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.2
Flashback Data Archive, 12.10
Flashback Transaction, 12.9
FLASHBACK_TRANSACTION_QUERY view, 12.5
floating-point data type
See native floating-point data type
floating-point number format, 2.3.2
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 built-in function
controlling side effects of, 6.9.4
DETERMINISTIC
in general, 6.9.4.2
index and, 4.5.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 built-in function
See also subprogram
function result cache, 6.1.2.7
function-based index
in general, 4.5
editioned function and, 19.1.1.2
examples of, 4.5.3
optimizer and, 4.5.1
sorting with, 4.5.1

G

Geographic Information System (GIS) data, 2.5.1
global transaction, 15.1.1
global variable, in C external subprogram, 14.13.6
group commit, 1.3.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 format
in general, 2.3.1
exception
not raised, 2.3.2.2
raised during conversion, 2.3.5
OCI support for, 2.3.6.1
special values supported by, 2.3.2.2
IGNORE_ROW_ON_DUPKEY_INDEX hint, 19.3.4.1.2
IMMEDIATE commit redo option, 1.3.4
IN OUT subprogram parameter mode, 6.1.2.2.1
IN subprogram parameter mode, 6.1.2.2.1
independent transaction, 1.9
index
application-specific, 4.2
composite, 4.2.5
creating
examples of, 4.3
for cluster, 4.2.1
for table, 4.2.1
privileges needed for, 4.1
temporary table space for, 4.2.2
with SQL*Loader, 4.2.2
domain, 4.4
dropping, 4.2.7
edition-based redefinition and, 19.2.6
function-based
in general, 4.5
examples of, 4.5.3
on MGD_ID column, 17.3.2
overhead for, 4.2.4
statistics for, 4.2.6
where to put, 4.2.3
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.6
FIXED_DATE, 2.4.2
OPEN_CURSORS, 1.5.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
INTERVAL DAY TO SECOND data type, 2.4.1
INTERVAL YEAR TO MONTH data type, 2.4.1
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
choosing, 1.8.4.3
READ COMMITTED, 1.8.4
SERIALIZABLE, 1.8.4
setting, 1.8.2
transaction interaction and, 1.8

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) data types
list of, 2.5.3
Oracle Objects for OLE support for, 13.11.3
leaf edition, 19.1.2
LGWR (log writer process), 1.3.4, 1.3.4
libunit, 14.2
lightweight queue, 16.3
loadpsp utility, 10.6
LOB (large object) data types
list of, 2.5.3
Oracle Objects for OLE support for, 13.11.3
LOCK TABLE statement, 1.6.2
locking row explicitly, 1.6.4
locking table
explicitly, 1.6
implicitly, 1.6.3
log writer process (LGWR), 1.3.4
logical rowid, 2.7.3
LONG RAW data type, 2.5.3
loose coupling, 15.1.1
LOWER function, 4.5.1

M

main transaction, 1.9
maximum availability of table, 19.2.1
metacharacter in regular expression, 3.2
metadata for built-in function, 2.9
MGD_ID ADT, 17.1
MGD_ID database ADT function, 17.3.3
mod_plsql module, 9.2.1.1
mode, 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
multilingual extensions to POSIX standard, 3.2.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
native execution, compiling subprogram for, 6.2
native floating-point data type
in general, 2.3.1
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
NCLOB data type, 2.5.3
negative infinity, 2.3.2.2
negative zero, 2.3.2.2
new features, Preface
NLSSORT function, 4.5.1
noneditionable schema object type, 19.1.1.1
noneditioned object, 19.1.1
nonpersistent queue, 16.3
normalized floating-point number, 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.3.4
NOWAIT option of LOCK TABLE statement, 1.6.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.1
number data type class, 18.10.2.4
numeric data types, 2.3.1

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, 2.5.3
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
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.5.1
optimizer
editioning view and, 19.2.7
function-based index and, 4.5.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.3.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 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.7
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
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.10
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
PERL-influenced extensions to POSIX standard, 3.2.3
persistent LOB instance, 2.5.3
persistent queue, 16.3
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 metacharacter in regular expression, 3.2.1
POSIX standard
extensions to
multilingual, 3.2.2
PERL-influenced, 3.2.3
in regular expression, 3.1.4
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 indexes, 4.1
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
raw data type class, 18.10.2.4
read consistency, 1.6
statement-level, 1.4
transaction-level
in general, 1.4
locking tables explicitly for, 1.6
read-only transaction for, 1.4
read-only editioning view, 19.2.1
read-only transaction, 1.4
read-write editioning view, 19.2.1
redefinition, edition-based, 19
redo information for transaction, 1.3.4
redo management, 1.3.4
referenced object
See schema object dependency
referential integrity and serializable transaction, 1.8.3
referential integrity key
See FOREIGN KEY constraint
REGEXP_COUNT function, 3.1.3
REGEXP_INSTR function, 3.1.3
REGEXP_LIKE condition, 3.1.3
REGEXP_REPLACE function, 3.1.3
REGEXP_SUBSTR function, 3.1.3
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.1.1
built-in function in, 3.1.3
condition in, 3.1.3
in SQL statement, 3.3
metacharacter in, 3.2
Oracle implementation of, 3.1.3
POSIX standard support in, 3.1.4
relational operators, 2.3.3
remote dependency management, 18.9
remote procedure call dependency management, 18.10
repeatable read
in general, 1.4
read-only transaction for, 1.4
repeatable reads
locking tables explicitly for, 1.6
required public information, 15.1.2
rerunning SQL statement, 1.5.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 ROWID, 2.7.2.1
result cache, 6.1.2.7
resumable storage allocation, 1.10
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.3.5
rolling back transaction, 1.3.5
root edition, 19.1.2
rounding floating-point numbers, 2.3.2
routine
See subprogram
row
address of (rowid), 2.7
locking explicitly, 1.6.4
ROW EXCLUSIVE MODE option of LOCK TABLE statement, 1.6.2.1, 1.6.2.1
ROW SHARE MODE option of LOCK TABLE statement, 1.6.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 date format element, 2.4.3
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.10
for user-defined exception, 6.5.1
See also exception

S

SAVEPOINT statement, 1.3.6, 1.3.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.5.3
searchable text, 2.5.4
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, 1.6.4
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.2
identifying, 19.3.4.1.2
serializable transaction
for concurrency control, 1.8
isolation level of, 1.8.2
referential integrity and, 1.8.3
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.4
SHARE MODE option of LOCK TABLE statement, 1.6.2.2
SHARE ROW EXCLUSIVE MODE option of LOCK TABLE statement, 1.6.2.3
shared SQL area, 1.1
side effects of function, controlling, 6.9.4
signature checking, 18.9.1
spatial data, 2.5.1
SQL area, shared, 1.1
SQL data type
See data type
SQL function
See built-in function
SQL optimizer hint and editioning view, 19.2.7
SQL statement
application, 19.3.3.2.3
character literal in, 2.2.4
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.2.1
DML statement, 1.1
stages of, 1.1
system management statement, 1.2.3
transaction control statement, 1.2.2
transaction management statement, 1.2.3
rerunning, 1.5.2
static, 6.9.4.4.2
transaction control, 1.2.2
SQL*Loader, creating index with, 4.2.2
SQL/DS data types, 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.4, 1.6
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
for index, 4.2.6
storage allocation error, 1.10
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.2
system management statement, 1.2.3

T

table
locking
choosing strategy for, 1.6.2
explicitly, 1.6
implicitly, 1.6.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
temporary table space, 4.2.2
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 data types
See date and time data types
time stamp checking, 18.9.1
time, changing default format of, 2.4.4
TIMESTAMP data type, 2.4.1
time-stamp dependency mode, 18.10.1
TIMESTAMP WITH LOCAL TIME ZONE data type, 2.4.1
TIMESTAMP WITH TIME ZONE data type, 2.4.1
TM (transaction manager), 15.1.1
TPM (transaction processing monitor), 15.1.1
transaction
autonomous, 1.9
choosing isolation level for, 1.8.4.3
committing, 1.3.3
controlling, 1.2.2
dependent, 12.9.1
distributed
in general, 15.1.1
how it works, 6.8.2
global, 15.1.1
grouping operations into, 1.3.1
improving performance of, 1.3.2
independent, 1.9
main, 1.9, 1.9
read-only, 1.4
redo entry for, 1.3.4
rolling back, 1.3.5
savepoints for, 1.3.6
serializable, 1.8.2
set consistency of, 1.8.4.1
statements in, 1.3.6
transaction control statement, 1.2.2
transaction management statement, 1.2.3
transaction manager (TM), 15.1.1
transaction processing monitor (TPM), 15.1.1
transaction-level read consistency
in general, 1.4
locking tables explicitly for, 1.6
read-only transaction for, 1.4
transform
in general, 19.3.1
applying, 19.3.5
trigger
in general, 6.1.2.16
crossedition
See crossedition trigger
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.7
undo data, 12.1
UNDO_RETENTION parameter, 1.4
undoing transaction, 1.3.5
unhandled exception, 6.5.2
UNIQUE constraint
crossedition trigger and, 19.3.4.1.2
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
upgrading applications online
See edition-based redefinition
UPPER function, 4.5.1
UROWID data type, 2.7.3
user interface
in general, 13.2.1
stateful and stateless, 13.2.2
user lock, 1.7
user-defined exception, 6.5.1
user-defined type, as subprogram parameter, 6.1.2.2.4
UTLLOCKT.SQL script, 1.7.2

V

VARCHAR data type class, 18.10.2.4
VARCHAR2 data type
compared to CHAR data type, 2.2.3
specifying length of, 2.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.3.4
WAIT option of LOCK TABLE statement, 1.6.2, 1.6.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.3.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
XML data, 2.5.5
XMLType data type, 2.5.5
X/Open Distributed Transaction architecture, 15.1
X/Open Distributed Transaction Processing (DTP) architecture, 15.1

Y

YY date format element, 2.4.3

Z

zero, IEEE 754 representation of, 2.3.2.2