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 datatype, 3.5.6

AnyDataSet datatype, 3.5.6

AnyType datatype, 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 datatype, 3.9

arithmetic operations

with date and time datatypes, 3.4.5

with native floating-point datatypes, 3.3.4

ASP (Active Server Pages), 11.4

assignments

datatype conversion during, 3.8.1

reported by PL/Scope, 8.5

attributes

Java STATIC class, 7.9.4.3

type, 7.1.2.2.3

Automatic Undo Management system, 13.1

autonomous routines, 2.7

autonomous transactions, 2.7

AUTONOMOUS_TRANSACTION pragma, 2.7

B

backward compatibility

LONG and LONG RAW datatypes 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.1.4

BFILE datatype, 3.5.3

binary large objects, 3.5.3

binary numbers, 3.3.2, 3.3.2.1

binary ROWID datatype, 3.7.2.3

BINARY_DOUBLE datatype, 3.3.1, 3.3.6.2

BINARY_FLOAT datatype, 3.3.1, 3.3.6.2

binding, bulk

overview of, 7.1.2.14

when to use, 7.1.2.15

BLOB datatype, 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.2

see invoking subprograms

through embedded PL/SQL gateway, 10.4.4

canceling cursors, 2.3.4

century in date format, 3.4.3

changing

see altering

CHAR datatype

columns, specifying length of, 3.2.2

compared to VARCHAR2 datatype, 3.2.3

character datatypes, 3.2

character large objects, 3.5.3

character literals

delimiters for, 3.2.4

in SQL statements, 3.2.4

national, 3.2.4

Unicode, 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.4

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 datatype, 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.1.3, 2.1.6

COMMIT_WRITE initialization parameter, 2.1.4

comparison operators for native floating-point datatypes, 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.6

conditional expressions, representing as data, 3.6

conditions in regular expressions, 4.1.3

configuring database for Flashback Technology, 13.2

connection pools, 1.4.2

consistent reads, 2.2, 2.4

constraints, 6

altering, 6.9

CHECK

see CHECK constraints

deferring checking of, 6.2.4

defining

privileges needed for, 6.7.3

with ALTER TABLE statement, 6.7.2

with CREATE TABLE statement, 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.4, 6.7.4

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 datatypes

see datatype conversion

converting datatypes

see datatype 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.3

canceling, 2.3.4

closing, 2.3.3

maximum number for session, 2.3.1

pointers to, 7.3

scrollable, 1.4.2

with Oracle XA applications, 15.3.4

D

data integrity

see constraints

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

datatype conversion, 3.8

ANSI datatypes, 3.5.7

ANSI/ISO datatypes, 3.5.7

date and time datatypes, 3.4.6

DB2 datatypes, 3.5.7, 3.5.7

during assignments, 3.8.1

during expression evaluation, 3.8.2

LONG RAW datatype, 3.5.3

native floating-point datatypes, 3.3.5

RAW datatype, 3.5.3

SQL/DS datatypes, 3.5.7, 3.5.7

datatypes, 3

ANSI/ISO, 3.5.7

character, 3.2

conversion of

see datatype conversion

converting

see datatype 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

date

changing default format of, 3.4.3

date and time

displaying current, 3.4.2

date and time datatypes, 3.4

arithmetic operations with, 3.4.5

converting, 3.4.6

DATE datatype, 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.5

DBMS_OUTPUT package

using to debug subprograms, 7.6.4

DBMS_STATS package and Flashback Query, 13.12

DBMS_TYPES package, 3.5.6

DBMS_XA package, 15.3.10

deadlocks

undetected, 2.5

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

remote subprograms and, 7.8.1

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 queries

flashback features, 13.11

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.4

domain indexes, 5.4

DOUBLE datatype, 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.4.2.4

EXCLUSIVE MODE option of LOCK TABLE statement, 2.4.2.4

executing external subprograms, 14.10

execution

native

see native execution

resuming

after storage allocation error, 2.8

exporting date and time datatypes, 3.4.7

EXPR datatype, 3.9

expressions

conditional

representing as data, 3.6

evaluation of

datatype 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 datatype, 3.7.2.2

external binary ROWID datatype, 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 datatypes, 3.9

features, new, Preface

FIXED_DATE initialization parameter, 3.4.2

Flashback Data Archive, 13.10

Flashback Query, 13.3

DBMS_STATS package, 13.12

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

Flashback transaction backout, 13.9

Flashback Transaction Query, 13.5

Flashback Version Query, 13.4

FLASHBACK_TRANSACTION_QUERY view, 13.5

FLOAT datatype, 3.3.6.3

floating-point datatypes, 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.4

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 key constraints

enabling, 6.11

foreign keys

see FOREIGN KEY constraints

foreign rowids, 3.7.3

formal subprogram parameters

datatypes 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

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.1.4

importing date and time datatypes, 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.4

FIXED_DATE, 3.4.2

OPEN_CURSORS, 2.3.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 datatype, 3.4.1

INTERVAL YEAR TO MONTH datatype, 3.4.1

invoker's-rights subprograms, 7.7.1

invoking subprograms, 7.7

from 3GL applications, 7.7.4

from triggers, 7.7.2

interactively from Oracle Database tools, 7.7.3

isolation level of serializable transaction, 2.6.2

J

Java

compared to PL/SQL, 1.9.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.1.4

lightweight queue

definition of, in publish-subscribe model, 16.3

literals

character

delimiters for, 3.2.4

in SQL statements, 3.2.4

national, 3.2.4

Unicode, 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 datatypes, 3.5.3, 3.5.3

OO40 support for, 1.8.3

LOCK TABLE statement, 2.4.2

locking rows explicitly, 2.4.4

locking tables

explicitly, 2.4

implicitly, 2.4.3

log writer process (LGWR), 2.1.4

logical rowids, 3.7.3

LONG RAW Datatype, 3.5.3

LONG RAW datatype

converting, 3.5.3

loops

FOR

see FOR loops

loose coupling, 15.1.1

LOWER function, 5.5.1

M

main transaction, 2.7

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

national character literals, 3.2.4

native execution

compiling subprograms for, 7.2

native floating-point datatypes, 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 datatype, 3.5.3

negative infinity, 3.3.2.2

negative zero, 3.3.2.2

new features, Preface

NLSSORT function, 5.5.1

NO WAIT option of LOCK TABLE statement, 2.4.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.4

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.1.4

NULL values

FOREIGN KEY constraints and, 6.2.1

NUMBER datatype, 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 datatypes, 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

remote, 7.8.2

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.3.3

compared to precompilers, 1.9.1

kinds of functions in, 1.6.2

native floating-point datatypes 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.1.4

ODC (Oracle Data Control), 1.8.4

ODP.NET

overview of, 1.7

OO4O

automation server, 1.8.1

object datatype and LOB support, 1.8.3

object model, 1.8.2

overview of, 1.8

OO4O C++ Class Library, 1.8.5

OPEN_CURSORS initialization parameter, 2.3.1

operators

comparison

for native floating-point datatypes, 3.3.3

relational

see comparison operators

optimizer

function-based indexes and, 5.5.1

ORA_ROWSCN pseudocolumn, 13.7, 13.7, 13.7, 13.7, 13.7, 13.7, 13.7, 13.7

OraAQ object, 1.8.2.10

OraAQAgent object, 1.8.2.12

OraAQMsg object, 1.8.2.11

OraBFILE objects, 1.8.3.2

OraBLOB objects, 1.8.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.8.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 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.5

Oracle Multimedia, 3.5.2

Oracle OBJECT

native floating-point datatypes 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 XA, 15

Oracle XA library, 15.2

OraCLOB objects, 1.8.3.1

OraDatabase object, 1.8.2.3

OraDynaset object, 1.8.2.4

OraField object, 1.8.2.5

OraMDAttribute object, 1.8.2.6

OraMetaData object, 1.8.2.6

OraParamArray object, 1.8.2.8

OraParameter object, 1.8.2.7

OraParameters collection, 1.8.2.7

OraServer object, 1.8.2.2

OraSession object, 1.8.2.1

OraSQLStmt object, 1.8.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.3

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.3.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, 1.2.3, 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.7

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.9.1

with Oracle XA applications, 15.3.4

PRIMARY KEY constraints, 6.1.7

dropping, 6.10

naming, 6.7.4

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.3

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.3.4

native floating-point datatypes in, 3.3.6.3

overview of, 1.4

Pro*COBOL

overview of, 1.5.1

procedures

callback

C, 14.13

PL/SQL Server Pages and, 11.5.3

Q

Q or q for specifying character-literal delimiter, 3.2.4

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

query result change notification, 12.2

queue

definition of, in publish-subscribe model, 16.3

quotation mark

single ('), as character-literal delimiter, 3.2.4

R

Radio Frequency Identification (RFID) technology, 17.7.1

RAISE statement, 7.5.1

RAISE_APPLICATION_ERROR procedure, 7.5, 7.5.1

RAW datatype, 3.5.3

converting, 3.5.3

read-only transactions, 2.2, 2.4

receiving a message

definition of, in publish-subscribe model, 16.3

redo information, 2.1.4

redo information for transactions, 2.1.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 objects, 7.8.2

remote queries

flashback features, 13.11

remote subprograms

invoking, 7.8

run-time errors in, 7.5.4

renaming constraints, 6.9.1

repeatable reads, 2.2, 2.4

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 datatype, 3.7.2.1

result cache, 7.1.2.7

resumable storage allocation, 2.8

resuming execution

after storage allocation error, 2.8

RETENTION GUARANTEE clause for undo tablespace, 13.2.1

RETENTION option of ALTER TABLE statement, 13.2.4

retention period, 2.2

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.1.5, 2.1.6

rolling back transactions, 2.1.5

rounding numbers, 3.3.2

routine

autonomous scope

definition, 2.7

routines

see subprograms

ROW EXCLUSIVE MODE option of LOCK TABLE statement, 2.4.2.1

ROW EXCLUSIVE MODE table lock, 2.4.2

ROW SHARE EXCLUSIVE MODE option of LOCK TABLE statement, 2.4.2.3

ROW SHARE MODE option of LOCK TABLE statement, 2.4.2.1

ROW SHARE MODE table lock, 2.4.2

ROWID datatype

accessing, 3.7.2

ROWID pseudocolumn

querying, 3.7.1

rowids

datatypes of, 3.7

foreign, 3.7.3

logical, 3.7.3

universal, 3.7.3

rows

identifying by address, 3.7

locking explicitly, 2.4.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.1.6, 2.1.6, 2.1.6

savepoints, 2.1.6

scalability, 1.2.2.4

scope

autonomous, 2.7

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.4.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.6

isolation level of, 2.6.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

sessions

packages and, 7.1.2.12

SET CONSTRAINTS statement, 6.2.4

SET TRANSACTION statement, 2.2, 2.2

SHARE MODE option of LOCK TABLE statement, 2.4.2.2

share row exclusive locks (SRX)

LOCK TABLE statement, 2.4.2.3

side effects of functions, controlling, 7.9.4

single quotation mark (') as character-literal delimiter, 3.2.4

size limits

for PL/SQL stored database objects, 7.1.2.9

SKIP LOCKED clause of SELECT FOR UPDATE statement, 2.4.4

sorting

with function-based indexes, 5.5.1

spatial data, 3.5.1

specifications of packages, 7.1.2.8

SQL datatypes

see datatypes

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

SQL*Loader

creating indexes with, 5.2.2

SQL*Plus

compile-time errors and, 7.4

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 datatype, 3.3.6.1

SQLT_BFLOAT datatype, 3.3.6.1

SRX locks

LOCK Table statement, 2.4.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.8.2

storage allocation errors

resuming execution after, 2.8

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

datatypes of formal, 7.1.2.2.2

default values of, 7.1.2.2.5

remote subprograms and, 7.8.1

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.3

T

tables

child, 6.11.4, 6.11.5

columns of

see columns

locking, 2.4.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 datatypes

see date and time datatypes

TIMESTAMP datatype, 3.4.1

TIMESTAMP WITH LOCAL TIME ZONE datatype, 3.4.1

TIMESTAMP WITH TIME ZONE datatype, 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.7

committing, 2.1.3

grouping operations into, 2.1

improving performance of, 2.1.2

main, 2.7

read-only, 2.2, 2.2, 2.4

redo information for, 2.1.4

rolling back, 2.1.5

savepoints for, 2.1.6

serializable, 2.6

isolation level of, 2.6.2

SET TRANSACTION statement, 2.2

trigger

definition of, 7.1.2.16

triggers

invoking subprograms from, 7.7.2

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.5

undo data, 13.1

UNDO_RETENTION parameter, 2.2

unhandled exceptions, 7.5.2

Unicode character literals, 3.2.4

UNINSTR function, 3.2.4

UNIQUE constraints

dropping, 6.10

naming, 6.7.4

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 datatype

accessing, 3.7.3

user interfaces, 1.1.4

for native floating-point datatypes, 3.3.6

stateful and stateless, 1.1.5

user locks, 2.5

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.5.3

V

VARCHAR2 datatype

columns

specifying length of, 3.2.2

compared to CHAR datatype, 3.2.3

variables

cursor

see cursor variables

environment

see environment 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.1.4

WAIT option of LOCK TABLE statement, 2.4.2

web applications

developing, 10

implementing, 10.2

overview of, 10.1

web development tools, 1.2.3

web pages

X

X locks

LOCK TABLE statement, 2.4.2.4

xa_open string

defining, 15.3.3

XML data

representing, 3.5.5

XMLType datatype, 3.5.5

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

Z

zero

IEEE 754 represention of, 3.3.2.2