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