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

Symbols

%ROWTYPE attribute, 6.1.2.2.3

%TYPE attribute, 6.1.2.2.3

Numerics

32-bit IEEE 754 format, 2.3.1

3GL (third-generation language), 6.7.4

64-bit IEEE 754 format, 2.3.1

A

Abstract Data Type (ADT)

editions and, 19.1.1.2

resetting evolved, 19.1.1.3

Active Server Pages (ASP), 10.4

actual object, 19.1.3

actualization

in general, 19.1.3

schema object dependency and, 19.1.3.2

address of row (rowid), 2.7

ADT

editions and, 19.1.1.2

resetting evolved, 19.1.1.3

agent, 16.3

Agent Control Utility (agtctl)

commands

in shell mode, A.3.3

in single-line mode, A.3.2

list of, A.3.1

extproc administration and, A.3

extproc architecture and, A.2

aggregate function, 6.11

altering application online

See edition-based redefinition

ancestor edition, 19.1.2

anonymous block, 6.1.1

ANSI isolation level

See isolation level

ANSI/IDO data types, 2.5.7

AnyData data type, 2.5.6

AnyDataSet data type, 2.5.6

AnyType data type, 2.5.6

AP (application program), 15.1.1

application architecture, 13.1

application program (AP), 15.1.1

application SQL, 19.3.3.2.3

APPLYING_CROSSEDITION_TRIGGER function, 19.3.4.1.2

AQ (Oracle Advanced Queuing), 16.2.2

B

backward compatibility

LONG and LONG RAW data types for, 2.2.1

RESTRICT_REFERENCES pragma for, 6.9.4.4

BATCH commit redo option, 1.3.4

BFILE data type, 2.5.3

binary format, 2.3.2.1

binary large object (BLOB) data type, 2.5.3

binary number, 2.3.2

binary ROWID, 2.7.2.3

BINARY_DOUBLE data type, 2.3.1

BINARY_FLOAT data type, 2.3.1

BLOB data type, 2.5.3

block, anonymous, 6.1.1

branch, 15.1.1

built-in function

display type of, 2.9

in regular expression, 3.1.3

metadata for, 2.9, 2.9

bulk binding

overview of, 6.1.2.14

when to use, 6.1.2.15

C

C external subprogram

callback with, 14.13

global variable in, 14.13.6

interface between PL/SQL and, 14.5.2

invoking, 14.10.4

loading, 14.4.2

passing parameter to, 14.9

publishing, 14.7

running, 14.10

service routine and, 14.12

D

data integrity

See constraint

data type

ANSI/ISO, 2.5.7

DB2, 2.5.7

dynamic, 2.5.6

external, 2.1

family of, 2.9

for character data, 2.2

for date and time data, 2.4

for numeric data, 2.3

for specialized data, 2.5

object, 13.11.3

of formal subprogram parameter, 6.1.2.2.2

overview of, 2.1

SQL/DS, 2.5.7

data type class, 18.10.2.4

data type conversion

in general, 2.8

of ANSI data types, 2.5.7

of ANSI/ISO data types, 2.5.7

of date and time data types, 2.4.6

of DB2 data types, 2.5.7

of native floating-point data types, 2.3.5

of SQL/DS data types, 2.5.7

date and time data types

arithmetic operations with, 2.4.5

converting, 2.4.6

exporting, 2.4.7

importing, 2.4.7

overview of, 2.4.1

DATE data type, 2.4.1

date data type class, 18.10.2.4

date format

changing default, 2.4.3

default, 2.4.2

DB2 data types, 2.5.7

DBMS_DEBUG package, 6.6.8

DBMS_DEBUG_JDWP package, 6.6.7

DBMS_FLASHBACK package, 12.8

DBMS_FLASHBACK.TRANSACTION_BACKOUT procedure, 12.9

DBMS_HPROF package, 8.2

DBMS_LOCK package, 1.7

DBMS_OUTPUT package, 6.6.4

DBMS_PARALLEL_EXECUTE package, 19.3.5

DBMS_STATS package, 12.12

DBMS_TYPES package, 2.5.6

DBMS_XA package, 15.3.10

deadlock, undetected, 1.7

debugging

PL/SQL Server Pages, 10.10

subprograms, 6.6

decimal number, 2.3.2

default column value

setting, 5.1.6

when to use, 5.1.5

default subprogram parameter value, 6.1.2.2.5

deferring constraint checks, 5.2.4

definer's-rights subprogram, 6.7.1

denormal floating-point number, 2.3.2.1

dependent object

See schema object dependency

dependent transaction, 12.9.1

DESC keyword, 4.5.1

descendent edition, 19.1.2

DETERMINISTIC function

in general, 6.9.4.2

index and, 4.5.2

RPC signature and, 18.10.2

disabling constraint

effect of, 5.8

existing, 5.8.5

new, 5.8.3

reasons for, 5.8.1

dispatcher thread, A.2

distributed database

FOREIGN KEY constraint and, 5.5

remote dependency management and, 18.9

distributed query, run-time error in, 6.5.3

distributed transaction

how it works, 6.8.2

what it is, 15.1.1

DML statement

bulk binding for, 6.1.2.15.1

parallel, 6.9.4.3

processing, 1.1

that references collection, 6.1.2.15.1

DML_LOCKS initialization parameter, 1.6, 1.6

domain index, 4.4

drivers, Oracle JDBC, 13.4.2.1

DROP INDEX statement, 4.2.7

DTP (X/Open Distributed Transaction architecture), 15.1

dynamic registration, 15.1.1

dynamic SQL statement, 6.9.4.4.2

dynamically typed data, 2.5.6

E

edition

ancestor, 19.1.2

creating, 19.1.2

crossedition triggers and, 19.3.3

current, 19.1.6

descendent, 19.1.2

displaying information about, 19.4

enabling for a user, 19.1.1.3

leaf, 19.1.2

making available

to all users, 19.1.5

to some users, 19.1.4

ora$base, 19.1, 19.1.2

retiring, 19.1.7

root, 19.1.2

session, 19.1.6

visibility of trigger in, 19.3.3.1

what it is, 19.1

editionable schema object type, 19.1.1.1

edition-based redefinition, 19

editioned object, 19.1.1

editioning view

auditing policy and, 19.5.1

changing base table of, 19.2.5

changing write-ability of, 19.2.3

covering table with, 19.5.1

creating, 19.2.1

displaying information about, 19.4

partition-extended name for, 19.2.2

preparing application for, 19.5.1

read-only, 19.2.1

read-write, 19.2.1

replacing, 19.2.4

SQL optimizer hint and, 19.2.7

what it is, 19.2

editions-enabled user, 19.1.1.3

Electronic Product Code (EPC), 17.7.2.1

embedded PL/SQL gateway

how to use, 9.4

what it is, 9.2.1.2

enabling constraint

effect of, 5.8

existing, 5.8.4

new, 5.8.2

enabling editions for a user, 19.1.1.3

encoding scheme, adding, 17.3.4

enforcing business rules

with application logic, 5.1.2

with constraints, 5.1.1

environment, programming, 13

EPC (Electronic Product Code), 17.7.2.1

error handling

compile-time

for multilanguage program, 14.11

in general, 6.4

run-time

See run-time error handling

evolved Abstract Data Type (ADT)

resetting, 19.1.1.3

exception

IEEE 754 format

not raised, 2.3.2.2

raised during conversion, 2.3.5

in multilanguage program, 14.11

to constraint, 5.8.7

unhandled, 6.5.2

user-defined, 6.5.1

F

families of data types, 2.9

fine-grained auditing (FGA) policy, editioning view and, 19.5.1

fine-grained invalidation, 18.4

firing order of triggers, 19.3.3.3

FIXED_DATE initialization parameter, 2.4.2

Flashback Data Archive, 12.10

Flashback Transaction, 12.9

FLASHBACK_TRANSACTION_QUERY view, 12.5

floating-point data type

See native floating-point data type

floating-point number format, 2.3.2

FOR loop

bulk binding for, 6.1.2.15.3

that references collection, 6.1.2.15.3

FORCE option of ALTER USER statement, 19.1.1.3

FOREIGN KEY constraint

composite, 5.2

distributed databases and, 5.5

dropping, 5.11

editioned view and, 19.1.1.2

enabling, 5.12

Flashback Transaction and, 12.9.1

indexing, 5.4

multiple, 5.2.3

naming, 5.7.2

NOT NULL constraint on, 5.2.2, 5.2.2

NULL value and, 5.2.1

privileges needed to create, 5.12.4

referential integrity enforced by, 5.12.5

UNIQUE constraint on, 5.2.2, 5.2.2

without other constraints, 5.2.2

foreign key dependency, 12.9.1

foreign rowid, 2.7.3

formal subprogram parameter, data type of, 6.1.2.2.2

forward crossedition trigger, 19.3.1

forward crossedition trigger SQL, 19.3.3.2.1

function

aggregate, 6.11

built-in

See built-in function

controlling side effects of, 6.9.4

DETERMINISTIC

in general, 6.9.4.2

index and, 4.5.2

RPC signature and, 18.10.2

invoking from SQL statement, 6.9

MGD_ID ADT, 17.3.3

OCI or OCCI, 13.7.2

overloaded, 6.9.4.4.3

PARALLEL_ENABLE, 6.9.4.2

in general, 6.9.4.2

RPC signature and, 18.10.2

purity of

in general, 6.9.4

RPC signature and, 18.10.2

result-cached, 6.1.2.7

returning large amount of data from, 6.10

SQL

See built-in function

G

Geographic Information System (GIS) data, 2.5.1

global transaction, 15.1.1

global variable, in C external subprogram, 14.13.6

group commit, 1.3.4

H

hierarchical profiler, 8

host language, 13.6

host program, 13.6

hot rollover

what it is, 19

HTML syntax error in PSP script, 10.5.1.3

I

IA-32 and IA-64 instruction set architecture, 2.3.4

IBM CICS, 15.1.1

IBM Transarc Encina, 15.1.1

Identity Code Package, 17

IEEE 754 format

exception

not raised, 2.3.2.2

raised during conversion, 2.3.5

OCI support for, 2.3.6.1

overview of, 2.3.1

special values supported by, 2.3.2.2

IGNORE_ROW_ON_DUPKEY_INDEX hint, 19.3.4.1.2

IMMEDIATE commit redo option, 1.3.4

IN OUT subprogram parameter mode, 6.1.2.2.1

IN subprogram parameter mode, 6.1.2.2.1

independent transaction, 1.9

index

application-specific, 4.2

composite, 4.2.5

creating

examples of, 4.3

for cluster, 4.2.1

for table, 4.2.1

privileges needed for, 4.1

temporary table space for, 4.2.2

with SQL*Loader, 4.2.2

domain, 4.4

dropping, 4.2.7

edition-based redefinition and, 19.2.6

function-based

examples of, 4.5.3

what it is, 4.5

on MGD_ID column, 17.3.2

overhead for, 4.2.4

statistics for, 4.2.6

where to put, 4.2.3

infinity, 2.3.2.2, 2.3.2.2

inherited object, 19.1.3

dropping, 19.1.3.1

initialization parameter

DML_LOCKS, 1.6

FIXED_DATE, 2.4.2

OPEN_CURSORS, 1.5.1

integer data type class, 18.10.2.4

integrity of data

See constraint

interface

between PL/SQL and C, 14.5.2

between PL/SQL and Java, 14.5.1

OraDatabase, 13.11.2.3

program, 13.2

TX, 15.1.1

user

stateful or stateless, 13.2.2

what it is, 13.2.1

J

Java class method

calling, 14.10.3

interface between PL/SQL and, 14.5.1

loading, 14.4.1

publishing, 14.6

K

key

foreign

See FOREIGN KEY constraint

primary

See PRIMARY KEY constraint

referential integrity

See FOREIGN KEY constraint

unique

See UNIQUE constraint

L

large object (LOB) data types

list of, 2.5.3

Oracle Objects for OLE support for, 13.11.3

leaf edition, 19.1.2

LGWR (log writer process), 1.3.4, 1.3.4

lightweight queue, 16.3

loadpsp utility, 10.6

LOB (large object) data types

list of, 2.5.3

Oracle Objects for OLE support for, 13.11.3

LOCK TABLE statement, 1.6.2

locking row explicitly, 1.6.4

locking table

explicitly, 1.6

implicitly, 1.6.3

log writer process (LGWR), 1.3.4

logical rowid, 2.7.3

LONG RAW data type, 2.5.3

loose coupling, 15.1.1

LOWER function, 4.5.1

M

main transaction, 1.9

maximum availability of table, 19.2.1

metacharacter in regular expression, 3.2

metadata for built-in function, 2.9

MGD_ID ADT, 17.1

MGD_ID database ADT function, 17.3.3

mod_plsql module, 9.2.1.1

mode, parameter, 6.1.2.2.1

MODIFY CONSTRAINT clause of ALTER TABLE statement, 5.9

modifying

See altering

monitor thread, A.2

multilanguage program

error or exception in, 14.11

overview of, 14.1

multilingual extensions to POSIX standard, 3.2.2

multimedia data, 2.5.2

multithreaded extproc agent, A

N

name resolution

editions and, 19.1.3.2

in general, 18.7

NaN (not a number), 2.3.2.2

national character large object (NCLOB) data type, 2.5.3

native execution, compiling subprogram for, 6.2

native floating-point data type

arithmetic operation with, 2.3.4

binary format for, 2.3.2.1

clients that support, 2.3.6

comparison operator for, 2.3.3

conversion functions for, 2.3.5

rounding, 2.3.2

special values for, 2.3.2.2

what it is, 2.3.1

NCLOB data type, 2.5.3

negative infinity, 2.3.2.2

negative zero, 2.3.2.2

new features, Preface

NLSSORT function, 4.5.1

noneditionable schema object type, 19.1.1.1

noneditioned object, 19.1.1

nonpersistent queue, 16.3

normalized floating-point number, 2.3.2.1

NOT NULL constraint

compared to CHECK constraint, 5.6.4

naming, 5.7.2

on FOREIGN KEY constraint, 5.2.2, 5.2.2

when to use, 5.1.4

NOWAIT commit redo option, 1.3.4

NOWAIT option of LOCK TABLE statement, 1.6.2

NULL value and FOREIGN KEY constraint, 5.2.1

number

binary, 2.3.2

decimal, 2.3.2

rounding, 2.3.2

NUMBER data type, 2.3.1

number data type class, 18.10.2.4

numeric data types overview, 2.3.1

O

object

actual, 19.1.3

dependent

See schema object dependency

editioned, 19.1.1

inherited, 19.1.3

dropping, 19.1.3.1

large, 2.5.3

noneditioned, 19.1.1

potentially editioned, 19.1.1

referenced

See schema object dependency

size limit for PL/SQL stored, 6.1.2.9

object change notification, 11.1

object data type, 13.11.3

object type

See schema object type

OCCI

See Oracle C++ Call Interface

OCI

See Oracle Call Interface

ODC (Oracle Data Control), 13.11.4

ODP.NET, 13.9

online application upgrade

See edition-based redefinition

OO4O

See Oracle Objects for OLE

OPEN_CURSORS initialization parameter, 1.5.1

optimizer

editioning view and, 19.2.7

function-based index and, 4.5.1

RPC signature and, 18.10.2

ora$base edition, 19.1, 19.1.2

ORA_ROWSCN pseudocolumn, 12.7

Oracle Advanced Queuing (AQ), 16.2.2

Oracle C++ Call Interface

building application with, 13.7.4

kinds of functions in, 13.7.2

overview of, 13.7

procedural and nonprocedural elements of, 13.7.3

Oracle Call Interface

building application with, 13.7.4

commit redo action in, 1.3.4

compared to precompiler, 13.8

kinds of functions in, 13.7.2

overview of, 13.7

procedural and nonprocedural elements of, 13.7.3

with Oracle XA, 15.3.5

Oracle Data Control (ODC), 13.11.4

Oracle Data Provider for .NET, 13.9

Oracle Database package

for writing low-level debugging code, 6.6.6

in general, 6.1.2.13

run-time error raised by, 6.5

Oracle Expression Filter, 2.6

Oracle Flashback Query, 12.3

Oracle Flashback Technology

application development features, 12.1.1

configuring database for, 12.2

database administration features, 12.1.2

overview of, 12.1

performance guidelines for, 12.12

Oracle Flashback Transaction Query, 12.5

Oracle Flashback Version Query, 12.4

Oracle JDBC

compared to Oracle SQLJ, 13.4.4

overview of, 13.4.2

sample program

2.0, 13.4.2.2

pre-2.0, 13.4.2.3

Oracle JDeveloper

in general, 6.6.3

Oracle SQLJ and, 13.4.3.1

Oracle JPublisher, 13.4.5

Oracle JVM, 13.4.1

Oracle Lock Management services, 1.7

Oracle Multimedia, 2.5.2

Oracle Objects for OLE

Automation Server, 13.11.1

C++ Class Library, 13.11.5

object data type support, 13.11.3

object model, 13.11.2

overview of, 13.11

Oracle RAC and Oracle XA, 15.5.3

Oracle SQLJ

compared to Oracle JDBC, 13.4.4

Oracle JDeveloper and, 13.4.3.1

overview of, 13.4.3

Oracle Text, 2.5.4

Oracle Total Recall, 12.10

Oracle Tuxedo, 15.1.1

Oracle Virtual Private Database (VPD) policy, editioning view and, 19.5.1

Oracle XA

Oracle RAC and, 15.5.3

subprograms, 15.2

when to use, 15

OUT subprogram parameter mode, 6.1.2.2.1

out-of-space error, 1.10

overloaded subprogram, 6.1.2.8

P

package

advantages of, 6.1.2.8

body of, 6.1.2.8

creating, 6.1.2.10

invalidation of, 6.1.2.12

naming, 6.1.2.11

Oracle Database

for writing low-level debugging code, 6.6.6

in general, 6.1.2.13

run-time error raised by, 6.5

privileges needed to create, 6.1.2.10.2

privileges needed to drop, 6.1.2.10.2

session state and, 18.4.1

size limit for, 6.1.2.9

specification of, 6.1.2.8

synonym for, 6.8.1

what it is, 6.1.2.8

package invalidation and, 6.1.2.12

package subprogram, 6.1.2

parallel DML statement, 6.9.4.3

parallel query, 6.9.4.3

PARALLEL_ENABLE function

in general, 6.9.4.2

RPC signature and, 18.10.2

parameter

initialization

See initialization parameter

subprogram

See subprogram parameter

parameter mode, 6.1.2.2.1

partition-extended editioning view name, 19.2.2

PERL-influenced extensions to POSIX standard, 3.2.3

persistent LOB instance, 2.5.3

persistent queue, 16.3

PL/Scope tool, 7

plshprof utility, 8.5

PL/SQL function result cache, 6.1.2.7

PL/SQL gateway, 9.2.1

PL/SQL hierarchical profiler, 8

PL/SQL language

compared to Java, 13.5

overview of, 13.3

PL/SQL object

CREATE OR REPLACE and, 18.4

PL/SQL Server Pages

characteristics of, 10.5.1

elements of, 10.5

loading, 10.6

script error in, 10.5.1.3

PL/SQL unit

stored, 6.1.2

what it is, 6.1

PL/SQL Web Toolkit, 9.2.2

pool, connection, 13.6.1

positive infinity, 2.3.2.2

positive zero, 2.3.2.2

POSIX metacharacter in regular expression, 3.2.1

POSIX standard

extensions to

multilingual, 3.2.2

PERL-influenced, 3.2.3

in regular expression, 3.1.4

potentially editioned object, 19.1.1

precompiler

compared to Oracle Call Interface, 13.8

Oracle XA and, 15.3.4

overview of, 13.6

PRIMARY KEY constraint

dropping, 5.11

Flashback Transaction and, 12.9.1

in general, 5.1.7

naming, 5.7.2

primary key dependency, 12.9.1

privileges

for creating indexes, 4.1

for creating package, 6.1.2.3

for creating subprogram, 6.1.2.3

for debugging subprogram, 6.6.5

for defining constraint, 5.7.1

for dropping package, 6.1.2.5

for dropping packages, 6.1.2.10.2

for dropping subprogram, 6.1.2.5

for Oracle Flashback Technology, 12.2.5

for running subprogram, 6.7.1

revoked, object dependency and, 18.4.2

Pro*C/C++ precompiler

native floating-point data type support in, 2.3.6.3

overview of, 13.6.1

Pro*COBOL precompiler, 13.6.2

procedure

PL/SQL Server Pages and, 10.5.3

Q

quality-of-service flag, 11.6.6.2

query

parallel, 6.9.4.3

registering for Continuous Query Notification, 11.6

run-time error in distributed, 6.5.3

query result change notification, 11.2

queue, 16.3

R

Radio Frequency Identification (RFID) technology, 17.7.1

RAISE statement, 6.5.1

RAW data type, 2.5.3

raw data type class, 18.10.2.4

read consistency, 1.6

statement-level, 1.4

transaction-level

locking tables explicitly for, 1.6

read-only transaction for, 1.4

what it is, 1.4

read-only editioning view, 19.2.1

read-only transaction, 1.4

read-write editioning view, 19.2.1

redefinition, edition-based, 19

redo information for transaction, 1.3.4

redo management, 1.3.4

referenced object

See schema object dependency

referential integrity and serializable transaction, 1.8.3

referential integrity key

See FOREIGN KEY constraint

REGEXP_COUNT function, 3.1.3

REGEXP_INSTR function, 3.1.3

REGEXP_LIKE condition, 3.1.3

REGEXP_REPLACE function, 3.1.3

REGEXP_SUBSTR function, 3.1.3

registration

dynamic, 15.1.1

for Continuous Query Notification, 11.6

in publish-subscribe model, 16.3

static, 15.1.1

regular expression

built-in function in, 3.1.3

condition in, 3.1.3

in SQL statement, 3.3

metacharacter in, 3.2

Oracle implementation of, 3.1.3

POSIX standard support in, 3.1.4

what it is, 3.1.1

relational operators, 2.3.3

remote dependency management, 18.9

remote procedure call dependency management, 18.10

repeatable read

read-only transaction for, 1.4

what it is, 1.4

repeatable reads

locking tables explicitly for, 1.6

required public information, 15.1.2

rerunning SQL statement, 1.5.2

resource manager (RM), 15.1.1

RESTRICT_REFERENCES pragma

for backward compatibility, 6.9.4.4

overloaded functions and, 6.9.4.4.3

static and dynamic SQL statements and, 6.9.4.4.2

restricted ROWID, 2.7.2.1

result cache, 6.1.2.7

resumable storage allocation, 1.10

RETENTION GUARANTEE clause for undo tablespace, 12.2.1

RETENTION option of ALTER TABLE statement, 12.2.4

reverse crossedition trigger, 19.3.2

reverse crossedition trigger SQL, 19.3.3.2.2

RFID (Radio Frequency Identification) technology, 17.7.1

RM (resource manager), 15.1.1

ROLLBACK statement, 1.3.5

rolling back transaction, 1.3.5

root edition, 19.1.2

rounding floating-point numbers, 2.3.2

routine

See subprogram

row

address of (rowid), 2.7

locking explicitly, 1.6.4

ROW EXCLUSIVE MODE option of LOCK TABLE statement, 1.6.2.1, 1.6.2.1

ROW SHARE MODE option of LOCK TABLE statement, 1.6.2.1

rowid

foreign, 2.7.3

in general, 2.7

logical, 2.7.3

universal (urowid), 2.7.3

ROWID data type, 2.7.2

ROWID pseudocolumn

CQN and, 11.6.2.3

in general, 2.7

S

SAVEPOINT statement, 1.3.6, 1.3.6

schema object dependency

actualization and, 19.1.3.2

in distributed database, 18.9

in general, 18

invalidation and, 18.4

on nonexistence of other objects, 18.7

revoked privileges and, 18.4.2

shared pool and, 18.11

schema object type

editionable, 19.1.1.1

noneditionable, 19.1.1.1

scrollable cursor, 1.5.3

searchable text, 2.5.4

SELECT statement

bulk binding for, 6.1.2.15.2

referencing collection with, 6.1.2.15.2

with AS OF clause, 12.3

with FOR UPDATE clause, 1.6.4

with VERSIONS BETWEEN clause, 12.4

semi-available table, 19.2.1

serendipitous change

data transformation collisions and, 19.3.4.1.2

identifying, 19.3.4.1.2

what it is, 19.3.4.1, 19.3.5

serializable transaction

for concurrency control, 1.8

isolation level of, 1.8.2

referential integrity and, 1.8.3

server-side programming, 13.1.2

service routine, C external subprogram and, 14.12

session edition, 19.1.6

session state, 18.4.1

session variable, 6.7.2

SET CONSTRAINTS statement, 5.2.4

SET TRANSACTION statement

with READ ONLY option, 1.4

SHARE MODE option of LOCK TABLE statement, 1.6.2.2

SHARE ROW EXCLUSIVE MODE option of LOCK TABLE statement, 1.6.2.3

shared SQL area, 1.1

side effects of function, controlling, 6.9.4

signature checking, 18.9.1

spatial data, 2.5.1

SQL area, shared, 1.1

SQL data type

See data type

SQL function

See built-in function

SQL optimizer hint and editioning view, 19.2.7

SQL statement

application, 19.3.3.2.3

character literal in, 2.2.4

crossedition trigger

forward, 19.3.3.2.1

reverse, 19.3.3.2.2

dynamic, 6.9.4.4.2

invoking PL/SQL function from, 6.9

processing

DDL statement, 1.2.1

DML statement, 1.1

stages of, 1.1

system management statement, 1.2.3

transaction control statement, 1.2.2

transaction management statement, 1.2.3

rerunning, 1.5.2

static, 6.9.4.4.2

transaction control, 1.2.2

SQL*Loader, creating index with, 4.2.2

SQL/DS data types, 2.5.7

SQLJ

See Oracle SQLJ

SQLT_BDOUBLE data type, 2.3.6.1

SQLT_BFLOAT data type, 2.3.6.1

standalone subprogram, 6.1.2

state

session, 18.4.1

user interface and, 13.2.2

web application and, 9.6.8

statement

See SQL statement

statement-level read consistency, 1.4, 1.6

static registration, 15.1.1

static SQL statement, 6.9.4.4.2

static variable, in C external subprogram, 14.13.7

statistics

for application, 8

for identifier, 7

for index, 4.2.6

storage allocation error, 1.10

stored PL/SQL unit, 6.1.2

subnormal floating-point number, 2.3.2.1

subprogram

compiling for native execution, 6.2

creating, 6.1.2.3

definer's-rights, 6.7.1

editioned, 19.1.1.2

exception-handling, 6.5.1

external

See external subprogram

invoker's-rights, 6.7.1

invoking

See invoking subprogram

naming, 6.1.2.1

Oracle XA, 15.2

overloaded, 6.1.2.8

package, 6.1.2

parameter of

See subprogram parameter

privileges needed to debug, 6.6.5

privileges needed to run, 6.7.1

remote, 6.5.4

size limit for, 6.1.2.9

standalone, 6.1.2

synonym for, 6.8.1

T

table

locking

choosing strategy for, 1.6.2

explicitly, 1.6

implicitly, 1.6.3

with maximum availability, 19.2.1

with semi-availability, 19.2.1

Tag Data Translation Markup Language Schema, 17.1

task thread, A.2

temporary LOB instance, 2.5.3

temporary table space, 4.2.2

thin client configuration, 13.1.3

third-generation language (3GL), 6.7.4

thread

dispatcher, A.2

monitor, A.2

Oracle XA library, 15.3.9

task, A.2

three-tier architecture, 13.1.3

tight coupling, 15.1.1

time data types

See date and time data types

time stamp checking, 18.9.1

time, changing default format of, 2.4.4

TIMESTAMP data type, 2.4.1

time-stamp dependency mode, 18.10.1

TIMESTAMP WITH LOCAL TIME ZONE data type, 2.4.1

TIMESTAMP WITH TIME ZONE data type, 2.4.1

TM (transaction manager), 15.1.1

TPM (transaction processing monitor), 15.1.1

transaction

autonomous, 1.9

choosing isolation level for, 1.8.4.3

committing, 1.3.3

controlling, 1.2.2

dependent, 12.9.1

distributed

how it works, 6.8.2

what it is, 15.1.1

global, 15.1.1

grouping operations into, 1.3.1

improving performance of, 1.3.2

independent, 1.9

main, 1.9, 1.9

read-only, 1.4

redo entry for, 1.3.4

rolling back, 1.3.5

savepoints for, 1.3.6

serializable, 1.8.2

set consistency of, 1.8.4.1

statements in, 1.3.6

transaction control statement, 1.2.2

transaction management statement, 1.2.3

transaction manager (TM), 15.1.1

transaction processing monitor (TPM), 15.1.1

transaction-level read consistency

locking tables explicitly for, 1.6

read-only transaction for, 1.4

what it is, 1.4

transform

applying, 19.3.5

what it is, 19.3.1

trigger

crossedition

See crossedition trigger

in edition

firing order of, 19.3.3.3

visibility of, 19.3.3.1

what kind can fire, 19.3.3.2

invoking subprogram from, 6.7.3

size limit for, 6.1.2.9

what it is, 6.1.2.16

TRUST keyword in RESTRICT_REFERENCES pragma, 6.9.4.4.1

two-phase commit protocol, 15.1.1

two-tier architecture, 13.1.3

TX interface, 15.1.1

type attribute, 6.1.2.2.3

U

undetected deadlock, 1.7

undo data, 12.1

UNDO_RETENTION parameter, 1.4

undoing transaction, 1.3.5

unhandled exception, 6.5.2

UNIQUE constraint

crossedition trigger and, 19.3.4.1.2

dropping, 5.11

naming, 5.7.2

on FOREIGN KEY constraint, 5.2.2, 5.2.2

when to use, 5.1.8

universal rowid (urowid), 2.7.3

upgrading applications online

See edition-based redefinition

UPPER function, 4.5.1

UROWID data type, 2.7.3

user interface

stateful and stateless, 13.2.2

what it is, 13.2.1

user lock, 1.7

user-defined exception, 6.5.1

user-defined type, as subprogram parameter, 6.1.2.2.4

UTLLOCKT.SQL script, 1.7.2

V

VARCHAR data type class, 18.10.2.4

VARCHAR2 data type

compared to CHAR data type, 2.2.3

specifying length of, 2.2.2

variable

cursor

See cursor variable

in C external subprogram

global, 14.13.6

static, 14.13.7

VERSIONS_ENDSCN pseudocolumn, 12.4

VERSIONS_ENDTIME pseudocolumn, 12.4

VERSIONS_OPERATION pseudocolumn, 12.4

VERSIONS_STARTSCN pseudocolumn, 12.4

VERSIONS_STARTTIME pseudocolumn, 12.4

VERSIONS_XID pseudocolumn, 12.4

view

constraint on, 5.1.9

editioned

FOREIGN KEY constraint and, 19.1.1.2

materialized view and, 19.1.1.2

editioning

See editioning view

VPD policy, editioning view and, 19.5.1

W

WAIT commit redo option, 1.3.4

WAIT option of LOCK TABLE statement, 1.6.2, 1.6.2

web application

implementing, 9.2

overview of, 9.1

state and, 9.6.8

web page

X

xa_open string, 15.3.3

XML data, 2.5.5

XMLType data type, 2.5.5

X/Open Distributed Transaction architecture, 15.1

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

Y

YY date format element, 2.4.3

Z

zero, IEEE 754 representation of, 2.3.2.2