Skip Headers
Oracle® Database Application Developer's Guide - Fundamentals
10g Release 2 (10.2)

Part Number B14251-01
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
Feedback

Go to previous page
Previous
View PDF

Index

A  B  C  D  E  F  G  H  I  J  K  L  M  N  O  P  Q  R  S  T  U  V  W  X 

Symbols

%ROWTYPE attribute, 7.1.2.2.3
used in stored functions, 7.1.2.2.3
%TYPE attribute, 7.1.2.2.3

A

Active Data Object
translating to PSP, 12.1.4
Active Server Pages
translating to PSP, 12.1.4
AFTER SUSPEND event
handling suspended storage allocation, 2.8.3
AFTER triggers
auditing and, 9.8, 9.8
correlation names and, 9.3.1
specifying, 9.2.4
agent
definition, 16.3
ALL_ERRORS view
debugging stored procedures, 7.5
ALL_SOURCE view, 7.5
ALTER SESSION statement
SERIALIZABLE clause, 2.6.2
ALTER TABLE statement
defining integrity constraints, 6.7.2
DISABLE ALL TRIGGERS clause, 9.6.2
DISABLE CONSTRAINT clause, 6.8.5.2
DROP CONSTRAINT clause, 6.10
ENABLE ALL TRIGGERS clause, 9.6.1
ENABLE CONSTRAINT clause, 6.8.5.1
INITRANS parameter, 2.6.2.1
RETENTION option, for flashback, 10.2
ALTER TRIGGER statement
DISABLE clause, 9.6.2
ENABLE clause, 9.6.1
anonymous PL/SQL blocks
about, 7.1.1
compared to triggers, 7.1.2.15
AnyData datatype, 3.5.6
AnyDataSet datatype, 3.5.6
AnyType datatype, 3.5.6
applications
calling stored procedures and packages, 7.8.3
unhandled exceptions in, 7.6.2
asynchronous commit feature
using to manage redo behavior, 2.1.3.1
attributes
%rowtype, PL/SQL, 1.2.2.1
%type, PL/SQL, 1.2.2.1
auditing
triggers and, 9.8
autonomous routine, 2.7
autonomous scope
definition, 2.7
autonomous transactions, 2.7, 2.7.2
AUTONOMOUS_TRANSACTION pragma, 2.7

B

BEFORE triggers
complex security authorizations, 9.8
correlation names and, 9.3.1
derived column values, 9.8
specifying, 9.2.4
BFILE datatype, 3.5.3
BINARY_DOUBLE datatype, 3.3.1
BINARY_FLOAT datatype, 3.3.1
binding, bulk
definition, 7.1.2.13
BLOB datatype, 3.5.3
body of package
definition, 7.1.2.7
Boolean expressions, 3.8.2
bulk binding
definition, 7.1.2.13
bulk binds, 7.1.2.13
DML statements, 7.1.2.14.1
FOR loops, 7.1.2.14.3
SELECT statements, 7.1.2.14.2
usage, 7.1.2.14
BY REF phrase, 14.9.6.6
BYTE qualifier for column lengths, 3.2.2

C

call specifications, 14.3
callbacks, 14.13
canceling a cursor, 2.3.4
CATPROC.SQL script, 9.9.5
century
date format masks, 3.4.2.1
CGI variables, 11.5.5
CHAR qualifier for column lengths, 3.2.2
character data, 3.2
Character Large Object, 3.5.3
character literals
quoting, 3.2.4
quoting with Q, 3.2.4.1
using in SQL statements, 3.2.4
CHARSETFORM property, 14.9.6.3
CHARSETID property, 14.9.6.3
CHECK constraint
triggers and, 9.8, 9.8
check constraints
how to use, 6.6
CHNF$_DESC type, 13.5.1
CHNF$_REG_INFO type
using in database change registrations, 13.3.8.1
CHNF$_TDESC type, 13.5.1.1
client
definition, 16.3
client events, 9.9.6.2
CLOB datatype, 3.5.3
column type attribute, PL/SQL, 1.2.2.1
columns
accessing in triggers, 9.3.1
default values, 6.1.6, 7.10.1
generating derived values with triggers, 9.8
listing in an UPDATE trigger, 9.2.3.2, 9.3.1.4
multiple foreign key constraints, 6.2.3
number of CHECK constraints limit, 6.6.3
specifying length in bytes or characters, 3.2.2
COMMIT statement, 2.1.3
managing redo behavior, 2.1.3.1
COMMIT_WRITE initialization parameter, 2.1.3.1
compile-time errors, 7.5
compiling PL/SQL procedures to native code, 7.2
composite keys
foreign, 6.2
restricting nulls in, 6.6.4
concurrency, 2.6
conditional expressions
in WHERE clause, 3.6
conditional predicates
trigger bodies, 9.3, 9.3.1.4
connection pooling, 1.4.2
consistency
read-only transactions, 2.2
constraining tables, 9.3.4
constraints
See integrity constraints
context switches
reducing with bulk binds, 7.1.2.13
converting data, 3.8
ANSI datatypes, 3.5.7
expression evaluation, 3.8.2
SQL/DS and DB2 datatypes, 3.5.7
cookies, 11.5.5
correlation names, 9.2.8
NEW, 9.3.1
OLD, 9.3.1
REFERENCING option and, 9.3.1.3
when preceded by a colon, 9.3.1
CREATE INDEX statement, 5.2
CREATE PACKAGE BODY statement, 7.1.2.9
CREATE PACKAGE statement, 7.1.2.9
CREATE TABLE statement
defining integrity constraints, 6.7.1
INITRANS parameter in, 2.6.2.1
CREATE TRIGGER statement, 9.2
REFERENCING option, 9.3.1.3
cursor and cursor variable
definitions, 2.3
cursors, 2.3
canceling, 2.3.4
closing, 2.3.3
declaring and opening cursor variables, 7.4.1
maximum number of, 2.3.1
pointers to, 7.4
private SQL areas and, 2.3

D

data conversion
See converting data
data dictionary
compile-time errors, 7.5
integrity constraints in, 6.12
procedure source code, 7.5
data recovery using flashback features, 10.1.2
Database Change Notification
creating a PL/SQL callback procedure, 13.3.7
interfaces, 13.3.6
interpreting notifications, 13.5
overview, 13.1
querying registrations, 13.4
registering database objects, 13.3.8
registrations, 13.3.2
scenario, 13.6
database links
using in Oracle XA applications, 15.5.1
datatypes, 3.1
ANSI/ISO, 3.5.7
BINARY_DOUBLE, 3.3.1
BINARY_FLOAT, 3.3.1
CHAR, 3.2
column length, 3.2.2
character, 3.2
column lengths for character types, 3.2.2
conversion, 3.8
DB2, 3.5.7
LONG, 3.2.1
MDSYS.SDO_GEOMETRY, 3.5.1
native floating point, 3.3.1
native floating-point
IEEE 754 exceptions not raised, 3.3.2.2.1
NCHAR, 3.2
numeric, 3.3
NVARCHAR2, 3.2
ROWID, 3.7.1
SQL/DS, 3.5.7
VARCHAR2, 3.2
column length, 3.2.2
date and time data
representing, 3.4
date arithmetic, 3.8.2
functions for, 3.4.4
DATE datatype, 3.4.1.1, 3.4.1.1
DB_ROLE_CHANGE system manager event, 9.9.6.1
DB2 datatypes, 3.5.7
DBA_2PC_NEIGHBORS view, 15.4.3
DBA_2PC_PENDING view, 15.4.3
DBA_CHANGE_NOTIFICATION_REGS initialization parameter, 13.4
DBA_ERRORS view
debugging stored procedures, 7.5
DBA_PENDING_TRANSACTIONS view, 15.4.3
DBA_SOURCE view, 7.5
DBMS_CHANGE_NOTIFICATION package
using to create database change notifications, 13.3.8.2
DBMS_FLASHBACK package, 10.4
DBMS_LOB.GETCHUNKSIZE, 3.2.1
DBMS_LOCK package, 2.5
DBMS_RESUMABLE package
handling suspended storage allocation, 2.8.3
DBMS_SQL package
advantages of, 8.4.2
client-side programs, 8.4.2.1
DESCRIBE, 8.4.2.2
differences with native dynamic SQL, 8.4
DBMS_STATS package and Flashback Query, 10.8.1
DBMS_TYPES package, 3.5.6
DBMS_XMLGEN package, 3.5.5
DBMS_XMLQUERY package, 3.5.5
DBMS_XMLSAVE package, 3.5.5
DDL statements
package state and, 7.1.2.11
DEBUG_EXTPROC package, 14.13.3.1
debugging
stored procedures, 7.7
triggers, 9.5.1
dedicated external procedure agents, 14.4.2
default parameters in stored functions, 7.10.3.3
definer's-rights procedure, 7.8.5
DELETE statement
column values and triggers, 9.3.1
data consistency, 2.4
triggers for referential integrity, 9.8, 9.8
denormal floating-point numbers, 3.3.2.1
dependencies
among PL/SQL library objects, 7.3
in stored triggers, 9.4.1
schema objects
trigger management, 9.3.4
timestamp model, 7.3.1.1
DESC function, 5.4.1
DETERMINISTIC keyword, 7.10.5.2
dictionary_obj_owner event attribute, 9.9.5
dictionary_obj_owner_list event attribute, 9.9.5
dictionary_obj_type event attribute, 9.9.5
disabled integrity constraint
definition, 6.8
disabled trigger
definition, 9.6
disabling
integrity constraints, 6.8.3
triggers, 9.6, 9.6.2
distributed databases
referential integrity and, 6.5
remote stored procedures, 7.9, 7.9.2
triggers and, 9.3.4
distributed queries
flashback features, 10.8.2
handling errors, 7.6.3
distributed transaction processing, 15.1
managing branches, 15.5.2
resource manager (RM), 15.1.1
transaction manager (TM), 15.1.1
transaction processing monitor (TPM), 15.1.1
TX interface, 15.1.1
distributed transactions
branches, 15.1.1
managing in RAC, 15.5.3.1
managing with singleton services, 15.5.3.1
distributed update
definition, 7.9.2
DML_LOCKS parameter, 2.4
double datatype, native in C and C++, 3.3.6.3
DROP INDEX statement, 5.1.7
DROP TRIGGER statement, 9.5
dropping
indexes, 5.1.7
integrity constraints, 6.10
packages, 7.1.2.5
procedures, 7.1.2.4
triggers, 9.5
dynamic SQL
application development languages, 8.1.1
invoker's rights, 8.2.6
invoking PL/SQL blocks, 8.2.5
optimization, 8.2.4
queries, 8.2.2
scenario, 8.3
usage, 8.2
dynamically typed data
representing, 3.5.6

E

e-mail
sending from PL/SQL, 11.5.1
embedded SQL, 7.1
enabled integrity constraint
definition, 6.8
enabled trigger
definition, 9.6
enabling
integrity constraints, 6.8.3
triggers, 9.6, 9.6.1
errors
application errors raised by Oracle Database packages, 7.6
remote procedures, 7.6.4
user-defined, 7.6, 7.6.1
event attribute functions, 9.9.5
event notification, 16.3
event publication, 9.9
triggering, 9.9
events
attribute, 9.9.5
client, 9.9.6.2
resource manager, 9.9.6.1
tracking, 9.8
exception handlers
in PL/SQL, 7.1.1
exception to a constraint, 6.8.2
exceptions
during trigger execution, 9.3.1.5
effects on applications, 7.6.2
remote procedures, 7.6.4
unhandled, 7.6.2
exclusive locks
LOCK TABLE statement, 2.4.1.4
explicit locks, 2.4
expression filtering, 3.6
expressions, conditional in WHERE clause, 3.6
extended ROWID format, 3.7.2.2
external LOB
definition, 3.5.3
external procedure, 14.2
DBA tasks required, 14.4.2
DEBUG_EXTPROC package, 14.13.3.1
debugging, 14.13.3
definition, 14.2
maximum number of parameters, 14.13.6
specifying datatypes, 14.9.1
extproc process, 14.4.2, 14.10.4

F

features
new, Preface
features, new, Preface
firing of triggers, 9
flashback features, 10.1
performance, 10.8.1
flashback privileges, 10.2
Flashback Query, 10.3
DBMS_STATS package, 10.8.1
Flashback Transaction Query, 10.7
Flashback Version Query, 10.6
FLASHBACK_TRANSACTION_QUERY view, 10.7
float datatype, native in C and C++, 3.3.6.3
floating-point numbers, 3.3
FOR EACH ROW clause, 9.2.7
FORALL statement
using, 7.1.2.13
foreign key constraints
defining, 6.11.5
enabling, 6.8.3, 6.11
NOT NULL constraint and, 6.2.2
one-to-many relationship, 6.2.2
one-to-n relationships, 6.2.2
UNIQUE key constraint and, 6.2.2
format masks
TO_DATE function, 3.4.2.1
full-text search
using Oracle9i Text, 3.5.4

G

geographic coordinate data
representing, 3.5.1
global entity
definition, 7.1.2.9.1
grantee event attribute, 9.9.5

H

HTML
retrieving from PL/SQL, 11.5.4
HTP and HTF packages, 11.5.5
HTTP URLs, 11.5.4

I

IBM datatypes, 3.5.7
IEEE 754 standard for floating-point numbers, 3.3.2
image maps, 11.5.5
IN OUT parameter mode, 7.1.2.2.1
IN parameter mode, 7.1.2.2.1
indexes
creating, 5.2
dropping, 5.1.7
function-based, 5.4
guidelines, 5.1.3
order of columns, 5.1.5
privileges, 5.1.8
SQL*Loader and, 5.1.2
temporary segments and, 5.1.2
when to create, 5.1.1
INDICATOR property, 14.9.6.1
-INF and +INF, 3.3.2.2
infinity values, 3.3.2.2
initialization parameters
DML_LOCKS, 2.4
OPEN_CURSORS, 2.3.1
REMOTE_DEPENDENCIES_MODE, 7.3.3
INITRANS parameter, 2.6.2.1
INSERT statement
column values and triggers, 9.3.1
read consistency, 2.4
instance recovery
managing in RAC, 15.5.3.2
instance_num event attribute, 9.9.5
INSTEAD OF triggers, 9.2.6
on nested table view columns, 9.3.1.2
integrity constraints
CHECK, 6.6
composite UNIQUE keys, 6.1.8
defining, 6.7
disabling, 6.8.1, 6.8.4, 6.8.5.2
dropping, 6.10
enabling, 6.8
examples, 6.1.1.1
exceptions to, 6.8.7
listing definitions of, 6.12
naming, 6.7.4
NOT NULL, 6.1.4
performance considerations, 6.1.2
PRIMARY KEY, 6.1.7
privileges required for creating, 6.7.3
renaming, 6.9.1
triggers vs., 9.8
triggers vs., 9.1
UNIQUE, 6.1.8
violations, 6.8.2
when to use, 6.1.1
interactive block execution, 7.8.2
INTERVAL DAY TO SECOND datatype, 3.4.1.1
INTERVAL YEAR TO MONTH datatype, 3.4.1.1
invoker's-rights procedure, 7.8.5
is_alter_column event attribute, 9.9.5
ISOLATION LEVEL
changing, 2.6.2
SERIALIZABLE, 2.6.2

J

Java
calling methods through call specifications, 14.3
compared to PL/SQL, 1.9.3
generating wrapper classes with JPublisher, 1.3.3.2
JDBC
overview, 1.3.2
loading into the database, 14.4.1
SQLJ
overview, 1.3.3
Java Server Pages
translating to PSP, 12.1.4
Javascript
translating to PSP, 12.1.4
JDBC
See Oracle JDBC
JScript
translating to PSP, 12.1.4

K

keys
foreign, 6.11
unique
composite, 6.1.8

L

large data
representing with LOBs, 3.5.3
Large Objects (LOBs), 3.5.3
libraries, 1.9.2
library units
remote dependencies, 7.3
loadjava utility, 1.3.3.3
LOB datatypes, 1.8.3.1, 3.5.3
external
definition, 3.5.3
support in OO4O, 1.8.3
use in triggers, 9.3.1.1
LOCK TABLE statement, 2.4.1
locks
explicit, 2.4
LOCK TABLE statement, 2.4.1, 2.4.1.2
privileges for manual acquirement, 2.4.1.5
user, 2.5
UTLLOCKT.SQL script, 2.5.3
LONG datatype, 3.2.1
use in triggers, 9.3.4
LOWER function, 5.4.1

M

mail
sending from PL/SQL, 11.5.1
main transaction
definition, 2.7
manual locks, 2.4
LOCK TABLE statement, 2.4.1
match full rule for NULL values, 6.2.1
match partial rule for NULL values, 6.2.1
MDSYS.SDO_GEOMETRY datatype, 3.5.1
memory
scalability, 7.10.6
modes
parameter, 7.1.2.2.1
mutating table
definition, 9.3.4
mutating tables
trigger restrictions, 9.3.4

N

National Character Set Large Object, 3.5.3
native dynamic SQL
advantages of, 8.4.1
differences with DBMS_SQL package, 8.4
fetching into records, 8.4.1.4
performance, 8.4.1.2
user-defined types, 8.4.1.3
native execution
of PL/SQL procedures, 7.2
native float and native double datatypes in C and C++, 3.3.6.3
native floating-point datatypes, 3.3.1
arithmetic, rounding behavior, 3.3.4
IEEE 754 exceptions not raised, 3.3.2.2.1
infinity values, 3.3.2.2
NCHAR datatype, 3.2
NCLOB datatype, 3.5.3
negative infinity value, 3.3.2.2
NEW correlation name, 9.3.1
new features, Preface
NLS_DATE_FORMAT parameter, 3.4.2.1
NLSSORT order, and indexes, 5.4.1
normalization of floating-point numbers, 3.3.2.1
NOT NULL constraint
CHECK constraint and, 6.6.4
data integrity, 6.8.3
when to use, 6.1.4
notification, event, 16.3
NOWAIT option, 2.4.1
NUMBER datatype, 3.3.1, 3.3.1
numeric datatypes, 3.3
NVARCHAR2 datatype, 3.2

O

OAS, 11.5.5
obfuscating PL/SQL code, 7.7
object columns, indexes on, 5.4.1
object support in OO4O, 1.8.3
OBJECT_VALUE pseudocolumn, 9.3.2
OCCI
overview, 1.6
OCI, 7.1
applications, 7.1.1
cancelling cursors, 2.3.4
closing cursors, 2.3.3
comparison with precompilers, 1.9.1
overview, 1.6
OCIEnv function, 15.2.2
OCISvcCtx function, 15.2.2
OCITransCommit function, 2.1.3.1
OLD correlation name, 9.3.1
one-to-many relationship
with foreign keys, 6.2.2
one-to-one relationship
with foreign keys, 6.2.2
OO4O
See Oracle Objects for OLE
open string for Oracle XA, 15.3.3
OPEN_CURSORS parameter, 2.3.1
OR REPLACE clause
for creating packages, 7.1.2.9
ora_dictionary_obj_owner event attribute, 9.9.5
ora_dictionary_obj_owner_list event attribute, 9.9.5
ora_dictionary_obj_type event attribute, 9.9.5
ora_grantee event attribute, 9.9.5
ora_instance_num event attribute, 9.9.5
ora_is_alter_column event, 9.9.5
ora_is_creating_nested_table event attribute, 9.9.5
ora_is_drop_column event attribute, 9.9.5
ora_is_servererror event attribute, 9.9.5
ora_login_user event attribute, 9.9.5
ora_privileges event attribute, 9.9.5
ora_revokee event attribute, 9.9.5
ORA_ROWSCN pseudocolumn, 10.5, 10.5, 10.5, 10.5, 10.5, 10.5, 10.5, 10.5
ora_server_error event attribute, 9.9.5
ora_sysevent event attribute, 9.9.5
ora_with_grant_option event attribute, 9.9.5
ORA-21301 error, fixing, 15.3.3.3
OraAQ object, 1.8.2.10
OraAQAgent object, 1.8.2.12
OraAQMsg object, 1.8.2.11
OraBFILE object, 1.8.3.2
OraBLOB object, 1.8.3.1
Oracle Application Server (OAS), 11.5.5
Oracle Call Interface
See OCI
Oracle Data Control (ODC), 1.8.4
Oracle Data Provider for .NET
overview, 1.7
Oracle JDBC
definition, 1.3.2
example, 1.3.2.6
OCI driver, 1.3.2.2
Oracle Database extensions, 1.3.2.4
server driver, 1.3.2.3
stored procedures, 1.3.7.2
thin driver, 1.3.2.1
Oracle JDeveloper
definition, 1.3.3.1
Oracle JPublisher
definition, 1.3.4
Oracle Objects for OLE
automation server, 1.8.1
C++ Class Library, 1.8.5
LOB and object support, 1.8.3
object model, 1.8.2
overview, 1.8
Oracle Real Application Clusters
managing instance recovery with Oracle XA library, 15.5.3.2
managing XA transaction branches, 15.5.3.1
using XA library, 15.5.3
Oracle SQLJ
advantages over JDBC, 1.3.3.2
definition, 1.3.3
design, 1.3.3.1
in the server, 1.3.3.3
stored programs, 1.3.3.3
Oracle XA applications
developing and installing, 15.3
managing transaction branches, 15.5.2
troubleshooting, 15.4
using database links, 15.5.1
Oracle XA library, 15.1.1
dynamic and static registration, 15.1.1
extension functions, 15.2.2
issues and restrictions, 15.5
managing instance recovery in RAC, 15.5.3.2
managing thread safety, 15.3.7
managing transaction control, 15.3.5
managing transactions in RAC, 15.5.3.1
monitoring XA transactions, 15.4.3
precompilers and OCI, 15.3.4
SQL-based restrictions, 15.5.4
trace files, 15.4.1
TX interface, 15.1.1
using with RAC, 15.5.3
xa_close subroutine, 15.2.1
xa_commit subroutine, 15.2.1
xa_end subroutine, 15.2.1
xa_forget, 15.2.1
xa_open subroutine, 15.2.1
xa_prepare subroutine, 15.2.1
xa_recover, 15.2.1
xa_rollback subroutine, 15.2.1
xa_start subroutine, 15.2.1
OraCLOB object, 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
OraServer object, 1.8.2.2
OraSession object, 1.8.2.1
OraSQLStmt object, 1.8.2.9
OUT parameter mode, 7.1.2.2.1
overloading
packaged functions, 7.10.5.4.3
procedures and functions, definition, 7.1.2.7
using RESTRICT_REFERENCES, 7.10.5.4.3
OWA* packages, 11.5.5

P

package
definition, 7.1.2.7
package body, 7.1.2.7
package specification, 7.1.2.7
packages, 1.9.2
creating, 7.1.2.9
DEBUG_EXTPROC, 14.13.3.1
dropping, 7.1.2.5
in PL/SQL, 7.1.2.7
naming of, 7.1.2.10
Oracle Database, 7.1.2.12
privileges for execution, 7.8.5
privileges required to create, 7.1.2.9.2
privileges required to create procedures in, 7.1.2.3.1
serially reusable packages, 7.10.6
session state and, 7.1.2.11
synonyms, 7.9.3
UTL_TCP, 11.5.2
where documented, 7.1.2.12
parallel server
distributed locks, 2.4
PARALLEL_ENABLE keyword, 7.10.5.2
parameters
default values, 7.1.2.2.5
with stored functions, 7.10.3.3
modes, 7.1.2.2.1
parse tree, 9.4
pcode
when generated for triggers, 9.4
performance
index column order, 5.1.5
native dynamic SQL, 8.4.1.2
permanent and temporary LOB instances, 3.5.3
PL/SQL, 7.1
anonymous blocks, 7.1.1
calling remote stored procedures, 7.9.2
compared to Java, 1.9.3
cursor variables, 7.4
dependencies among library units, 7.3
exception handlers, 7.1.1
functions
arguments, 7.10.3.2
overloading, 7.10.5.4.3
parameter default values, 7.10.3.3
purity level, 7.10.5.4.1
RESTRICT_REFERENCES pragma, 7.10.5.4
using, 7.10.1
invoking with dynamic SQL, 8.2.5
objects, 1.2.2.6
overview, 1.2
packages, 7.1.2.7
program units, 7.1
RAISE statement, 7.6.1
serially reusable packages, 7.10.6
server pages, 12.4
tables, 7.1.2.2.4
of records, 7.1.2.2.4
trigger bodies, 9.3, 9.3.1
user-defined errors, 7.6.1
Web toolkit, 11.5.5
PL/SQL Gateway
definition, 11.1.2.1.1
PLSQL_COMPILER_FLAGS initialization parameter, 7.2
positive infinity value, 3.3.2.2
POSIX
Oracle support for regular expressions, 4.1.4
POSIX standard
metacharacters in Oracle regular expressions, 4.2.1
posting, message
definition, 16.3
pragma, 2.7.2
RESTRICT_REFERENCES, 7.10.5.4
SERIALLY_REUSABLE pragma, 7.10.6, 7.10.6.3
precompilers, 7.8.3
applications, 7.1.1
calling stored procedures and packages, 7.8.3
compared to OCI, 1.9.1
PRIMARY KEY constraints
choosing a primary key, 6.1.7
disabling, 6.8.4
enabling, 6.8.3
multiple columns in, 6.1.7
UNIQUE key constraint vs., 6.1.8
private SQL areas
cursors and, 2.3
privileges
creating integrity constraints, 6.7.3
creating triggers, 9.3.6
dropping triggers, 9.5
flashback, 10.2
index creation, 5.1.8
manually acquiring locks, 2.4.1.5
recompiling triggers, 9.4.2
stored procedure execution, 7.8.5
triggers, 9.3.6
Pro*C/C++
overview of application development, 1.4.1
Pro*COBOL
overview of application development, 1.5.1
procedure
external
definition, 14.2
procedures
called by triggers, 9.3.4
external, 14.2
program units in PL/SQL, 7.1
property
CHARSETFORM, 14.9.6.3
CHARSETID, 14.9.6.3
INDICATOR, 14.9.6.1
pseudocolumns
modifying views, 9.2.6.1
publish-subscribe, 16.1
purity of stored function, definition, 7.10.5

Q

queries
dynamic, 8.2.2
errors in distributed queries, 7.6.3

R

RAISE statement, 7.6.1
RAISE_APPLICATION_ERROR procedure, 7.6
remote procedures, 7.6.4
raising exceptions
triggers, 9.3.1.5
read-only transactions, 2.2
recovery, data, using flashback features, 10.1.2
REF column
indexes on, 5.4.1
REFERENCING option, 9.3.1.3
referential integrity
distributed databases and, 6.5
one-to-many relationship, 6.2.2, 6.2.2
one-to-one relationship, 6.2.2
privileges required to create foreign keys, 6.11.4
self-referential constraints, 9.8
triggers and, 9.8
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
regular expressions
operators, multilingual enhancements, 4.2.2
Oracle support for POSIX standard, 4.1.4
overview, 4.1.1
Perl-influenced extensions in Oracle Database, 4.2.3
SQL functions and conditions, 4.1.3
regular expressions, Oracle implementation, 4.1.3
remote dependencies, 7.3
signatures, 7.3.2
specifying timestamps or signatures, 7.3.3
remote exception handling, 7.6.4, 9.3.3
remote queries
flashback features, 10.8.2
REMOTE_DEPENDENCIES_MODE parameter, 7.3.3
repeatable reads, 2.2, 2.4
resource manager
events, 9.9.6.1
resource manager (RM), 15.1.1
RESTRICT_REFERENCES pragma, 7.10.5.4
syntax for, 7.10.5.4
restrictions
system triggers, 9.3.4
resumable storage allocation, 2.8
definition, 2.8
examples, 2.8.4
RETENTION GUARANTEE clause for undo tablespace, 10.2
reusable packages, 7.10.6
RNDS argument, 7.10.5.4
RNPS argument, 7.10.5.4
ROLLBACK statement, 2.1.4
rolling back transactions
to savepoints, 2.1.4
routine
autonomous scope
definition, 2.7
external
definition, 14.2
routines
external, 14.2
service, 14.12
row locking
manual, 2.4.3
row triggers
defining, 9.2.7
REFERENCING option, 9.3.1.3
timing, 9.2.4
UPDATE statements and, 9.2.3.2, 9.3.1.4
ROWID datatype
extended ROWID format, 3.7.2.2
rows
violating integrity constraints, 6.8.2
rowtype attribute, PL/SQL, 1.2.2.1
ROWTYPE_MISMATCH exception, 7.4.2.2
RS locks
LOCK TABLE statement, 2.4.1.1
run-time error handling, 7.6
RX locks
LOCK TABLE statement, 2.4.1.1

S

S locks
LOCK TABLE statement, 2.4.1.2
SAVEPOINT statement, 2.1.5
savepoints
maximum number of, 2.1.5
rolling back to, 2.1.4
scalability
serially reusable packages, 7.10.6
scope
autonomous
definition, 2.7
scrollable cursors, 1.4.2
search data
representing, 3.5.4
SELECT statement
AS OF clause, 10.3
FOR UPDATE clause, 2.4.3
read consistency, 2.4
VERSIONS BETWEEN...AND clause, 10.6
SERIALIZABLE option
for ISOLATION LEVEL, 2.6.2
serializable transactions, 2.6
serially reusable PL/SQL packages, 7.10.6
SERIALLY_REUSABLE pragma, 7.10.6.3
service routine, 14.12
sessions
package state and, 7.1.2.11
SET TRANSACTION statement, 2.2
ISOLATION LEVEL clause, 2.6.2
SERIALIZABLE, 2.6.2
share locks (S)
LOCK TABLE statement, 2.4.1.2
share row exclusive locks (SRX)
LOCK TABLE statement, 2.4.1.3
side effects, subprogram, 7.1.2.2.1, 7.10.5
signatures
PL/SQL library unit dependencies, 7.3
to manage remote dependencies, 7.3.2
singleton services
using to manage distribution transactions, 15.5.3.1
SORT_AREA_SIZE parameter
index creation and, 5.1.2
sorting
with function-based indexes, 5.4
specification part of package, definition, 7.1.2.7
SQL functions
regular expressions, 4.1.3
SQL statements
in trigger bodies, 9.3.1, 9.3.4
not allowed in triggers, 9.3.4
SQL*Loader
indexes and, 5.1.2
SQL*Module
applications, 7.1.1
SQL*Plus
anonymous blocks, 7.1.1
compile-time errors, 7.5
invoking stored procedures, 7.8
loading a procedure, 7.1.2.3
SHOW ERRORS command, 7.5
SQL/DS datatypes, 3.5.7
SRX locks
LOCK Table statement, 2.4.1.3
state
package
definition, 7.10.6.1
session, package objects, 7.1.2.11
Web application
definition, 11.4.8
stateful and stateless user interfaces, definitions, 1.1
statement triggers
conditional code for statements, 9.3.1.4
row evaluation order, 9.2.5
specifying SQL statement, 9.2.3
timing, 9.2.4
trigger evaluation order, 9.2.5
UPDATE statements and, 9.2.3.2, 9.3.1.4
valid SQL statements, 9.3.4
storage allocation errors
resuming execution after, 2.8
stored functions, 7.1.2
creating, 7.1.2.3
restrictions, 7.10.1
stored procedure, definition, 7.1.2
stored procedures, 7.1.2
argument values, 7.8.6
creating, 7.1.2.3
distributed query creation, 7.6.3
exceptions, 7.6, 7.6.1
invoking, 7.8
names of, 7.1.2.1
overloading names of, 7.1.2.7
parameter
default values, 7.1.2.2.5
privileges, 7.8.5
remote, 7.9
remote objects and, 7.9.2
storing, 7.1.2.3
synonyms, 7.9.3
subnormal floating-point numbers, 3.3.2.1
synonyms
stored procedures and packages, 7.9.3
SYS_XMLAGG function, 3.5.5
SYS_XMLGEN function, 3.5.5
system events
attributes, 9.9.5
client, 9.9.6.2
resource manager, 9.9.6.1
tracking, 9.8

T

table, mutating
definition, 9.3.4
tables
constraining, 9.3.4
in PL/SQL, 7.1.2.2.4
mutating, 9.3.4
TCP/IP, 11.5.3
temporary and permanent LOB instances, 3.5.3
temporary segments
index creation and, 5.1.2
text search
using Oracle9i Text, 3.5.4
thread safety
managing with Oracle XA library, 15.3.7
time and date data
representing, 3.4
TIMESTAMP datatype, 3.4.1.1
TIMESTAMP WITH LOCAL TIME ZONE datatype, 3.4.1.1
TIMESTAMP WITH TIME ZONE datatype, 3.4.1.1
timestamps
PL/SQL library unit dependencies, 7.3
TO_DATE function, 3.4.2.1
trace files
produced by Oracle XA library, 15.4.1
tracking system events, 9.8
transaction manager (TM), 15.1.1
transaction processing monitor (TPM), 15.1.1
transaction set consistency
definition, 2.6.4.1
transaction, main
definition, 2.7
transactions
autonomous, 2.7, 2.7.2
committing, 2.1.3.1
read-only, 2.2
serializable, 2.6
SET TRANSACTION statement, 2.2
trigger
disabled
definition, 9.6
enabled
definition, 9.6
triggering statement
definition, 9.2.3
triggers
about, 7.1.2.15
accessing column values, 9.3.1
AFTER, 9.2.4, 9.3.1, 9.8, 9.8
auditing with, 9.8, 9.8
BEFORE, 9.2.4, 9.3.1, 9.8, 9.8
body, 9.3, 9.3.1.4, 9.3.1.5, 9.3.4
check constraints, 9.8, 9.8
client events, 9.9.6.2
column list in UPDATE, 9.2.3.2, 9.3.1.4
compiled, 9.4
conditional predicates, 9.3, 9.3.1.4
creating, 9.2, 9.3.4, 9.3.6
data access restrictions, 9.8
debugging, 9.5.1
designing, 9.1
disabling, 9.6, 9.6.2
distributed query creation, 7.6.3
enabling, 9.6, 9.6.1
error conditions and exceptions, 9.3.1.5
events, 9.2.3
examples, 9.8
firing, 9
FOR EACH ROW clause, 9.2.7
generating derived column values, 9.8
illegal SQL statements, 9.3.4
INSTEAD OF triggers, 9.2.6
integrity constraints vs., 9.8
integrity constraints vs., 9.1
listing information about, 9.7
modifying, 9.5
multiple same type, 9.2.5
mutating tables and, 9.3.4
naming, 9.2.2
package variables and, 9.2.4
privileges, 9.3.6
to drop, 9.5
procedures and, 9.3.4
recompiling, 9.4.2
REFERENCING option, 9.3.1.3
referential integrity and, 9.8
remote dependencies and, 9.3.4
remote exceptions, 9.3.3
resource manager events, 9.9.6.1
restrictions, 9.2.8, 9.3.4
row, 9.2.7
row evaluation order, 9.2.5
scan order, 9.2.5
stored, 9.4
system triggers, 9.2.1
on DATABASE, 9.2.1
on SCHEMA, 9.2.1
trigger evaluation order, 9.2.5
use of LONG and LONG RAW datatypes, 9.3.4
username reported in, 9.3.5
WHEN clause, 9.2.8
triggers on object tables, 9.3.2
TRUST keyword, 7.10.5.4.1
two-phase commit protocol
using with Oracle XA library, 15.1.1
TX interface, 15.1.1
type attribute, PL/SQL, 1.2.2.1

U

undo data, 10.1
unhandled exceptions, 7.6.2
UNINSTR function
support for Unicode character literals, 3.2.4
UNIQUE key constraints
combining with NOT NULL constraint, 6.1.6
composite keys and nulls, 6.1.8
disabling, 6.8.4
enabling, 6.8.3
PRIMARY KEY constraint vs., 6.1.8
when to use, 6.1.8
updatable view
definition, 9.2.6
UPDATE statement
column values and triggers, 9.3.1
data consistency, 2.4
triggers and, 9.2.3.2, 9.3.1.4
triggers for referential integrity, 9.8, 9.8
update, distributed
definition, 7.9.2
UPPER function, 5.4.1
URLs, 11.5.4
USER function, 6.1.5
user locks, requesting, 2.5
USER_CHANGE_NOTIFICATION_REGS initialization parameter, 13.4
USER_ERRORS view
debugging stored procedures, 7.5
USER_SOURCE view, 7.5
user-defined errors, 7.6, 7.6.1
usernames
as reported in a trigger, 9.3.5
UTL_HTTP package, 11.5.4
UTL_INADDR package, 11.5.2
UTL_SMTP package, 11.5.1
UTL_TCP package, 11.5.2
UTLLOCKT.SQL script, 2.5.3

V

V$GLOBAL_TRANSACTIONS view, 15.4.3
VARCHAR2 datatype, 3.2
column length, 3.2.2
VBScript
translating to PSP, 12.1.4
VERSIONS_ENDSCN pseudocolumn, 10.6
VERSIONS_ENDTIME pseudocolumn, 10.6
VERSIONS_OPERATION pseudocolumn, 10.6
VERSIONS_STARTSCN pseudocolumn, 10.6
VERSIONS_STARTTIME pseudocolumn, 10.6
VERSIONS_XID pseudocolumn, 10.6
views
containing expressions, 9.2.6.1
FLASHBACK_TRANSACTION_QUERY, 10.7
inherently modifiable, 9.2.6.1
modifiable, 9.2.6.1
pseudocolumns, 9.2.6.1

W

web services
overview, 1.3.6
using Oracle Database as a service provider, 1.3.6.1
WHEN clause, 9.2.8
cannot contain PL/SQL expressions, 9.2.8
correlation names, 9.3.1
examples, 9.2, 9.2.7, 9.8
EXCEPTION examples, 9.3.3, 9.8, 9.8, 9.8
WITH CONTEXT clause, 14.9.6.7
WNDS argument, 7.10.5.4
WNPS argument, 7.10.5.4

X

X locks
LOCK TABLE statement, 2.4.1.4
xa_close subroutine, 15.2.1
xa_commit subroutine, 15.2.1
xa_end subroutine, 15.2.1
xa_forget subroutine, 15.2.1
xa_open string, 15.3.3
xa_open subroutine, 15.2.1
xa_prepare subroutine, 15.2.1
xa_recover subroutine, 15.2.1
xa_rollback subroutine, 15.2.1
xa_start subroutine, 15.2.1
xaosterr function, 15.2.2
XML
searching with Oracle9i Text, 3.5.4
XML data
representing, 3.5.5
X/Open distributed transaction processing architecture, 15.1