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

passing parameters to C, 14.9

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

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