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

B28424-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
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  Z 

Symbols

%ROWTYPE attribute, 7.1.2.2.3
%TYPE attribute, 7.1.2.2.3

Numerics

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

A

Active Server Pages (ASP), 11.4
addresses of rows, 3.7
Advanced Queuing (AQ)
publish-subscribe model and, 16.2.2
advantages of PL/SQL, 1.2.2
agent
definition of
in publish-subscribe model, 16.3
aggregate functions, 7.11
agtctl, A.2, A.3
commands, A.3.1
shell mode commands, A.3.3
single-line command mode, A.3.2
altering constraints, 6.9
altering subprograms, 7.1.2.4
anonymous blocks, 7.1.1
AnyData data type, 3.5.6
AnyDataSet data type, 3.5.6
AnyType data type, 3.5.6
AP (application program), 15.1.1
application program (AP), 15.1.1
AQ (Oracle Advanced Queuing)
publish-subscribe model and, 16.2.2
archives, 13.10
ARGn data type, 3.9
arithmetic operations
with date and time data types, 3.4.5
with native floating-point data types, 3.3.4
ASP (Active Server Pages), 11.4
assignments
data type conversion during, 3.8.1
reported by PL/Scope, 8.6
attributes
Java STATIC class, 7.9.4.3
type, 7.1.2.2.3
Automatic Undo Management system, 13.1
autonomous routines, 2.9
autonomous transactions, 2.9
AUTONOMOUS_TRANSACTION pragma, 2.9

B

backward compatibility
LONG and LONG RAW data types for, 3.2.1
RESTRICT_REFERENCES pragma for, 7.9.4.4
base-10 numbers, 3.3.2
base-2 numbers, 3.3.2, 3.3.2.1
BATCH option for redo information, 2.3.4
BFILE data type, 3.5.3
binary large objects, 3.5.3
binary numbers, 3.3.2, 3.3.2.1
binary ROWID data type, 3.7.2.3
BINARY_DOUBLE data type, 3.3.1, 3.3.6.2
BINARY_FLOAT data type, 3.3.1, 3.3.6.2
binding
bulk
overview of, 7.1.2.14
when to use, 7.1.2.15
BLOB data type, 3.5.3
blocks
anonymous, 7.1.1
bodies of packages, 7.1.2.8
branches, 15.1.1
built-in functions
display types of, 3.9
in regular expressions, 4.1.3
metadata for, 3.9
bulk binding
overview of, 7.1.2.14
when to use, 7.1.2.15

C

C external subprograms
global variables in, 14.13.6
interface between PL/SQL and, 14.5.2
invoking, 14.10.4
loading, 14.4.2
passing parameters to, 14.9
service routines and, 14.12
call specifications
for external subprograms, 14.3
locations of, 14.8
CALL statement, 14.10
callback procedures
C, 14.13
calling subprograms
from subprograms, 7.7.3
See invoking subprograms
through embedded PL/SQL gateway, 10.4.4
canceling cursors, 2.5.4
century in date format, 3.4.3
changing
See altering
CHAR data type
columns
specifying length of, 3.2.2
compared to VARCHAR2 datat ype, 3.2.3
character data types, 3.2
character large objects, 3.5.3
character literals
in SQL statements, 3.2.4
character sets
PL/SQL Server Pages and, 11.5.1.2.3
CHECK constraints
compared to NOT NULL constraints, 6.6.4
designing, 6.6.2
multiple, 6.6.3
naming, 6.7.2
restrictions on, 6.6.1
when to use, 6.6
child tables, 6.2.2
class attributes
Java STATIC, 7.9.4.3
client in publish-subscribe model
definition of, 16.3
notifying, 16.2.3
client/server model, 1.1.1
CLOB data type, 3.5.3
clusters
creating indexes for, 5.2.1
collections, 1.2.2.6.2
DML statements that reference, 7.1.2.15.1
FOR loops that reference, 7.1.2.15.3
SELECT statements that reference, 7.1.2.15.2
columns
default values for
setting, 6.1.6
when to use, 6.1.5
multiple foreign key constraints on, 6.2.3
specifying length of, 3.2.2
comments in PL/SQL Server Pages, 11.5.9
COMMIT statement, 2.3.3, 2.3.6
COMMIT_WRITE initialization parameter, 2.3.4
comparison operators for native floating-point data types, 3.3.3
compile-time errors, 7.4
composite FOREIGN KEY constraints, 6.2
matching rules for, 6.2.1
composite indexes
column order in, 5.2.5
concurrency, 2.8
conditional expressions
representing as data, 3.6
conditions in regular expressions, 4.1.3
configuring database for Oracle Flashback Technology, 13.2
connection pools, 1.4.2
consistent reads, 2.4, 2.6
constraints, 6
altering, 6.9
CHECK
See CHECK constraints
deferring checking of, 6.2.4
defining
privileges needed for, 6.7.1
disabled
definition of, 6.8
disabling
existing, 6.8.5
new, 6.8.3
reasons for, 6.8.1
dropping, 6.10
enabled
definition of, 6.8
enforcing business rules with, 6.1.1
exceptions to, 6.8.7
existing
disabling, 6.8.5
enabling, 6.8.4
FOREIGN KEY
See FOREIGN KEY constraints
minimizing overhead of, 6.3
naming, 6.7.2, 6.7.2
new
disabling, 6.8.3
enabling, 6.8.2
NOT NULL
See NOT NULL constraints
on views, 6.1.9
PRIMARY KEY
See PRIMARY KEY constraints
renaming, 6.9.1
UNIQUE
See UNIQUE constraints
viewing definitions of, 6.12
violating, 6.8.7
Continuous Query Notification (CQN), 12
controlling side effects of functions, 7.9.4
conversion of data types
See data type conversion
converting data types
See data type conversion
coupling, 15.1.1
CQ_NOTIFICATION$_DESCRIPTOR objects, 12.8.1, 12.8.2, 12.8.3
CQ_NOTIFICATION$_REG_INFO objects, 12.6.6.2
CQ_NOTIFICATION$_ROW objects, 12.8.4
CQN (Continuous Query Notification), 12
creating indexes
examples of, 5.3
for clusters, 5.2.1
for tables, 5.2.1
privileges needed for, 5.1
temporary table space for, 5.2.2
with SQL*Loader, 5.2.2
creating packages, 7.1.2.10
creating subprograms, 7.1.2.3
cross-session PL/SQL function result cache, 7.1.2.7
current date and time
displaying, 3.4.2
cursor variables, 7.3
declaring, 7.3.1
examples of, 7.3.2
opening, 7.3.1
cursors, 2.5
canceling, 2.5.4
closing, 2.5.3
maximum number for session, 2.5.1
pointers to, 7.3
scrollable, 1.4.2
with Oracle XA applications, 15.3.4
See also cursor variables

D

data definition language
processing statements, 2.2.1
data integrity
See constraints
data manipulation language
processing statements, 2.1
data type conversion, 3.8
ANSI data types, 3.5.7
ANSI/ISO data types, 3.5.7
date and time data types, 3.4.6
DB2 data types, 3.5.7, 3.5.7
during assignments, 3.8.1
during expression evaluation, 3.8.2
LONG RAW data type, 3.5.3
native floating-point data types, 3.3.5
RAW data type, 3.5.3
SQL/DS data types, 3.5.7
data types, 3
ANSI/ISO, 3.5.7
character, 3.2
conversion of
See data type conversion
converting
See data type conversion
date and time, 3.4
DB2, 3.5.7
families of, 3.9
floating-point, 3.3.1, 3.3.2
native floating point, 3.3.1
representing special values, 3.3.2.2
rounding, 3.3.2, 3.3.4
numeric, 3.3
of formal subprogram parameters, 7.1.2.2.2
overview of, 3.1
rowid, 3.7
SQL/DS, 3.5.7
data ype conversion
SQL/DS data types, 3.5.7
database event publication framework
definition of
in publish-subscribe model, 16.3
database events
publish-subscribe model and, 16.2.1
database links
Oracle XA and, 15.5.1
date
changing default format of, 3.4.3
date and time
displaying current, 3.4.2
date and time data types, 3.4
arithmetic operations with, 3.4.5
converting, 3.4.6
DATE data type, 3.4.1
DBMS_DEBUG package, 7.6.8
DBMS_DEBUG_JDWP package, 7.6.7
DBMS_FLASHBACK package, 13.8
DBMS_FLASHBACK.TRANSACTION_BACKOUT procedure, 13.9
DBMS_HPROF.START_PROFILING procedure, 9.2
DBMS_HPROF.STOP_PROFILING procedure, 9.2
DBMS_LOCK package, 2.7
DBMS_OUTPUT package
using to debug subprograms, 7.6.4
DBMS_STATS package and Oracle Flashback Query, 13.12
DBMS_TYPES package, 3.5.6
DBMS_XA package, 15.3.10
deadlocks
undetected, 2.7
debugging
subprograms, 7.6
debugging external subprograms, 14.13.4
debugging PL/SQL Server Pages, 11.10
decimal numbers, 3.3.2
default column values
setting, 6.1.6
when to use, 6.1.5
default values
of subprogram parameters, 7.1.2.2.5
deferring constraint checks, 6.2.4
definer's-rights subprograms, 7.7.1
denormal floating-point numbers, 3.3.2.1
DESC keyword, 5.5.1
DETERMINISTIC functions, 7.9.4.2
indexes and, 5.5.2
disabled constraints, 6.8
disabling constraints
existing, 6.8.5
new, 6.8.3
reasons for, 6.8.1
dispatcher threads
multithreaded Heterogeneous Services agents, A.2
Display types of built-In functions, 3.9
distributed databases
FOREIGN KEY constraints and, 6.5
distributed processing environment
data manipulation statements, 2.1
distributed queries
run-time errors in, 7.5.3
distributed transaction, 15.1.1
distributed updates, 7.8.2
DML statements
bulk binding for, 7.1.2.15.1
parallel, 7.9.4.3
that reference collections, 7.1.2.15.1
DML_LOCKS initialization parameter, 2.6
domain indexes, 5.4
DOUBLE data type, 3.3.6.3
DROP INDEX statement, 5.2.7
dropping constraints, 6.10
dropping indexes, 5.2.7
dropping packages, 7.1.2.5
dropping subprograms, 7.1.2.5
DTP
See X/Open Distributed Transaction Architecture
dynamic registration, 15.1.1
dynamic SQL statements
RNDS option and, 7.9.4.4.2
dynamically typed data
representing, 3.5.6

E

Electronic Product Code (EPC), 17.7.2.1
embedded PL/SQL gateway, 10.2.1.2, 10.4
enabled constraints
definition of, 6.8
enabling constraints
existing, 6.8.4
new, 6.8.2
encoding schemes
adding, 17.3.4
enforcing business rules
with application logic, 6.1.2
with constraints, 6.1.1
environments
programmatic, 1
EPC (Electronic Product Code), 17.7.2.1
errors
compile-time
See compile-time errors, 7.4
in multilanguage programs, 14.11
run-time
See run-time errors
script, 11.5.1.3
events
database
See database events
exceptions
IEEE 754
not raised, 3.3.2.2
raised during conversion, 3.3.5
in multilanguage programs, 14.11
to constraints, 6.8.7
unhandled, 7.5.2
user-defined
See user-defined exceptions
exclusive locks
LOCK TABLE statement, 2.6.2.4
EXCLUSIVE MODE option of LOCK TABLE statement, 2.6.2.4
executing external subprograms, 14.10
execution
native
See native execution
resuming
after storage allocation error, 2.10
exporting date and time data types, 3.4.7
EXPR data type, 3.9
expressions
conditional
representing as data, 3.6
evaluation of
data type conversion during, 3.8.2
indexes built on
See function-based indexes
PL/SQL Server Pages and, 11.5.7
regular
See regular expressions
extended ROWID data type, 3.7.2.2
external binary ROWID data type, 3.7.2.3
external large objects, 3.5.3
external subprograms, 14
call specifications for, 14.3
debugging, 14.13.4
definition of, 14.2
executing, 14.10
loading, 14.4
publishing, 14.5
external transaction manager, 15.1.1
extproc agent, A

F

families of data types, 3.9
features new, Preface
features, new, Preface
FIXED_DATE initialization parameter, 3.4.2
Flashback Data Archive, 13.10
Flashback Transaction, 13.9
FLASHBACK_TRANSACTION_QUERY view, 13.5
FLOAT data type, 3.3.6.3
floating-point data types, 3.3.1, 3.3.2
FOR loops
bulk binding for, 7.1.2.15.3
that reference collections, 7.1.2.15.3
FOR UPDATE clause of SELECT statement
See SELECT FOR UPDATE statement
FOREIGN KEY constraints, 6.11
composite, 6.2
matching rules for, 6.2.1
distributed databases and, 6.5
dropping, 6.10
indexing, 6.4
multiple, 6.2.3
naming, 6.7.2
NOT NULL constraints on, 6.2.2, 6.2.2
NULL values and, 6.2.1
privileges needed to create, 6.11.4
types of referential integrity enforced by, 6.11.5
UNIQUE constraints on, 6.2.2, 6.2.2
without other constraints, 6.2.2
foreign keys
See FOREIGN KEY constraints
foreign rowids, 3.7.3
formal subprogram parameters
data types of, 7.1.2.2.2
function result cache, 7.1.2.7
function-based indexes, 5.5
examples of, 5.5.3
functions
aggregate, 7.11
built-in
metadata for, 3.9
See built-in functions
controlling side effects of, 7.9.4
DETERMINISTIC, 7.9.4.2
invoking from SQL statements, 7.9
OCI and OCCI, 1.6.2
overloading packaged, 7.9.4.4.3
PARALLEL_ENABLE, 7.9.4.2
purity of, 7.9.4
result-cached, 7.1.2.7
returning large amounts of data from, 7.10
SQL
See built-in functions
See also subprograms

G

gateway
PL/SQL, 10.2.1
embedded, 10.2.1.2, 10.4
Geographic Information System (GIS) data, 3.5.1
GIS data, 3.5.1
global transaction, 15.1.1
global variables
in C external subprograms, 14.13.6

H

hierarchical profiler, 9
HTML, 11.3

I

IA-32 and IA-64 instruction set architecture, 3.3.4
identifiers
collecting data about, 8
Identity Code Package, 17
identity codes
defining, 17.3.4
IEEE 754
exceptions
not raised, 3.3.2.2
raised during conversion, 3.3.5
OCI support for, 3.3.6.1
representing special values, 3.3.2.2
IEEE 754 format, 3.3.1
IMMEDIATE option for redo information, 2.3.4
importing date and time data types, 3.4.7
IN OUT subprogram parameter mode, 7.1.2.2.1
IN subprogram parameter mode, 7.1.2.2.1
indexes, 5
application-specific, 5.2
composite
column order in, 5.2.5
creating
examples of, 5.3
for clusters, 5.2.1
for tables, 5.2.1
privileges needed for, 5.1
temporary table space for, 5.2.2
with SQL*Loader, 5.2.2
domain, 5.4
dropping, 5.2.7
function-based, 5.5
examples of, 5.5.3
overhead for, 5.2.4
statistics for, 5.2.6
where to put, 5.2.3
indexing
MGD_ID columns, 17.3.2
indexing foreign keys, 6.4
infinity, 3.3.2.2
initialization parameters
DML_LOCKS, 2.6
FIXED_DATE, 3.4.2
OPEN_CURSORS, 2.5.1
integration of PL/SQL with Oracle Database, 1.2.2.1
integrity of data
See constraints
interfaces
user, 1.1.4
stateful and stateless, 1.1.5
INTERVAL DAY TO SECOND data type, 3.4.1
INTERVAL YEAR TO MONTH data type, 3.4.1
invoker's-rights subprograms, 7.7.1
invoking subprograms, 7.7
from 3GL applications, 7.7.4
from triggers, 7.7.3
interactively from Oracle Database tools, 7.7.2
isolation level of serializable transaction, 2.8.2

J

Java
compared to PL/SQL, 1.10.2
Java class methods
calling, 14.10.3
interface between PL/SQL and, 14.5.1
loading, 14.4.1
publishing, 14.6
Java Database Connectivity (JDBC), 1.3.2
Java Server Pages (JSP), 11.4
Java STATIC class attributes, 7.9.4.3
Java support, 1.3
Java Virtual Machine (JVM), 1.3.1
JavaScript, 11.4, 11.9.5
JDBC
compared to SQLJ, 1.3.3.2
stored subprograms and triggers, 1.3.7.2
JDBC (Java Database Connectivity), 1.3.2
JDBC 2.0 sample program, 1.3.2.5
JDBC in SQLJ applications, 1.3.2.7
JDBC OCI driver, 1.3.2.2
JDBC pre-2.0 sample program, 1.3.2.6
JDBC server-side internal driver, 1.3.2.3
JDBC standards
Oracle Database extensions to, 1.3.2.4
JDBC thin driver, 1.3.2.1
JPublisher
overview of, 1.3.4
JVM (Java Virtual Machine), 1.3.1

K

KEEP INDEX clause, 6.3
keys
foreign, 6.11
See FOREIGN KEY constraints
primary
See PRIMARY KEY constraints
referential integrity
See FOREIGN KEY constraints
unique
See UNIQUE constraints

L

large objects, 3.5.3
LGWR (log writer process), 2.3.4
lightweight queue
definition of
in publish-subscribe model, 16.3
literals
character
in SQL statements, 3.2.4
loading external subprograms, 14.4
C, 14.4.2
Java class methods, 14.4.1
loading PL/SQL Server Pages, 11.6
loadpsp utility, 11.6
LOB data types, 3.5.3, 3.5.3
OO40 support for, 1.9.3
LOCK TABLE statement, 2.6.2
locking rows explicitly, 2.6.4
locking tables
explicitly, 2.6
implicitly, 2.6.3
log writer process (LGWR), 2.3.4
logical rowids, 3.7.3
LONG RAW data type, 3.5.3
converting, 3.5.3
loops
FOR
See FOR loops
loose coupling, 15.1.1
LOWER function, 5.5.1

M

main transaction, 2.9
manageability, 1.2.2.5
matching rules
for composite FOREIGN KEY constraints, 6.2.1
metacharacters
in regular expressions, 4.2
POSIX, 4.2.1
metadata for built-in functions, 3.9
MGD_ID database object type, 17.1, 17.2
MGD_ID database object type functions, 17.3.3
mod_plsql module, 10.2.1.1
MODIFY CONSTRAINT clause, 6.9
modifying
See altering
monitor thread
multithreaded Heterogeneous Services agents, A.2
multilanguage programs, 14.1
errors and exceptions in, 14.11
multilingual extensions to POSIX standard, 4.2.2
multimedia data, 3.5.2
multithreaded extproc agent, A
multithreaded Heterogeneous Services agents
dispatcher threads, A.2
monitor thread, A.2
task threads, A.2

N

naming packages, 7.1.2.11
naming subprograms, 7.1.2.1
NaN (not a number), 3.3.2.2
national character large objects, 3.5.3
native execution
compiling subprograms for, 7.2
native floating-point data types, 3.3.1
arithmetic operations with, 3.3.4
converting, 3.3.5
representing special values, 3.3.2.2
rounding, 3.3.2, 3.3.4
NCLOB data type, 3.5.3
negative infinity, 3.3.2.2
negative zero, 3.3.2.2
new features, Preface, Preface
NLSSORT function, 5.5.1
NO WAIT option of LOCK TABLE statement, 2.6.2
nonpersistent queue
definition of
in publish-subscribe model, 16.3
normalized floating-point numbers, 3.3.2.1
NOT NULL constraint
when to use, 6.1.4
NOT NULL constraints
compared to CHECK constraints, 6.6.4
naming, 6.7.2
on FOREIGN KEY constraints, 6.2.2, 6.2.2
notifications
client
publish-subscribe model and, 16.2.3
NOWAIT option of COMMIT statement and COMMIT_WRITE initialization parameter, 2.3.4
NULL values
FOREIGN KEY constraints and, 6.2.1
NUMBER data type, 3.3.1
numbers
binary (base 2), 3.3.2, 3.3.2.1
decimal (base 10), 3.3.2
rounding, 3.3.2
numeric data types, 3.3

O

object change notification, 12.1
object types, 1.2.2.6.1
object-oriented programming support, 1.2.2.6
objects
CQ_NOTIFICATION$_DESCRIPTOR, 12.8.1
CQ_NOTIFICATION$_REG_INFO, 12.6.6.2
CQ_NOTIFICATION$_ROW, 12.8.4
large, 3.5.3
size limits for PL/SQL stored, 7.1.2.9
OCCI
application building, 1.6.4
kinds of functions in, 1.6.2
overview of, 1.6
procedural and nonprocedural elements of, 1.6.3
OCI
application building, 1.6.4
closing cursors, 2.5.3
compared to precompilers, 1.10.1
kinds of functions in, 1.6.2
native floating-point data types in, 3.3.6.1
overview of, 1.6
procedural and nonprocedural elements of, 1.6.3
with Oracle XA, 15.3.5
OCITransCommit function, 2.3.4
ODC (Oracle Data Control), 1.9.4
ODP.NET
overview of, 1.7
OO4O
automation server, 1.9.1
object data type and LOB support, 1.9.3
object model, 1.9.2
overview of, 1.9
OO4O C++ Class Library, 1.9.5
OPEN_CURSORS initialization parameter, 2.5.1
operators
comparison
for native floating-point data types, 3.3.3
relational
See comparison operators
optimizer
function-based indexes and, 5.5.1
ORA_ROWSCN pseudocolumn, 13.7, 13.7, 13.7.1, 13.7.1, 13.7.1, 13.7.1, 13.7.1, 13.7.1
OraAQ object, 1.9.2.10
OraAQAgent object, 1.9.2.12
OraAQMsg object, 1.9.2.11
OraBFILE objects, 1.9.3.2
OraBLOB objects, 1.9.3.1
Oracle Advanced Queuing (AQ)
publish-subscribe model and, 16.2.2
Oracle C++ Call Interface
See OCCI
Oracle Call Interface
See OCI
Oracle Data Control (ODC), 1.9.4
Oracle Data Provider for .NET
overview of, 1.7
Oracle Database
integration of PL/SQL with, 1.2.2.1
Oracle Database packages, 7.1.2.13
for writing low-level debugging code, 7.6.6
run-time errors raised by, 7.5
Oracle Expression Filter, 3.6
Oracle Flashback Query, 13.3
DBMS_STATS package, 13.12
Oracle Flashback Technology, 13
application development features, 13.1.1
configuring database for, 13.2
database administration features, 13.1.2
overview of, 13.1
performance guidelines for, 13.12
Oracle Flashback Transaction Query, 13.5
Oracle Flashback Version Query, 13.4
Oracle JDBC, 1.3.2
compared to Oracle SQLJ, 1.3.3.2
stored subprograms and triggers, 1.3.7.2
Oracle JDBC in SQLJ applications, 1.3.2.7
Oracle JDBC OCI driver, 1.3.2.2
Oracle JDBC server-side internal driver, 1.3.2.3
Oracle JDBC thin driver, 1.3.2.1
Oracle JDeveloper, 7.6.3
definition of, 1.3.3.1
Oracle JPublisher
overview of, 1.3.4
Oracle JVM, 1.3.1
Oracle Lock Management services, 2.7
Oracle Multimedia, 3.5.2
Oracle OBJECT
native floating-point data types in, 3.3.6.2
Oracle Objects for OLE
See OO4O
Oracle programmatic environments, 1
Oracle RAC
Oracle XA and, 15.5.3
Oracle SQLJ
benefits of, 1.3.3.1
compared to Oracle JDBC, 1.3.3.2
overview of, 1.3.3
server subprograms, 1.3.3.3
Oracle Text, 3.5.4
Oracle Total Recall, 13.10
Oracle XA, 15
Oracle XA library, 15.2
OraCLOB objects, 1.9.3.1
OraDatabase object, 1.9.2.3
OraDynaset object, 1.9.2.4
OraField object, 1.9.2.5
OraMDAttribute object, 1.9.2.6
OraMetaData object, 1.9.2.6
OraParamArray object, 1.9.2.8
OraParameter object, 1.9.2.7
OraParameters collection, 1.9.2.7
OraServer object, 1.9.2.2
OraSession object, 1.9.2.1
OraSQLStmt object, 1.9.2.9
OUT subprogram parameter mode, 7.1.2.2.1
overloading packaged functions, 7.9.4.4.3
overloading subprogram names, 7.1.2.8

P

package
definition of, 7.1.2.8
package subprogram
definition of, 7.1.2
packages, 1.2.2.9, 7, 7.1.2.8
advantages of, 7.1.2.8
bodies of, 7.1.2.8
creating, 7.1.2.10
dropping, 7.1.2.5
invalidation of, 7.1.2.12
naming, 7.1.2.11
Oracle Database
See See Oracle Database packages
privileges needed to create, 7.1.2.10.2
privileges needed to drop, 7.1.2.10.2
serially reusable, 7.9.5
session state and, 7.1.2.12
size limits for, 7.1.2.9
specifications of, 7.1.2.8
states of, 7.9.5.1
synonyms for, 7.8.1
parallel DML statements, 7.9.4.3
parallel queries, 7.9.4.3
PARALLEL_ENABLE functions, 7.9.4.2
parameter modes, 7.1.2.2.1
parameters
initialization
See initialization parameters
subprogram
See subprogram parameters
parent and child tables, 6.11.4, 6.11.5
parent tables, 6.2.2
performance, 1.2.2.2
PERL-influenced extensions to POSIX standard, 4.2.3
persistent and temporary LOB instances, 3.5.3
persistent queue
definition of
in publish-subscribe model, 16.3
PL/Scope tool, 7.6.1, 8
plshprof utility, 9.5
PL/SQL
canceling cursors with, 2.5.4
PL/SQL function result cache, 7.1.2.7
PL/SQL gateway, 10.2.1
embedded, 10.2.1.2, 10.4
PL/SQL hierarchical profiler, 7.6.2, 9
PL/SQL Server Pages
characteristics of, 11.5.1
developing, 11
elements of, 11.5
PL/SQL Web Toolkit, 10.2.2
pools
connection, 1.4.2
portability, 1.2.2.7
positive infinity, 3.3.2.2
positive zero, 3.3.2.2
POSIX standard
extensions to
multilingual, 4.2.2
PERL-influenced, 4.2.3
in regular expressions, 4.1.4
metacharacters, 4.2.1
posting
definition of
in publish-subscribe model, 16.3
pragmas
AUTONOMOUS_TRANSACTION, 2.9
RESTRICT_REFERENCES, 7.9.4.4
overloaded package functions and, 7.9.4.4.3
SERIALLY_REUSABLE, 7.9.5, 7.9.5.3
precompilers
compared to OCI, 1.10.1
with Oracle XA applications, 15.3.4
PRIMARY KEY constraints, 6.1.7
dropping, 6.10
naming, 6.7.2
primary keys
See PRIMARY KEY constraints
privileges
for creating FOREIGN KEY constraints, 6.11.4
for creating indexes, 5.1
for creating packages, 7.1.2.3, 7.1.2.10.2
for creating subprograms, 7.1.2.3
for debugging subprograms, 7.6.5
for defining constraints, 6.7.1
for dropping packages, 7.1.2.5, 7.1.2.10.2
for dropping subprograms, 7.1.2.5
for executing subprograms, 7.7.1
Pro*C/C++
canceling cursors with, 2.5.4
native floating-point data types in, 3.3.6.3
overview of, 1.4
processing SQL statements, 2.1
Pro*COBOL
overview of, 1.5.1
procedures
callback
C, 14.13
PL/SQL Server Pages and, 11.5.3
See also subprograms
processing
DDL statements, 2.2.1
DML statements, 2.1
product codes, 17.7.2
productivity, 1.2.2.3
profiler
hierarchical, 9
program units
overview of, 7.1
stored, 7.1.2
programmatic environments, 1
PSP
See PL/SQL Server Pages
public information
required, 15.1.2
publishing a message
definition of
in publish-subscribe model, 16.3
publishing C external subprograms, 14.7
publishing external subprograms, 14.5
C, 14.7
Java, 14.6
publish-subscribe model, 16
purity of functions, 7.9.4

Q

quality-of-service flags, 12.6.6.2
queries
distributed
run-time errors in, 7.5.3
parallel, 7.9.4.3
registering for Continuous Query Notification, 12.6
speeding up with indexes, 5.2
query result change notification, 12.2
queue
definition of
in publish-subscribe model, 16.3

R

Radio Frequency Identification (RFID) technology, 17.7.1
RAISE statement, 7.5.1
RAISE_APPLICATION_ERROR procedure, 7.5, 7.5.1
RAW data type, 3.5.3
converting, 3.5.3
read-only transactions, 2.4, 2.6
receiving a message
definition of
in publish-subscribe model, 16.3
redo information, 2.3.4
redo information for transactions, 2.3.4
referential integrity keys
See FOREIGN KEY constraints
REGEXP_COUNT function
description, 4.1.3
REGEXP_INSTR function
description, 4.1.3
REGEXP_LIKE condition
description, 4.1.3
REGEXP_REPLACE function
description, 4.1.3
REGEXP_SUBSTR function
description, 4.1.3
registering queries for Continuous Query Notification, 12.6
registration
definition of
in publish-subscribe model, 16.3
dynamic, 15.1.1
static, 15.1.1
regular expressions, 4
built-in functions in, 4.1.3
conditions in, 4.1.3
in SQL statements, 4.3
metacharacters in, 4.2
Oracle implementation of, 4.1.3
overview of, 4.1.1
POSIX standard support in, 4.1.4
relational operators
See comparison operators
remote subprograms
run-time errors in, 7.5.4
renaming constraints, 6.9.1
repeatable reads, 2.4, 2.6
required public information, 15.1.2
resource manager (RM), 15.1.1
RESTRICT_REFERENCES pragma, 7.9.4.4
overloaded package functions and, 7.9.4.4.3
restricted ROWID data type, 3.7.2.1
result cache, 7.1.2.7
resumable storage allocation, 2.10
resuming execution
after storage allocation error, 2.10
RETENTION GUARANTEE clause for undo tablespace, 13.2.1
RETENTION option of ALTER TABLE statement, 13.2.4
retention period, 2.4
reusable packages, 7.9.5
RFID (Radio Frequency Identification) technology, 17.7.1
RM (resource manager), 15.1.1
RNDS option of RESTRICT_REFERENCES pragma, 7.9.4.4
static and dynamic SQL statements and, 7.9.4.4.2
RNPS option of RESTRICT_REFERENCES pragma, 7.9.4.4
ROLLBACK statement, 2.3.5, 2.3.6
rolling back transactions, 2.3.5
rounding numbers, 3.3.2
routines
See subprograms
ROW EXCLUSIVE MODE option of LOCK TABLE statement, 2.6.2.1
ROW EXCLUSIVE MODE table lock, 2.6.2
ROW SHARE EXCLUSIVE MODE option of LOCK TABLE statement, 2.6.2.3
ROW SHARE MODE option of LOCK TABLE statement, 2.6.2.1
ROW SHARE MODE table lock, 2.6.2
ROWID data type
accessing, 3.7.2
ROWID pseudocolumn
querying, 3.7.1
rowids
data types of, 3.7
foreign, 3.7.3
logical, 3.7.3
universal, 3.7.3
rows
identifying by address, 3.7
locking explicitly, 2.6.4
ROWTYPE_MISMATCH exception, 7.3.2
rule on a queue
definition of
in publish-subscribe model, 16.3
rules engine
definition of
in publish-subscribe model, 16.3
run-time errors, 7.5
in distributed queries, 7.5.3
in remote subprograms, 7.5.4
raised by Oracle Database packages, 7.5
user-defined
See user-defined exceptions

S

SAVEPOINT statement, 2.3.6, 2.3.6, 2.3.6
savepoints, 2.3.6
scalability, 1.2.2.4
scope
autonomous, 2.9
script errors, 11.5.1.3
scrollable cursors, 1.4.2
searchable text, 3.5.4
security, 1.2.2.8
SELECT FOR UPDATE statement, 2.6.4
SELECT statement
VERSIONS BETWEEN...AND clause, 13.4
with AS OF clause, 13.3
SELECT statements
bulk binding for, 7.1.2.15.2
that reference collections, 7.1.2.15.2
serializable transactions, 2.8
isolation level of, 2.8.2
serially reusable packages, 7.9.5
SERIALLY_REUSABLE pragma, 7.9.5, 7.9.5.3
server-side coding, 1.1.2
service routines
C external subprograms and, 14.12
session variables, 7.7.2
sessions
packages and, 7.1.2.12
SET CONSTRAINTS statement, 6.2.4
SET TRANSACTION statement, 2.4, 2.4
SHARE MODE option of LOCK TABLE statement, 2.6.2.2
share row exclusive locks (SRX)
LOCK TABLE statement, 2.6.2.3
shared SQL areas, 2.1
overview of, 2.1
side effects of functions
controlling, 7.9.4
size limits
for PL/SQL stored database objects, 7.1.2.9
SKIP LOCKED clause of SELECT FOR UPDATE statement, 2.6.4
sorting
with function-based indexes, 5.5.1
spatial data, 3.5.1
specifications of packages, 7.1.2.8
SQL
shared SQL, 2.1
SQL areas
shared, 2.1
SQL data types
See data types
SQL functions
See built-in functions
SQL statements
dynamic
See dynamic SQL statements
invoking PL/SQL functions from, 7.9
static
RNDS option and, 7.9.4.4.2
transactions, 2.2.2
SQL*Loader
creating indexes with, 5.2.2
SQLJ
benefits of, 1.3.3.1
compared to JDBC, 1.3.3.2
overview of, 1.3.3
server subprograms, 1.3.3.3
SQLJ applications
Oracle JDBC in, 1.3.2.7
SQLT_BDOUBLE data type, 3.3.6.1
SQLT_BFLOAT data type, 3.3.6.1
SRX locks
LOCK Table statement, 2.6.2.3
standalone subprogram
definition of, 7.1.2
state
web applications and, 10.6.8
stateful and stateless user interfaces, 1.1.5
statements
SQL
See SQL statements
states
of packages, 7.9.5.1
static registration registration, 15.1.1
static variables
in C external subprograms, 14.13.7
statics
for indexes, 5.2.6
storage allocation
suspended
handling, 2.10.2
storage allocation errors
resuming execution after, 2.10
stored program units, 7.1.2
See subprograms and packages
stored subprograms
See subprograms
strings
PL/SQL Server Pages and, 11.5.8
subnormal floating-point numbers, 3.3.2.1
subprogram parameters, 7.1.2.2
data types of formal, 7.1.2.2.2
default values of, 7.1.2.2.5
modes of, 7.1.2.2.1
user-defined types as, 7.1.2.2.4
subprograms, 7
altering, 7.1.2.4
calling
through embedded PL/SQL gateway, 10.4.4
compiling for native execution, 7.2
creating, 7.1.2.3
debugging, 7.6
definer's-rights, 7.7.1
dropping, 7.1.2.5
exception-handling, 7.5.1
external
See external subprograms
invoker's-rights, 7.7.1
invoking
See invoking subprograms
names of, 7.1.2.1
overloading, 7.1.2.8
Oracle XA, 15.2
package, 7.1.2
parameters of
See subprogram parameters
privileged needed to execute, 7.7.1
privileges needed to debug, 7.6.5
remote
See remote subprograms
size limits for, 7.1.2.9
standalone, 7.1.2
stored
using Java for, 1.3.7.2
synonyms for, 7.8.1
See also functions and procedures
subscriber
definition of
in publish-subscribe model, 16.3
subscription services
definition of
in publish-subscribe model, 16.3
suspended storage allocation
handling, 2.10.2
synonyms
for packages, 7.8.1
for subprograms, 7.8.1
SYSDATE function, 3.4.2

T

tables
child, 6.11.4, 6.11.5
columns of
See columns
locking, 2.6.2
parent, 6.11.4, 6.11.5
parent and child, 6.2.2
rows of
See rows
task threads
multithreaded Heterogeneous Services agents, A.2
temporary and persistent LOB instances, 3.5.3
temporary table space for creating indexes, 5.2.2
text
searchable, 3.5.4
thin client configuration, 1.1.3
third-generation language
See 3GL
threads
Oracle XA and, 15.3.9
three-tier model, 1.1.3
tight coupling, 15.1.1
time
changing default format of, 3.4.4
time data types
See date and time data types
TIMESTAMP data type, 3.4.1
TIMESTAMP WITH LOCAL TIME ZONE data type, 3.4.1
TIMESTAMP WITH TIME ZONE data type, 3.4.1
TM (transaction manager), 15.1.1
TPM (transaction processing monitor), 15.1.1
transaction manager (TM), 15.1.1
transaction processing monitor (TPM), 15.1.1
transactions
autonomous, 2.9
committing, 2.3.3
controlling transactions, 2.2.2
defining and controlling, 2.2.2
end of
consistent data, 2.2.2
grouping operations into, 2.3
improving performance of, 2.3.2
main, 2.9
read-only, 2.4, 2.4, 2.6
redo information for, 2.3.4
rolling back, 2.3.5
savepoints for, 2.3.6
serializable, 2.8
isolation level of, 2.8.2
SET TRANSACTION statement, 2.4
trigger
definition of, 7.1.2.16
triggers
invoking subprograms from, 7.7.3
size limits for, 7.1.2.9
using Java for, 1.3.7.2
TRUST keyword in RESTRICT_REFERENCES pragma, 7.9.4.4.1
two-phase commit protocol, 15.1.1
two-tier model, 1.1.3
TX interface, 15.1.1
type attributes, 7.1.2.2.3

U

undetected deadlocks, 2.7
undo data, 13.1
UNDO_RETENTION parameter, 2.4
unhandled exceptions, 7.5.2
UNIQUE constraints
dropping, 6.10
naming, 6.7.2
on FOREIGN KEY constraints, 6.2.2, 6.2.2
UNIQUE contraints, 6.1.8
unique keys
See UNIQUE constraints
universal rowids, 3.7.3
updates
distributed, 7.8.2
UPPER function, 5.5.1
UROWID data type
accessing, 3.7.3
user interfaces, 1.1.4
for native floating-point data types, 3.3.6
stateful and stateless, 1.1.5
user locks, 2.7
user-defined exceptions, 7.5, 7.5.1
user-defined run-time errors
See user-defined exceptions
user-defined types
as subprogram parameters, 7.1.2.2.4
UTLLOCKT.SQL script, 2.7.2

V

VARCHAR2 data type
columns
specifying length of, 3.2.2
compared to CHAR data type, 3.2.3
variables
cursor
See cursor variables
global
in C external subprograms, 14.13.6
static
in C external subprograms, 14.13.7
VERSIONS_ENDSCN pseudocolumn, 13.4
VERSIONS_ENDTIME pseudocolumn, 13.4
VERSIONS_OPERATION pseudocolumn, 13.4
VERSIONS_STARTSCN pseudocolumn, 13.4
VERSIONS_STARTTIME pseudocolumn, 13.4
VERSIONS_XID pseudocolumn, 13.4
views
constraints on, 6.1.9
violating constraints, 6.8.7

W

WAIT option of COMMIT statement and COMMIT_WRITE initialization parameter, 2.3.4
WAIT option of LOCK TABLE statement, 2.6.2
web applications
developing, 10
implementing, 10.2
overview of, 10.1
web development tools, 1.2.3
web pages
See also PL/SQL Server Pages
web services
overview of, 1.3.6
web toolkit
See PL/SQL Web Toolkit
WHERE clause expressions
See conditional expressions
WNDS option of RESTRICT_REFERENCES pragma, 7.9.4.4
WNPS option of RESTRICT_REFERENCES pragma, 7.9.4.4
WORK option of ROLLBACK statement, 2.3.5
wrap utility
debugging and, 7.6.5

X

X locks
LOCK TABLE statement, 2.6.2.4
xa_open string
defining, 15.3.3
XML data
representing, 3.5.5
XMLType data type, 3.5.5
X/Open Distributed Transaction Processing (DTP) architecture, 15.1

Z

zero
IEEE 754 represention of, 3.3.2.2