Skip Headers
Oracle® Database Development Guide
12c Release 1 (12.1)

E17620-15
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 

Numerics

32-bit IEEE 754 format, 7.3.2
64-bit IEEE 754 format, 7.3.2

A

Abstract Data Type (ADT), 11.4.4.3
native floating-point data types in, 7.3.7
resetting evolved, 24.1.1.4.2
ACCESSIBLE BY clause
in package specification, 11.2
stored subprogram and, 11.1
actual object, 24.1.3
actualization, 24.1.3
address of row (rowid), 7.6
administrators, restricting with Oracle Database Vault, 3.3
ADT
See Abstract Data Type (ADT)
AFTER SUSPEND trigger, 6.8.2.1
agent, 20.3
aggregate function, 11
altering application online
See edition-based redefinition (EBR)
analytic function, 1.9.1
ancestor edition, 24.1.2
ANSI data type, 7.5.7
ANYDATA data type, 7.5.6
ANYDATASET data type, 7.5.6
AP (application program), 19.1.1
application architecture, 17.1
application continuity, 26
application domain index, 9.3
application program (AP), 19.1.1
application SQL, 24.3.3.2.3
APPLYING_CROSSEDITION_TRIGGER function, 24.3.4.1.1
AQ (Oracle Advanced Queuing), 20.2.2
archive
See Flashback Data Archive
ARGn data type, 7.7.1
arithmetic operation
with datetime data type, 7.4.4
with native floating-point data type, 7.3.5
assignment, reported by PL/Scope, 12.6
auditing
available options, 3.6
unified auditing, 3.6
auditing policy, editioning view and, 24.5.1
AUTHID clause
in package specification, 11.2
stored subprogram and, 11.1
AUTHID property
of invoked subprogram, 11.8
of PL/SQL unit, 11.3
Automatic Undo Management system, 16.1
Automatic Workload Repository (AWR), 2.7.6
autonomous transaction, 6.7
trigger as, 6.8.2.1
auto-tuning OCI client statement cache, 2.9

B

backward compatibility
LONG and LONG RAW data types for, 7.5.3.2
RESTRICT_REFERENCES pragma for, 11.9.4.3
BATCH commit redo option, 6.2.3
BFILE data type, 7.5.3.1
binary floating-point number, 7.3.2
binary format, 7.3.2.1
binary large object (BLOB) data type, 7.5.3.1
BINARY_DOUBLE data type, 7.3
BINARY_FLOAT data type, 7.3
BINARY_INTEGER data type
See PLS_INTEGER data type
BLOB data type, 7.5.3.1
block, PL/SQL, 11.1
BOOLEAN data type, 11.4.4.1.2
branch, 19.1.1
built-in data type
See SQL data type
built-in function
See SQL function
bulk binding, 11.4.8
business rule, 10

C

C external subprogram
callback with, 18.13
global variable in, 18.13.6
interface between PL/SQL and, 18.5.2
invoking, 18.10.4
loading, 18.4
passing parameter to, 18.9
publishing, 18.7
running, 18.10
service routine and, 18.12
See also external subprogram
call specification
for external subprogram, 18.3
in package, 11.2
location of, 18.8
CALL statement, 18.10
calling subprogram
See invoking subprogram
cascading invalidation, 23.4
CHANGE_DUPKEY_ERROR_INDEX hint, 24.3.4.1.1
CHAR data type, 7.2
character data type class, 23.10.2.4
character data types, 7.2
character large object (CLOB) data type, 7.5.3.1
CHECK constraint
compared to NOT NULL constraint, 10.12.4
designing, 10.12.2
multiple, 10.12.3
naming, 10.13.2
restrictions on, 10.12.1
when to use, 10.12
client notification, 20.2.3
client result cache, 2.7.5
client statement cache auto-tuning (OCI client session feature), 2.9
client/server architecture, 17.1.1
CLOB data type, 7.2, 7.5.3.1
coarse-grained invalidation, 23.4
collection, 11.4.4.2
referenced by DML statement, 11.4.8.1
referenced by FOR loop, 11.4.8.3
referenced by SELECT statement, 11.4.8.2
column
generated, 24.1.1.2.2
multiple foreign key constraints on, 10.8.3
virtual, 24.1.1.2.2
when to use default value for, 10.5
commit redo management, 6.2.3
compilation parameter, 11.3
composite PL/SQL data type, 11.4.4.2
concurrency
serializable transaction for, 6.6
under explicit locking, 6.4.5
conditional compilation, 5.6
connection pool, 17.6.1
constraint, 10
altering, 10.15
CHECK
See CHECK constraint
compared to trigger, 10.1
crossedition trigger and
collisions, 24.3.4.1.1
dropping, 24.3.6
deferring checking of, 10.8.4
disabling
effect of, 10.14
existing, 10.14.5, 10.14.5
new, 10.14.3, 10.14.3
reasons for, 10.14.1
dropping, 10.17, 10.17
editioning view and, 24.2.6
enabling
effect of, 10.14
existing, 10.14.4
new, 10.14.2
exception to, 10.14.7
FOREIGN KEY
See FOREIGN KEY constraint
minimizing overhead of, 10.9
naming, 10.13.2
NOT NULL
See NOT NULL constraint
on view, 10
PRIMARY KEY
See PRIMARY KEY constraint
privileges needed for defining, 10.13.1
referential integrity
See FOREIGN KEY constraint
renaming, 10.16
UNIQUE
See UNIQUE constraint
viewing definition of, 10.19
violation of, 10.14.7
Continuous Query Notification (CQN), 15
example, 15.8.6
converting data types
See data type conversion
copy-on-change strategy, 24.1.3
coupling, 19.1.1
CQ_NOTIFICATION$_DESCRIPTOR object, 15.10.1
CQ_NOTIFICATION$_QUERY object, 15.10.3
CQ_NOTIFICATION$_REG_INFO object, 15.7.6.2
CQ_NOTIFICATION$_ROW object, 15.10.4
CQ_NOTIFICATION$_TABLE object, 15.10.2
CQN (Continuous Query Notification), 15
CREATE OR REPLACE optimization, 23.4
actualization and, 24.1.3
crossedition trigger, 24.3
creating, 24.3.4
displaying information about, 24.4.3
dropping, 24.3.6
execution of, 24.3.3.4
forward, 24.3.1
interaction with editions, 24.3.3
read-only editioning view and, 24.2.1
read-write editioning view and, 24.2.1
reverse, 24.3.2
scope of, 24.1
sharing child cursor and, 24.4.3
crossedition trigger SQL
forward, 24.3.3.2.1
reverse, 24.3.3.2.2
cross-session PL/SQL function result cache, 11.4.7
current date and time, displaying, 7.4.1
current edition, 24.1.6
cursor, 11.4.5
crossedition trigger and, 24.4.3
explicit, 11.4.5
implicit, 11.4.5
Oracle XA application and, 19.3.4
schema object dependency and, 23.11
session, 11.4.5
cursor variable, 11.4.4.1.4
advantages of, 11.4.5.1
disadvantages of, 11.4.5.2

D

data cartridge, 1.3.1
data definition language statement
See DDL statement
data integrity, 10
data type and, 7.1.1
See also constraint
data type
ANSI, 7.5.7
BOOLEAN, 11.4.4.1.2
DB2, 7.5.7
dynamic, 7.5.6
external, 7
for character data, 7.2
for datetime data, 7.4
for geographic data, 7.5.1
for large amount of data, 7.5.3
for multimedia data, 7.5.2
for numeric data, 7.3
for spatial data, 7.5.1
for XML data, 7.5.5
importance of correct, 7.1
PLS_INTEGER, 11.4.4.1.3
PL/SQL, 11.4.4
REF CURSOR, 11.4.4.1.4
SQL, 7
SQL/DS, 7.5.7
data type class, 23.10.2.4
data type conversion
of ANSI and IBM data types, 7.5.7
of datetime data types, 7.4.5
of native floating-point data types, 7.3.6
data type family
PL/SQL, 11.4.4.1
SQL, 7.7.3
database hardening, 16.9
database logins, automated, 3.2
date
default format for, 7.4.1
displaying, 7.4.2
current, 7.4.1
inserting, 7.4.2
See also datetime data types
datetime data type class, 23.10.2.4
datetime data types, 7.4
arithmetic operations with, 7.4.4
conversion functions for, 7.4.5
importing, exporting, and comparing, 7.4.6
day, default value for, 7.4.3
DB2 data type, 7.5.7
DBMS_DEBUG package, 11.10.5
DBMS_FLASHBACK package, 16.7
DBMS_FLASHBACK_ARCHIVE procedures, 16.9
DBMS_FLASHBACK.TRANSACTION_BACKOUT procedure, 16.8
DBMS_HPROF package, 13.2
DBMS_LOCK package, 6.5
DBMS_OUTPUT package, 11.10
DBMS_PARALLEL_EXECUTE package, 24.3.5
DBMS_SQL.RETURN_RESULT procedure, 11.4.5.3
DBMS_STATS package, 16.11
DBMS_TYPES package, 7.5.6
DBMS_XA package, 19.3.10
DDL statement
Flashback Data Archive and, 16.9.6
for creating package, 11.4.2
for creating subprogram, 11.4.2
ineffective, 23.4
Oracle XA and, 19.5.4.2
processing, 6.1.1
that generates notification, 15.3.2
deadlock, undetected, 6.5
debugging
compiling PL/SQL unit for, 11.10.3
external subprogram, 18.13.4
low-level code, 11.10.5
subprogram, 11.10
wrap utility and, 11.10.3
decimal floating-point number, 7.3.2
default column value, 10.5
deferring constraint checks, 10.8.4
definer’s rights, 3.4.1
denormal floating-point number, 7.3.2.1
dependency mode, 23.10
dependent object
See schema object dependency
dependent transaction, 16.8.1
descendent edition, 24.1.2
DETERMINISTIC function
function-based index and, 9.4.2
RPC signature and, 23.10.2
dirty read, 6.6.1
disabling constraint
effect of, 10.14
existing, 10.14.5
new, 10.14.3
reasons for, 10.14.1
distributed database
FOREIGN KEY constraint and, 10.11
remote dependency management and, 23.9
distributed transaction, 19.1.1
remote subprogram and, 11.8.4.2
DLL (dynamic link library), 18.2
DML statement
bulk binding for, 11.4.8.1
that references collection, 11.4.8.1
DML_LOCKS initialization parameter, 6.4, 6.4
domain index, 9.3
double-precision IEEE 754 format, 7.3.2
drivers, Oracle JDBC, 17.4.2.1
DTP (X/Open Distributed Transaction architecture), 19.1
dynamic link library (DLL), 18.2
dynamic registration, 19.1.1
dynamic session state consistency, 26.2.4
dynamic SQL, 11.4.9
implicit query results and, 11.4.5.3
RESTRICT_REFERENCES pragma and, 11.9.4.3.2
dynamically typed data, 7.5.6

E

EBR (edition-based redefinition), 24
edition, 24.1
ancestor, 24.1.2
creating, 24.1.2
crossedition triggers and, 24.3.3
current, 24.1.6
descendent, 24.1.2
displaying information about, 24.4.1
dropping, 24.1.8
enabling for user and types, 24.1.1.4
evaluation
See evaluation edition
leaf, 24.1.2
making available
to all users, 24.1.5
to some users, 24.1.4
ora$base, 24.1, 24.1.2
retiring, 24.1.7
root, 24.1.2
scope of, 24.1
session, 24.1.6
unusable
See unusable edition
visibility of trigger in, 24.3.3.1
EDITIONABLE property, 24.1.1.5
editionable schema object type, 24.1.1.3
edition-based redefinition (EBR), 24
editioned object, 24.1.1
creating or replacing, 24.1.1.5.1
name resolution and, 24.1.1.1
editioning view, 24.2
auditing policy and, 24.5.1
changing base table of, 24.2.5
changing writability of, 24.2.3
covering table with, 24.5.1
creating, 24.2.1
displaying information about, 24.4.2
partition-extended name for, 24.2.2
preparing application for, 24.5.1
read-only, 24.2.1
read-write, 24.2.1
replacing, 24.2.4
scope of, 24.1
SQL optimizer hint and, 24.2.7
Electronic Product Code (EPC), 22.7.2.1
embedded PL/SQL gateway, 14.2.1.2
how to use, 14.4
enabling constraint
effect of, 10.14
existing, 10.14.4
new, 10.14.2
enabling editions, 24.1.1.4
encoding scheme, adding, 22.3.4
environment, programming, 17
EPC (Electronic Product Code), 22.7.2.1
evaluation edition, 24.1.1.2
dropping edition and, 24.1.8
for materialized view, 24.1.1.2.1
for virtual column, 24.1.1.2.2
retiring edition and, 24.1.7
exception
IEEE 754 standard
not raised, 7.3.3
raised during conversion, 7.3.6
in multilanguage program, 18.11
to constraint, 10.14.7
exception handling, 5.5
for storage allocation error, 6.8
EXCLUSIVE MODE option of LOCK TABLE statement, 6.4.2.4
EXECUTE privilege, 11.4.1
execution plan, 2.2.1.3
data type and, 7.1.3
explicit cursor, 11.4.5
EXPR data type, 7.7.2
expression
index built on
See function-based index
regular
See regular expression
extensibility, 1.3
external data type, 7
external large object (BFILE) data type, 7.5.3.1
external subprogram, 18.2
call specification for, 18.3
debugging, 18.13.4
loading, 18.4
managing for applications, 3.5
publishing, 18.5
external transaction manager, 19.1.1

F

family of data types
PL/SQL, 11.4.4.1
SQL, 7.7.3
Fast Application Notification (FAN), 2.13.1
fine-grained access control, 3.3
fine-grained auditing (FGA) policy, editioning view and, 24.5.1
fine-grained invalidation, 23.4
firing order of triggers, 24.3.3.3
FIXED_DATE initialization parameter, 7.4.1
fixed-point data type, 7.3
Flashback Data Archive, 16.9
Flashback Transaction, 16.8
FLASHBACK_TRANSACTION_QUERY view, 16.5
FLOAT data type, 7.3
floating-point data type, 7.3
range and precision of, 7.3.2
See also native floating-point data type
floating-point number
binary, 7.3.2
components of, 7.3.1
decimal, 7.3.2
denormal, 7.3.2.1
format of, 7.3.2
rounding, 7.3.2
subnormal, 7.3.2.1
FOR loop
bulk binding for, 11.4.8.3
that references collection, 11.4.8.3
FORCE option of ALTER USER statement, 24.1.1.4.1
FOREIGN KEY constraint, 10.8
distributed databases and, 10.11
dropping, 10.17
editioned view and, 24.1.1.6
enabling, 10.18
Flashback Transaction and, 16.8.1
indexing, 10.10
multiple, 10.8.3
naming, 10.13.2
NOT NULL constraint on, 10.8.2, 10.8.2
NULL value and, 10.8.1
privileges needed to create, 10.18.4
referential integrity enforced by, 10.18.5
UNIQUE constraint on, 10.8.2, 10.8.2
without other constraints, 10.8.2
foreign key dependency, 16.8.1
forward compatibility, 1.3
forward crossedition trigger, 24.3.1
forward crossedition trigger SQL, 24.3.3.2.1
function
aggregate, 11
analytic, 1.9.1
built-in
See SQL function
DETERMINISTIC
function-based index and, 9.4.2
RPC signature and, 23.10.2
invoking from SQL statement, 11.9
MGD_ID ADT, 22.3.3
OCI or OCCI, 17.7.2
PARALLEL_ENABLE, RPC signature and, 23.10.2
PL/SQL, invoked by SQL statement, 11.9
purity of, 11.9.4
RPC signature and, 23.10.2
result-cached, 11.4.7
returning large amount of data from, 11.4.6
SQL
See SQL function
SQL analytic, 1.9.1
See also subprogram
function result cache, 11.4.7
function-based index, 9.4
examples of, 9.4.3
optimizer and, 9.4, 9.4.1

G

generated column, 24.1.1.2.2
Geographic Information System (GIS) data, 7.5.1
GET_LTXID_OUTCOME procedure, 6.2.4.2
global transaction, 19.1.1
global variable, in C external subprogram, 18.13.6
greedy operator in regular expression, 8.4.1
group commit, 6.2.3

H

hierarchical profiler, 13
historical data, importing and exporting, 16.9
host language, 17.6
host program, 17.6
hot rollover, 24

I

IA-32 and IA-64 instruction set architecture, 7.3.5
IBM CICS, 19.1.1
IBM Transarc Encina, 19.1.1
Identity Code Package, 22
IEEE 754 standard, 7.3
exception
not raised, 7.3.3
raised during conversion, 7.3.6
special values supported by, 7.3.3
See also native floating-point data type
IGNORE_ROW_ON_DUPKEY_INDEX hint, 24.3.4.1.1
IMMEDIATE commit redo option, 6.2.3
implicit cursor, 11.4.5
independent transaction
See autonomous transaction
index, 9
domain, 9.3
edition-based redefinition and, 24.2.6
function-based
See function-based index
on MGD_ID column, 22.3.2
infinity, 7.3.3, 7.3.3
in-flight transaction, 6.2.4
INHERIT ANY PRIVILEGES system privilege, 3.4.2
INHERIT PRIVILEGES privilege, 3.4.2
inherited object, 24.1.3
initialization parameter, 11.3
DML_LOCKS, 6.4
FIXED_DATE, 7.4.1
NLS_DATE_FORMAT, 7.4.1
integer data type class, 23.10.2.4
integrity constraint
See constraint
integrity of data
See data integrity
interface
between PL/SQL and C, 18.5.2
between PL/SQL and Java, 18.5.1
program, 17.2
TX, 19.1.1
user, 17.2.1
stateful or stateless, 17.2.2
See also Oracle Call Interface
invalidation
cascading, 23.4
coarse-grained, 23.4
fine-grained, 23.4
of dependent object, 23.4
of package, 11.11
invoker’s rights, 3.4.1
affect on invoker’s privileges, 3.4.2
Java stored procedures, 3.4.3
invoking subprogram, 11.8
from subprogram, 11.8.3
from trigger, 11.8.3
interactively from Oracle Database tools, 11.8.2
through embedded PL/SQL gateway, 14.4.4
isolation level
See transaction isolation level

J

Java class method
calling, 18.10.3
interface between PL/SQL and, 18.5.1
publishing, 18.6
See also external subprogram
Java Database Connectivity
See Oracle JDBC
Java language
compared to PL/SQL, 17.5
Oracle Database support for, 17.4
Java stored procedures, 3.4.3
Java Virtual Machine
See Oracle JVM
JDBC
See Oracle JDBC
JVM
See Oracle JVM

K

key
foreign
See FOREIGN KEY constraint
primary
See PRIMARY KEY constraint
unique
See UNIQUE constraint

L

Large Object (LOB), 7.5.3.1
leaf edition, 24.1.2
LGWR (log writer process), 6.2.3, 6.2.3
lightweight queue, 20.3
live operation, 24
LOB
See Large Object (LOB)
LOCK TABLE statement, 6.4.2
SELECT FOR UPDATE statement with, 6.4.5
locking row explicitly, 6.4.4
locking table
explicitly, 6.4
implicitly, 6.4.3
log writer process (LGWR), 6.2.3
logical transaction identifier (LTXID), 6.2.4.1
logical value, 11.4.4.1.2
LONG and LONG RAW data types, 7.5.3.2
LONG data type, 7.2
loose coupling, 19.1.1
low-level code, debugging, 11.10.5
LTXID (logical transaction identifier), 6.2.4.1

M

main transaction, 6.7
managing default rights, 3.4.3
materialized view, 1.9.2
that depends on editioned object, 24.1.1.2.1
maximum availability of table, 24.2.1
metacharacter in regular expression, 8.1
metadata for SQL operator or function, 7.7
MGD_ID ADT, 22.1
MGD_ID database ADT function, 22.3.3
mod_plsql module, 14.2.1.1
mode
dependency, 23.10
lock, 6.4.2
serialized
See serializable transaction
MODIFY CONSTRAINT clause of ALTER TABLE statement, 10.15
modifying
See altering
multilanguage program, 18.1
error or exception in, 18.11
multiline mode, 8.2
multilingual data, 8.4.2
multimedia data, 7.5.2

N

name resolution, 23.7
editions and, 24.1.1.1
NaN (not a number), 7.3.3
national character large object (NCLOB) data type, 7.5.3.1
native execution, 11.7
native floating-point data type, 7.3
arithmetic operation with, 7.3.5
binary format for, 7.3.2.1
conversion functions for, 7.3.6
in client interfaces, 7.3.7
special values for, 7.3.3
NCHAR data type, 7.2
NCLOB data type, 7.2, 7.5.3.1
negative infinity, 7.3.3
negative zero, 7.3.3
nested subprogram, 11.1
NLS_DATE_FORMAT initialization parameter, 7.4.1
NONEDITIONABLE property, 24.1.1.5
noneditionable schema object type, 24.1.1.3
noneditioned object, 24.1.1
creating or replacing, 24.1.1.5.1
name resolution and, 24.1.1.1
that can depend on editioned object, 24.1.1.2
dropping edition and, 24.1.8
FORCE and, 24.1.1.4.1
nongreedy operator in regular expression, 8.4.3
nonpersistent queue, 20.3
noreplay keyword (killing or disconnecting session), 26.2.2.9
normalized significand, 7.3.2.1
NOT NULL constraint
compared to CHECK constraint, 10.12.4
naming, 10.13.2
on FOREIGN KEY constraint, 10.8.2, 10.8.2
when to use, 10.4
NOWAIT commit redo option, 6.2.3
NOWAIT option of LOCK TABLE statement, 6.4.2
NULL value
FOREIGN KEY constraint and, 10.8.1
function-based index and, 9.4
indexing and, 10.4
NUMBER data type, 7.3
number data type class, 23.10.2.4
numeric data types, 7.3
NVARCHAR2 data type, 7.2

O

object
actual, 24.1.3
dependent
See schema object dependency
editioned
See editioned object
inherited, 24.1.3
large
See Large Object (LOB)
noneditioned
See noneditioned object
potentially editioned, 24.1.1
with noneditioned dependents, 24.1.1.4.1
referenced
See schema object dependency
size limit for PL/SQL stored, 11.4.3
object change notification, 15.1
OCCI
See Oracle C++ Call Interface
OCI
See Oracle Call Interface
OCI_ATTR_CHDES_DBNAME, 15.8.5.1
OCI_ATTR_CHDES_NFTYPE, 15.8.5.1
OCI_ATTR_CHDES_QUERIES, 15.8.5.1
OCI_ATTR_CHDES_ROW_OPFLAGS, 15.8.5.1.2
OCI_ATTR_CHDES_ROW_ROWID, 15.8.5.1.2
OCI_ATTR_CHDES_TABLE_CHANGES, 15.8.5.1
OCI_ATTR_CHDES_TABLE_NAME, 15.8.5.1.2
OCI_ATTR_CHDES_TABLE_OPFLAGS, 15.8.5.1.2
OCI_ATTR_CHDES_TABLE_ROW_CHANGES, 15.8.5.1.2
OCI_ATTR_CHDES_XID, 15.8.5.1
OCI_ATTR_CHNF_CHANGELAG, 15.8.3
OCI_ATTR_CHNF_OPERATIONS, 15.8.3
OCI_ATTR_CHNF_ROWIDS, 15.8.3
OCI_ATTR_CHNF_TABLENAMES, 15.8.3
OCI_ATTR_CQ_QUERYID, 15.8.4
OCI_ATTR_CQDES_OPERATION, 15.8.5.1.1
OCI_ATTR_CQDES_QUERYID, 15.8.5.1.1
OCI_ATTR_CQDES_TABLE_CHANGES, 15.8.5.1.1
OCI_ATTR_PURITY_NEW, 2.12.5.1
OCI_ATTR_PURITY_SELF, 2.12.5.1
OCI_ATTR_SESSION_STATE, 2.12.13, 2.12.14
OCI_ATTR_SUBSCR_CALLBACK, 15.8.3
OCI_ATTR_SUBSCR_CQ_CHNF_QOSFLAGS, 15.8.3
OCI_ATTR_SUBSCR_NAMESPACE, 15.8.3
OCI_ATTR_SUBSCR_QOSFLAGS, 15.8.3
OCI_ATTR_SUBSCR_TIMEOUT, 15.8.3
OCI_DTYPE_CQDES, 15.8.5.1.1
OCI_SESSGET_PURITY_NEW, 2.12.5.1
OCI_SESSGET_PURITY_SELF, 2.12.5.1
OCI_SESSION_STATEFUL, 2.12.14
OCI_SESSION_STATELESS, 2.12.13, 2.12.14
OCI_SPC_NO_RLB, 2.13.2
OCI_SUBSCR_QOS_PURGE_ON_NTFN, 15.8.3
OCI_SUBSCR_QOS_RELIABLE, 15.8.3
OCIAnyData and OCIAnyDataSet interfaces, 7.5.6
ODP.NET, 17.9
online application upgrade
See edition-based redefinition (EBR)
operator
in regular expression, 8.4
greedy, 8.4.1
nongreedy, 8.4.3
metadata for, 7.7
optimizer
editioning view and, 24.2.7
function-based index and, 9.4, 9.4.1
RPC signature and, 23.10.2
ora$base edition, 24.1, 24.1.2
Oracle Advanced Queuing (AQ), 20.2.2
Oracle C++ Call Interface, 17.7
building application with, 17.7.4
kinds of functions in, 17.7.2
native floating-point data types in, 7.3.7
procedural and nonprocedural elements of, 17.7.3
Oracle Call Interface, 17.7
building application with, 17.7.4
commit redo action in, 6.2.3
compared to precompiler, 17.8
kinds of functions in, 17.7.2
native floating-point data types in, 7.3.7
procedural and nonprocedural elements of, 17.7.3
with Oracle XA, 19.3.5
Oracle Data Provider for .NET, 17.9
Oracle Data Redaction, 3.3
Oracle data type
See SQL data type
Oracle Database Vault, 3.3
Oracle Extensibility Architecture framework, user-defined aggregate functions and, 1.3.3
Oracle Extensibility Architecture, data cartridges and, 1.3.1
Oracle Flashback Query, 16.3
Oracle Flashback Technology, 16.1
application development features, 16.1.1
configuring database for, 16.2
database administration features, 16.1.2
performance guidelines for, 16.11
Oracle Flashback Transaction Query, 16.5
Oracle Flashback Version Query, 16.4
Oracle JDBC, 17.4.2
compared to Oracle SQLJ, 17.4.4
native floating-point data types in, 7.3.7
sample program
2.0, 17.4.2.2
pre-2.0, 17.4.2.3
Oracle JDeveloper, Oracle SQLJ and, 17.4.3.1
Oracle JPublisher, 17.4.5
Oracle JVM, 17.4.1
Oracle Label Security, 3.3
Oracle Lock Management services, 6.5
Oracle Multimedia, 7.5.2
Oracle RAC and Oracle XA, 19.5.3
Oracle SQLJ, 17.4.3
compared to Oracle JDBC, 17.4.4
Oracle JDeveloper and, 17.4.3.1
Oracle Text, 7.5.4, 7.5.4
Oracle Total Recall, 16.9
Oracle Tuxedo, 19.1.1
Oracle Virtual Private Database (VPD), 3.3
editioning view and, 24.5.1
Oracle XA
Oracle RAC and, 19.5.3
subprograms, 19.2
when to use, 19
out-of-space error, 6.8
overloaded subprogram, 11.1

P

package
creating, 11.4.2
dropping, 11.6
invalidation of, 11.11
session state and, 23.4.1
size limit for, 11.4.3
synonym for, 11.8.4.1
package body, 11.2
package invalidation and, 11.11
package specification, 11.2
package subprogram, 11.1
PARALLEL_ENABLE function
RPC signature and, 23.10.2
parallelized SQL statement, 11.9.4.2
parameter
compilation
See compilation parameter
initialization, 11.3
partition-extended editioning view name, 24.2.2
partitioning, 1.9.3
performance, data type and, 7.1.3
persistent LOB instance, 7.5.3.1
persistent queue, 20.3
phantom read, 6.6.1
PLS_INTEGER data type, 11.4.4.1.3
PL/Scope tool, 12
plshprof utility, 13.5
PL/SQL block, 11.1
PL/SQL data type, 11.4.4
PL/SQL function result cache, 11.4.7
PL/SQL gateway, 14.2.1
PL/SQL hierarchical profiler, 13
PL/SQL language, 17.3
compared to Java, 17.5
PL/SQL object
See PL/SQL unit
PL/SQL optimize level, 11.3.1
PL/SQL optimizer level, 5.3
PL/SQL unit, 11.3
compiling for debugging, 11.10.3
CREATE OR REPLACE and, 23.4
PL/SQL Web Toolkit, 14.2.2
pool, connection, 17.6.1
positive infinity, 7.3.3
positive zero, 7.3.3
POSIX standard for regular expressions
operators defined in, 8.4.1
Oracle SQL and, 8.3
Oracle SQL multilingual extensions to, 8.4.2
Oracle SQL PERL-influenced extensions to, 8.4.3
potentially editioned object, 24.1.1
with noneditioned dependents, 24.1.1.4.1
precompiler, 17.6
compared to Oracle Call Interface, 17.8
Oracle XA and, 19.3.4
PRIMARY KEY constraint, 10.6
dropping, 10.17
Flashback Transaction and, 16.8.1
naming, 10.13.2
primary key dependency, 16.8.1
privileges, 3.1
for debugging subprogram, 11.10.4
for defining constraint, 10.13.1
for Oracle Flashback Technology, 16.2.5
for running subprogram, 11.8.1
granting secure application roles, 3.1
grouped into roles, 3.1
INHERIT ANY PRIVILEGES system privilege, 3.4.2
INHERIT PRIVILEGES privilege, 3.4.2
revoked, object dependency and, 23.4.2
Pro*C/C++ precompiler, 17.6.1
native floating-point data types in, 7.3.7
Pro*COBOL precompiler, 17.6.2
procedure
See also subprogram
product code, 22.7.2
profiler, 13
program interface, 17.2
programming environment, 17
public information, required, 19.1.2
publish-subscribe model, 20
purity of function, 11.9.4
RPC signature and, 23.10.2

Q

quality-of-service flag, 15.7.6.2
query
registering for Continuous Query Notification, 15.6
returning results to client, 11.4.5
implicitly, 11.4.5.3
Query Result Change Notification (QRCN), 15.2
query rewrite, 1.9.2
queue, 20.3

R

Radio Frequency Identification (RFID) technology, 22.7.1
RAW data type, 7.5.3.2
raw data type class, 23.10.2.4
READ COMMITTED transaction isolation level
compared to SERIALIZABLE, 6.6.4.2
in Oracle Database, 6.6.1
transaction interactions with, 6.6.1
read consistency, 6.4
statement-level, 6.3
transaction-level, 6.3
locking tables explicitly for, 6.4
read-only transaction for, 6.3
read lock, 6.6.3
READ UNCOMMITTED transaction isolation level
in Oracle Database, 6.6.1
transaction interactions with, 6.6.1
read-only editioning view, 24.2.1
read-only transaction, 6.3
read-write editioning view, 24.2.1
record, 11.4.4.2
redefinition, edition-based (EBR), 24
redo information for transaction, 6.2.3
redo management, 6.2.3
REF CURSOR data type, 11.4.4.1.4
referenced object
See schema object dependency
referential integrity
serializable transactions and, 6.6.3
trigger for enforcing, 6.6.3
referential integrity constraint
See FOREIGN KEY constraint
REGEXP_COUNT function, 8.2
REGEXP_INSTR function, 8.2
REGEXP_LIKE condition, 8.2
REGEXP_REPLACE function, 8.2
back reference operator in, 8.4.1
REGEXP_SUBSTR function, 8.2
registration
dynamic, 19.1.1
for Continuous Query Notification, 15.6
in publish-subscribe model, 20.3
static, 19.1.1
regular expression, 8
in Oracle SQL, 8.2
in SQL statement, 8.5
metacharacter in, 8.1
POSIX standard and
See POSIX standard for regular expressions
Unicode and, 8.3
remote dependency management, 23.9
remote procedure call dependency management, 23.10
remote subprogram, 11.8.4
repeatable read, 6.3
locking tables explicitly for, 6.4
read-only transaction for, 6.3
REPEATABLE READ transaction isolation level
in Oracle Database, 6.6.1
transaction interactions with, 6.6.1
required public information, 19.1.2
resource manager (RM), 19.1.1
RESTRICT_REFERENCES pragma
for backward compatibility, 11.9.4.3
static and dynamic SQL and, 11.9.4.3.2
result cache, 11.4.7
resumable storage allocation, 6.8
RETENTION GUARANTEE clause for undo tablespace, 16.2.1
RETENTION option of ALTER TABLE statement, 16.2.4
RETURN_RESULT procedure, 11.4.5.3
reverse crossedition trigger, 24.3.2
reverse crossedition trigger SQL, 24.3.3.2.2
RFID (Radio Frequency Identification) technology, 22.7.1
RM (resource manager), 19.1.1
roles, 3.1
root edition, 24.1.2
rounding floating-point numbers, 7.3.2
row
address of (rowid), 7.6
locking explicitly, 6.4.4
ROW EXCLUSIVE MODE option of LOCK TABLE statement, 6.4.2.1, 6.4.2.1
ROW SHARE MODE option of LOCK TABLE statement, 6.4.2.1
rowid, 7.6
ROWID data type
ROWID pseudocolumn and, 7.6
ROWID pseudocolumn, 7.6
CQN and, 15.7.2.3
See also rowid
RPC dependency management, 23.10
RPC signature and, 23.10.2
RR datetime format element, 7.4.1
rule on queue, 20.3
rules engine, 20.3
runtime error
See exception

S

scalar PL/SQL data type, 11.4.4.1
schema object dependency, 23
in distributed database, 23.9
invalidation and, 23.4
on nonexistence of other objects, 23.7
revoked privileges and, 23.4.2
shared pool and, 23.11
schema object type
editionable, 24.1.1.3
enabling for editions, 24.1.1.4
noneditionable, 24.1.1.3
searchable text, 7.5.4
secure application roles, 3.1
security
auditing, 3.6
external procedures for applications, 3.5
invoker’s rights and definer’s rights, 3.4.1
Java stored procedures default rights, 3.4.3
logon triggers and, 3.2
Oracle Data Redaction, 3.3
Oracle Database Vault, 3.3
Oracle Label Security, 3.3
Oracle Virtual Private Database, 3.3
privilege use, 3.1
privileges of invoking user, 3.4.2
role use, 3.1
secure application roles, 3.1
SELECT FOR UPDATE statement, 6.4.4
LOCK TABLE statement with, 6.4.5
referential integrity and
inside trigger, 6.6.3
outside trigger, 6.6.3
SELECT statement
bulk binding for, 11.4.8.2
referencing collection with, 11.4.8.2
with AS OF clause, 16.3
with FOR UPDATE clause
See SELECT FOR UPDATE statement
with VERSIONS BETWEEN clause, 16.4
semi-available table, 24.2.1
serendipitous change, 24.3.5
data transformation collisions and, 24.3.4.1.1
identifying, 24.3.4.1.1
serializable transaction
for concurrency control, 6.6
interaction with, 6.6.1
referential integrity and, 6.6.3
SERIALIZABLE transaction isolation level
compared to READ COMMITTED, 6.6.4.2
in Oracle Database, 6.6.1
transaction interactions with, 6.6.1
See also serializable transaction
server-side programming, 17.1.2
service routine, C external subprogram and, 18.12
session cursor, 11.4.5
session edition, 24.1.6
session state, 23.4.1
session state consistency, 26.2.4
session variable, 11.8.2
SET CONSTRAINTS statement, 10.8.4
SET TRANSACTION statement with READ ONLY option, 6.3
SHARE MODE option of LOCK TABLE statement, 6.4.2.2
SHARE ROW EXCLUSIVE MODE option of LOCK TABLE statement, 6.4.2.3
shared SQL area, 6.1.2
side effects of subprogram, 11.9.4
signature checking, 23.9.1
single-precision IEEE 754 format, 7.3.2
spatial data, 7.5.1
specification, package
See package specification
SQL analytic function, 1.9.1
SQL area, shared, 6.1.2
SQL data type, 7
SQL function
analytic, 1.9.1
display type of, 7.7.2
for data type conversion, 7.4.5
metadata for, 7.7
SQL optimizer hint and editioning view, 24.2.7
SQL statement
application, 24.3.3.2.3
crossedition trigger
forward, 24.3.3.2.1
reverse, 24.3.3.2.2
invoking PL/SQL function from, 11.9
parallelized, 11.9.4.2
processing
DDL statement, 6.1.1
stages of, 6.1
system management statement, 6.1.1
SQL, dynamic
See dynamic SQL
SQL/DS data type, 7.5.7
SQLJ
See Oracle SQLJ
standalone subprogram, 11.1
state
session, 23.4.1
user interface and, 17.2.2
web application and, 14.6.8
STATEFUL, 2.12.14
STATELESS, 2.12.14
statement
See SQL statement
statement-level read consistency, 6.3, 6.4
static registration, 19.1.1
static session state consistency, 26.2.4
static SQL, RESTRICT_REFERENCES pragma and, 11.9.4.3.2
static variable, in C external subprogram, 18.13.7
statistics
for application, 13
for identifier, 12
storage allocation error, 6.8
storage requirements, decreasing, 7.1.2
stored standalone subprogram, dropping, 11.6
stored subprogram, 11.1
subnormal floating-point number, 7.3.2.1
subprogram, 11.1
creating, 11.4.2
external
See external subprogram
invoking
See invoking subprogram
Oracle XA, 19.2
overloaded, 11.1
privileges needed to debug, 11.10.4
privileges needed to run, 11.8.1
remote, 11.8.4
size limit for, 11.4.3
synonym for, 11.8.4.1
subscriber, 20.3
subscription services, 20.3
subtype, 11.4.4.1
user-defined, 11.4.4.1.5
synonym
CREATE OR REPLACE and, 23.4
for package, 11.8.4.1
for subprogram, 11.8.4.1
SYSDATE function, 7.4.1
system management statement, 6.1.1

T

table
controlling user access to, 3.3
locking
choosing strategy for, 6.4.2
explicitly, 6.4
implicitly, 6.4.3
with maximum availability, 24.2.1
with semi-availability, 24.2.1
Tag Data Translation Markup Language Schema, 22.1
Temporal Validity Support, 1.9.4
temporary LOB instance, 7.5.3.1
thin client configuration, 17.1.3
thread-safe application, 19.3.9
three-tier architecture, 17.1.3
tight coupling, 19.1.1
time
default value for, 7.4.3
displaying, 7.4.3
current, 7.4.1
inserting, 7.4.3
See also datetime data types
time-stamp checking, 23.9.1
time-stamp dependency mode, 23.10.1
TM (transaction manager), 19.1.1
TPM (transaction processing monitor), 19.1.1
tracing tools, 11
transaction
autonomous, 6.7
trigger as, 6.8.2.1
choosing isolation level for, 6.6.4.2
dependent, 16.8.1
determining outcome after outage, 6.2.4
distributed, 19.1.1
remote subprogram and, 11.8.4.2
ensuring idempotence of, 6.2.4
global, 19.1.1
grouping operations into, 6.2.1
improving performance of, 6.2.2
in-flight, 6.2.4
main, 6.7, 6.7
read-only, 6.3
redo entry for, 6.2.3
serializable
See serializable transaction
that invokes remote subprogram, 11.8.4.2
Transaction Guard, 6.2.4, 25
transaction history table, 25.4.2
transaction interaction
kinds of, 6.6.1
serializable transaction and, 6.6.1
transaction isolation level and, 6.6.1
transaction isolation level
choosing, 6.6.4.2
setting, 6.6.2
transaction interaction and, 6.6.1
transaction manager (TM), 19.1.1
transaction processing monitor (TPM), 19.1.1
transaction set consistency, 6.6.4.1
transaction-level read consistency, 6.3
locking tables explicitly for, 6.4
read-only transaction for, 6.3
transform, 24.3.1
applying, 24.3.5
trigger, 11.1
AFTER SUSPEND, 6.8.2.1
as autonomous transaction, 6.8.2.1
automating database login with, 3.2
compared to constraint, 10.1
crossedition
See crossedition trigger
enforcing referential integrity with, 6.6.3
in edition
firing order of, 24.3.3.3
visibility of, 24.3.3.1
what kind can fire, 24.3.3.2
invoking subprogram from, 11.8.3
size limit for, 11.4.3
TRUST assertion (deprecated), 11.9.4.3.1
TRUST keyword in RESTRICT_REFERENCES pragma, 11.9.4.3.1
two-phase commit protocol, 19.1.1
two-tier architecture, 17.1.3
TX interface, 19.1.1

U

undetected deadlock, 6.5
undo data, 16.1
UNDO_RETENTION parameter, 6.3
Unicode
data types for, 7.2
regular expressions and, 8.3
unified auditing, 3.6
UNIQUE constraint
crossedition trigger and, 24.3.4.1.1
dropping, 10.17
naming, 10.13.2
on FOREIGN KEY constraint, 10.8.2, 10.8.2
when to use, 10.7
unrepeatable read, 6.6.1
unusable edition
dropping edition and, 24.1.8
for materialized view, 24.1.1.2.1
retiring edition and, 24.1.7
upgrading applications online
See edition-based redefinition (EBR)
UROWID data type, 7.6
user access
See security
user interface, 17.2.1
stateful and stateless, 17.2.2
user lock, 6.5
user-defined subtype, 11.4.4.1.5
UTLLOCKT.SQL script, 6.5.2

V

VARCHAR data type, 7.2
VARCHAR data type class, 23.10.2.4
VARCHAR2 data type, 7.2
variable
cursor
See cursor variable
in C external subprogram
global, 18.13.6
static, 18.13.7
VERSIONS_ENDSCN pseudocolumn, 16.4
VERSIONS_ENDTIME pseudocolumn, 16.4
VERSIONS_OPERATION pseudocolumn, 16.4
VERSIONS_STARTSCN pseudocolumn, 16.4
VERSIONS_STARTTIME pseudocolumn, 16.4
VERSIONS_XID pseudocolumn, 16.4
view
constraint on, 10
editioned, FOREIGN KEY constraint and, 24.1.1.6
editioning
See editioning view
materialized, 1.9.2
that depends on editioned object, 24.1.1.2.1
virtual column, 24.1.1.2.2
VPD policy, editioning view and, 24.5.1

W

WAIT commit redo option, 6.2.3
WAIT option of LOCK TABLE statement, 6.4.2
web application, 14.1
implementing, 14.2
state and, 14.6.8
web services, 17.4.7
web toolkit
See PL/SQL Web Toolkit
white list
See ACCESSIBLE BY clause
wrap utility, debugging and, 11.10.3
writability of editioning view, 24.2.3
write-after-write dependency, 16.8.1

X

xa_open string, 19.3.3
XMLType data type, 7.5.5
X/Open Distributed Transaction Processing (DTP) architecture, 19.1

Y

YY datetime format element, 7.4.2