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

Numerics

32-bit IEEE 754 format, 7.3.2

64-bit IEEE 754 format, 7.3.2

A

Abstract Data Type (ADT), 11.4.4.3

native floating-point data types in, 7.3.7

resetting evolved, 24.1.1.4.2

ACCESSIBLE BY clause

in package specification, 11.2

stored subprogram and, 11.1

actual object, 24.1.3

actualization, 24.1.3

ADDM (Automatic Database Diagnostic Monitor), 2.3.1

address of row (rowid), 7.6

administrators, restricting with Oracle Database Vault, 3.3

ADT

See Abstract Data Type (ADT)

AFTER SUSPEND trigger, 6.9.2.1

agent, 20.3

aggregate function, 11

altering application online

See edition-based redefinition (EBR)

analytic function, 1.9.1

ancestor edition, 24.1.2

ANSI data type, 7.5.7

ANYDATA data type, 7.5.6

ANYDATASET data type, 7.5.6

AP (application program), 19.1.1

application architecture, 17.1

application continuity, 26

application domain index, 9.3

application program (AP), 19.1.1

application SQL, 24.3.3.2.3

APPLYING_CROSSEDITION_TRIGGER function, 24.3.4.1.1

AQ (Oracle Advanced Queuing), 20.2.2

B

backward compatibility

LONG and LONG RAW data types for, 7.5.3.2

RESTRICT_REFERENCES pragma for, 11.9.4.3

BATCH commit redo option, 6.2.3

benchmark, 2.1.3

BFILE data type, 7.5.3.1

binary floating-point number, 7.3.2

binary format, 7.3.2.1

binary large object (BLOB) data type, 7.5.3.1

BINARY_DOUBLE data type, 7.3

BINARY_FLOAT data type, 7.3

BINARY_INTEGER data type

See PLS_INTEGER data type

bind variable, 2.6

BLOB data type, 7.5.3.1

block, PL/SQL, 11.1

blocking DDL statement, 6.7

BOOLEAN data type, 11.4.4.1.2

branch, 19.1.1

built-in data type

See SQL data type

built-in function

See SQL function

bulk binding, 11.4.8

business rule, 10

C

C external subprogram

callback with, 18.13

global variable in, 18.13.6

interface between PL/SQL and, 18.5.2

invoking, 18.10.4

loading, 18.4

passing parameter to, 18.9

publishing, 18.7

running, 18.10

service routine and, 18.12

D

data cartridge, 1.3.1

data definition language statement

See DDL statement

data integrity, 10

data type and, 7.1.1

E

EBR (edition-based redefinition), 24

edition, 24.1

ancestor, 24.1.2

creating, 24.1.2

crossedition triggers and, 24.3.3

current, 24.1.6

descendent, 24.1.2

displaying information about, 24.4.1

dropping, 24.1.8

enabling for user and types, 24.1.1.4

evaluation

See evaluation edition

leaf, 24.1.2

making available

to all users, 24.1.5

to some users, 24.1.4

ora$base, 24.1, 24.1.2

retiring, 24.1.7

root, 24.1.2

scope of, 24.1

session, 24.1.6

unusable

See unusable edition

visibility of trigger in, 24.3.3.1

EDITIONABLE property, 24.1.1.5

editionable schema object type, 24.1.1.3

edition-based redefinition (EBR), 24

editioned object, 24.1.1

creating or replacing, 24.1.1.5.1

name resolution and, 24.1.1.1

editioning view, 24.2

auditing policy and, 24.5.1

changing base table of, 24.2.5

changing writability of, 24.2.3

covering table with, 24.5.1

creating, 24.2.1

displaying information about, 24.4.2

partition-extended name for, 24.2.2

preparing application for, 24.5.1

read-only, 24.2.1

read-write, 24.2.1

replacing, 24.2.4

scope of, 24.1

SQL optimizer hint and, 24.2.7

Electronic Product Code (EPC), 22.7.2.1

embedded PL/SQL gateway, 14.2.1.2

how to use, 14.4

enabling constraint

effect of, 10.14

existing, 10.14.4

new, 10.14.2

enabling editions, 24.1.1.4

encoding scheme, adding, 22.3.4

environment, programming, 17

EPC (Electronic Product Code), 22.7.2.1

evaluation edition, 24.1.1.2

dropping edition and, 24.1.8

for materialized view, 24.1.1.2.1

for virtual column, 24.1.1.2.2

retiring edition and, 24.1.7

exception

IEEE 754 standard

not raised, 7.3.3

raised during conversion, 7.3.6

in multilanguage program, 18.11

to constraint, 10.14.7

exception handling, 5.5

for storage allocation error, 6.9

EXCLUSIVE MODE option of LOCK TABLE statement, 6.4.2.4

EXECUTE privilege, 11.4.1

execution plan, 2.2.3

data type and, 7.1.3

EXPLAIN PLAN statement, 2.2.3

explicit cursor, 11.4.5

EXPR data type, 7.7.2

expression

index built on

See function-based index

regular

See regular expression

extensibility, 1.3

external data type, 7

external large object (BFILE) data type, 7.5.3.1

external subprogram, 18.2

call specification for, 18.3

debugging, 18.13.4

loading, 18.4

managing for applications, 3.5

publishing, 18.5

external transaction manager, 19.1.1

F

family of data types

PL/SQL, 11.4.4.1

SQL, 7.7.3

FAN event, load balancing advisory, 2.13.3

Fast Application Notification (FAN), 2.13.1

fine-grained access control, 3.3

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

fine-grained invalidation, 23.4

firing order of triggers, 24.3.3.3

FIXED_DATE initialization parameter, 7.4.1

fixed-point data type, 7.3

Flashback Data Archive, 16.9

Flashback Transaction, 16.8

FLASHBACK_TRANSACTION_QUERY view, 16.5

FLOAT data type, 7.3

floating-point data type, 7.3

range and precision of, 7.3.2

See also native floating-point data type

floating-point number

binary, 7.3.2

components of, 7.3.1

decimal, 7.3.2

denormal, 7.3.2.1

format of, 7.3.2

rounding, 7.3.2

subnormal, 7.3.2.1

FOR loop

bulk binding for, 11.4.8.3

that references collection, 11.4.8.3

FORCE option of ALTER USER statement, 24.1.1.4.1

FOREIGN KEY constraint, 10.8

distributed databases and, 10.11

dropping, 10.17

editioned view and, 24.1.1.6

enabling, 10.18

Flashback Transaction and, 16.8.1

indexing, 10.10

multiple, 10.8.3

naming, 10.13.2

NOT NULL constraint on, 10.8.2, 10.8.2

NULL value and, 10.8.1

privileges needed to create, 10.18.4

referential integrity enforced by, 10.18.5

UNIQUE constraint on, 10.8.2, 10.8.2

without other constraints, 10.8.2

foreign key dependency, 16.8.1

forward compatibility, 1.3

forward crossedition trigger, 24.3.1

forward crossedition trigger SQL, 24.3.3.2.1

function

aggregate, 11

analytic, 1.9.1

built-in

See SQL function

DETERMINISTIC

function-based index and, 9.4.2

RPC signature and, 23.10.2

invoking from SQL statement, 11.9

MGD_ID ADT, 22.3.3

OCI or OCCI, 17.7.2

PARALLEL_ENABLE, RPC signature and, 23.10.2

PL/SQL, invoked by SQL statement, 11.9

purity of, 11.9.4

RPC signature and, 23.10.2

result-cached, 11.4.7

returning large amount of data from, 11.4.6

SQL

See SQL function

SQL analytic, 1.9.1

G

generated column, 24.1.1.2.2

Geographic Information System (GIS) data, 7.5.1

GET_LTXID_OUTCOME procedure, 6.2.4.2

global transaction, 19.1.1

global variable, in C external subprogram, 18.13.6

greedy operator in regular expression, 8.4.1

group commit, 6.2.3

H

hierarchical profiler, 13

historical data, importing and exporting, 16.9

host language, 17.6

host program, 17.6

hot rollover, 24

I

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

IBM CICS, 19.1.1

IBM Transarc Encina, 19.1.1

Identity Code Package, 22

IEEE 754 standard, 7.3

exception

not raised, 7.3.3

raised during conversion, 7.3.6

special values supported by, 7.3.3

See also native floating-point data type

IGNORE_ROW_ON_DUPKEY_INDEX hint, 24.3.4.1.1

IMMEDIATE commit redo option, 6.2.3

implementing database application, 2.1.1.3

implicit cursor, 11.4.5

independent transaction

See autonomous transaction

index, 9

domain, 9.3

edition-based redefinition and, 24.2.6

function-based

See function-based index

on MGD_ID column, 22.3.2

infinity, 7.3.3, 7.3.3

in-flight transaction, 6.2.4

INHERIT ANY PRIVILEGES system privilege, 3.4.2

INHERIT PRIVILEGES privilege, 3.4.2

inherited object, 24.1.3

initialization parameter, 11.3

DML_LOCKS, 6.4

FIXED_DATE, 7.4.1

NLS_DATE_FORMAT, 7.4.1

instrumentation, 2.4

integer data type class, 23.10.2.4

integrity constraint

See constraint

integrity of data

See data integrity

interface

between PL/SQL and C, 18.5.2

between PL/SQL and Java, 18.5.1

program, 17.2

TX, 19.1.1

user, 17.2.1

stateful or stateless, 17.2.2

J

Java class method

calling, 18.10.3

interface between PL/SQL and, 18.5.1

publishing, 18.6

K

key

foreign

See FOREIGN KEY constraint

primary

See PRIMARY KEY constraint

unique

See UNIQUE constraint

L

Large Object (LOB), 7.5.3.1

leaf edition, 24.1.2

LGWR (log writer process), 6.2.3, 6.2.3

lightweight queue, 20.3

live operation, 24

load balancing advisory FAN event, 2.13.3

LOB

See Large Object (LOB)

LOCK TABLE statement, 6.4.2

SELECT FOR UPDATE statement with, 6.4.5

locking row explicitly, 6.4.4

locking table

explicitly, 6.4

implicitly, 6.4.3

log writer process (LGWR), 6.2.3

logical design, 2.1.1.2.1

logical transaction identifier (LTXID), 6.2.4.1

logical value, 11.4.4.1.2

LONG and LONG RAW data types, 7.5.3.2

LONG data type, 7.2

loose coupling, 19.1.1

low-level code, debugging, 11.10.5

LTXID (logical transaction identifier), 6.2.4.1

M

main transaction, 6.8

maintaining database and application, 2.1.1.4

managing default rights, 3.4.3

materialized view, 1.9.2

that depends on editioned object, 24.1.1.2.1

maximum availability of table, 24.2.1

memory advisor, 2.3.4

metacharacter in regular expression, 8.1

metadata for SQL operator or function, 7.7

metrics, 2.1.2

MGD_ID ADT, 22.1

MGD_ID database ADT function, 22.3.3

mod_plsql module, 14.2.1.1

mode

dependency, 23.10

lock, 6.4.2

serialized

See serializable transaction

MODIFY CONSTRAINT clause of ALTER TABLE statement, 10.15

modifying

See altering

monitoring database performance, 2.3

multilanguage program, 18.1

error or exception in, 18.11

multiline mode, 8.2

multilingual data, 8.4.2

multimedia data, 7.5.2

N

name resolution, 23.7

editions and, 24.1.1.1

NaN (not a number), 7.3.3

national character large object (NCLOB) data type, 7.5.3.1

native execution, 11.7

native floating-point data type, 7.3

arithmetic operation with, 7.3.5

binary format for, 7.3.2.1

conversion functions for, 7.3.6

in client interfaces, 7.3.7

special values for, 7.3.3

NCHAR data type, 7.2

NCLOB data type, 7.2, 7.5.3.1

negative infinity, 7.3.3

negative zero, 7.3.3

nested subprogram, 11.1

NLS_DATE_FORMAT initialization parameter, 7.4.1

NO_RESULT_CACHE hint, 2.7.3.1

nonblocking DDL statement, 6.7

in autonomous transaction, 6.8

NONEDITIONABLE property, 24.1.1.5

noneditionable schema object type, 24.1.1.3

noneditioned object, 24.1.1

creating or replacing, 24.1.1.5.1

name resolution and, 24.1.1.1

that can depend on editioned object, 24.1.1.2

dropping edition and, 24.1.8

FORCE and, 24.1.1.4.1, 24.1.1.4.1

nongreedy operator in regular expression, 8.4.3

nonpersistent queue, 20.3

noreplay keyword (killing or disconnecting session), 26.2.2.9

normalized significand, 7.3.2.1

NOT NULL constraint

compared to CHECK constraint, 10.12.4

naming, 10.13.2

on FOREIGN KEY constraint, 10.8.2, 10.8.2

when to use, 10.4

NOWAIT commit redo option, 6.2.3

NOWAIT option of LOCK TABLE statement, 6.4.2

NULL value

FOREIGN KEY constraint and, 10.8.1

function-based index and, 9.4

indexing and, 10.4

NUMBER data type, 7.3

number data type class, 23.10.2.4

numeric data types, 7.3

NVARCHAR2 data type, 7.2

O

object

actual, 24.1.3

dependent

See schema object dependency

editioned

See editioned object

inherited, 24.1.3

large

See Large Object (LOB)

noneditioned

See noneditioned object

potentially editioned, 24.1.1

with noneditioned dependents, 24.1.1.4.1

referenced

See schema object dependency

size limit for PL/SQL stored, 11.4.3

object change notification, 15.1

OCCI

See Oracle C++ Call Interface

OCI

See Oracle Call Interface

OCI_ATTR_CHDES_DBNAME, 15.8.5.1

OCI_ATTR_CHDES_NFTYPE, 15.8.5.1

OCI_ATTR_CHDES_QUERIES, 15.8.5.1

OCI_ATTR_CHDES_ROW_OPFLAGS, 15.8.5.1.2

OCI_ATTR_CHDES_ROW_ROWID, 15.8.5.1.2

OCI_ATTR_CHDES_TABLE_CHANGES, 15.8.5.1

OCI_ATTR_CHDES_TABLE_NAME, 15.8.5.1.2

OCI_ATTR_CHDES_TABLE_OPFLAGS, 15.8.5.1.2

OCI_ATTR_CHDES_TABLE_ROW_CHANGES, 15.8.5.1.2

OCI_ATTR_CHDES_XID, 15.8.5.1

OCI_ATTR_CHNF_CHANGELAG, 15.8.3

OCI_ATTR_CHNF_OPERATIONS, 15.8.3

OCI_ATTR_CHNF_ROWIDS, 15.8.3

OCI_ATTR_CHNF_TABLENAMES, 15.8.3

OCI_ATTR_CQ_QUERYID, 15.8.4

OCI_ATTR_CQDES_OPERATION, 15.8.5.1.1

OCI_ATTR_CQDES_QUERYID, 15.8.5.1.1

OCI_ATTR_CQDES_TABLE_CHANGES, 15.8.5.1.1

OCI_ATTR_SESSION_STATE attribute, 2.12.13

OCI_ATTR_SUBSCR_CALLBACK, 15.8.3

OCI_ATTR_SUBSCR_CQ_CHNF_QOSFLAGS, 15.8.3

OCI_ATTR_SUBSCR_NAMESPACE, 15.8.3

OCI_ATTR_SUBSCR_QOSFLAGS, 15.8.3

OCI_ATTR_SUBSCR_TIMEOUT, 15.8.3

OCI_DTYPE_CQDES, 15.8.5.1.1

OCI_SESSGET_PURITY_NEW attribute, 2.12.5.1

OCI_SESSGET_PURITY_SELF attribute, 2.12.5.1

OCI_SESSION_STATELESS attribute, 2.12.13

OCI_SUBSCR_QOS_PURGE_ON_NTFN, 15.8.3

OCI_SUBSCR_QOS_RELIABLE, 15.8.3

OCIAnyData and OCIAnyDataSet interfaces, 7.5.6

ODP.NET, 17.9

online application upgrade

See edition-based redefinition (EBR)

operator

in regular expression, 8.4

greedy, 8.4.1

nongreedy, 8.4.3

metadata for, 7.7

optimizer

editioning view and, 24.2.7

function-based index and, 9.4, 9.4.1

RPC signature and, 23.10.2

ora$base edition, 24.1, 24.1.2

Oracle Advanced Queuing (AQ), 20.2.2

Oracle C++ Call Interface, 17.7

building application with, 17.7.4

kinds of functions in, 17.7.2

native floating-point data types in, 7.3.7

procedural and nonprocedural elements of, 17.7.3

Oracle Call Interface, 17.7

building application with, 17.7.4

commit redo action in, 6.2.3

compared to precompiler, 17.8

kinds of functions in, 17.7.2

native floating-point data types in, 7.3.7

procedural and nonprocedural elements of, 17.7.3

with Oracle XA, 19.3.5

Oracle Data Provider for .NET, 17.9

Oracle Data Redaction, 3.3

Oracle data type

See SQL data type

Oracle Database Tuning Pack, 2.3.4

Oracle Database Vault, 3.3

Oracle Extensibility Architecture framework, user-defined aggregate functions and, 1.3.3

Oracle Extensibility Architecture, data cartridges and, 1.3.1

Oracle Flashback Query, 16.3

Oracle Flashback Technology, 16.1

application development features, 16.1.1

configuring database for, 16.2

database administration features, 16.1.2

performance guidelines for, 16.11

Oracle Flashback Transaction Query, 16.5

Oracle Flashback Version Query, 16.4

Oracle JDBC, 17.4.2

compared to Oracle SQLJ, 17.4.4

native floating-point data types in, 7.3.7

sample program

2.0, 17.4.2.2

pre-2.0, 17.4.2.3

Oracle JDeveloper, Oracle SQLJ and, 17.4.3.1

Oracle JPublisher, 17.4.5

Oracle JVM, 17.4.1

Oracle Label Security, 3.3

Oracle Lock Management services, 6.5

Oracle Multimedia, 7.5.2

Oracle Real Application Clusters (Oracle RAC)

client result cache and, 2.7.5.1.2

DRCP and, 2.12.15

load balancing advisory FAN events and, 2.13.3

Oracle XA and, 19.5.3

runtime connection load balancing and, 2.13.1

Oracle SQLJ, 17.4.3

compared to Oracle JDBC, 17.4.4

Oracle JDeveloper and, 17.4.3.1

Oracle Text, 7.5.4, 7.5.4

Oracle Total Recall, 16.9

Oracle Tuxedo, 19.1.1

Oracle Virtual Private Database (VPD), 3.3

editioning view and, 24.5.1

Oracle XA

Oracle RAC and, 19.5.3

subprograms, 19.2

when to use, 19

out-of-space error, 6.9

overloaded subprogram, 11.1

P

package

creating, 11.4.2

dropping, 11.6

invalidation of, 11.11

session state and, 23.4.1

size limit for, 11.4.3

synonym for, 11.8.4.1

package body, 11.2

package invalidation and, 11.11

package specification, 11.2

package subprogram, 11.1

PARALLEL_ENABLE function

RPC signature and, 23.10.2

parallelized SQL statement, 11.9.4.2

parameter

compilation

See compilation parameter

initialization, 11.3

partition-extended editioning view name, 24.2.2

partitioning, 1.9.3

performance, 2

performance goals, 2.1.2

performance testing, 2.5

performance, data type and, 7.1.3

persistent LOB instance, 7.5.3.1

persistent queue, 20.3

phantom read, 6.6.1

physical design, 2.1.1.2.2

PLS_INTEGER data type, 11.4.4.1.3

PL/Scope tool, 12

plshprof utility, 13.5

PL/SQL block, 11.1

PL/SQL data type, 11.4.4

PL/SQL function result cache, 11.4.7

PL/SQL gateway, 14.2.1

PL/SQL hierarchical profiler, 13

PL/SQL language, 17.3

compared to Java, 17.5

PL/SQL object

See PL/SQL unit

PL/SQL optimize level, 11.3.1

PL/SQL optimizer level, 5.3

PL/SQL unit, 11.3

compiling for debugging, 11.10.3

CREATE OR REPLACE and, 23.4

PL/SQL Web Toolkit, 14.2.2

pool, connection, 17.6.1

positive infinity, 7.3.3

positive zero, 7.3.3

POSIX standard for regular expressions

operators defined in, 8.4.1

Oracle SQL and, 8.3

Oracle SQL multilingual extensions to, 8.4.2

Oracle SQL PERL-influenced extensions to, 8.4.3

potentially editioned object, 24.1.1

with noneditioned dependents, 24.1.1.4.1

precompiler, 17.6

compared to Oracle Call Interface, 17.8

Oracle XA and, 19.3.4

PRIMARY KEY constraint, 10.6

dropping, 10.17

Flashback Transaction and, 16.8.1

naming, 10.13.2

primary key dependency, 16.8.1

privileges, 3.1

for debugging subprogram, 11.10.4

for defining constraint, 10.13.1

for Oracle Flashback Technology, 16.2.5

for running subprogram, 11.8.1

granting secure application roles, 3.1

grouped into roles, 3.1

INHERIT ANY PRIVILEGES system privilege, 3.4.2

INHERIT PRIVILEGES privilege, 3.4.2

revoked, object dependency and, 23.4.2

Pro*C/C++ precompiler, 17.6.1

native floating-point data types in, 7.3.7

Pro*COBOL precompiler, 17.6.2

procedure

Q

quality-of-service flag, 15.7.6.2

query

registering for Continuous Query Notification, 15.6

returning results to client, 11.4.5

implicitly, 11.4.5.3

Query Result Change Notification (QRCN), 15.2

query rewrite, 1.9.2

queue, 20.3

R

Radio Frequency Identification (RFID) technology, 22.7.1

RAW data type, 7.5.3.2

raw data type class, 23.10.2.4

READ COMMITTED transaction isolation level

compared to SERIALIZABLE, 6.6.4.2

in Oracle Database, 6.6.1

transaction interactions with, 6.6.1

read consistency, 6.4

statement-level, 6.3

transaction-level, 6.3

locking tables explicitly for, 6.4

read-only transaction for, 6.3

read lock, 6.6.3

READ UNCOMMITTED transaction isolation level

in Oracle Database, 6.6.1

transaction interactions with, 6.6.1

read-only editioning view, 24.2.1

read-only transaction, 6.3

read-write editioning view, 24.2.1

record, 11.4.4.2

redefinition, edition-based (EBR), 24

redo information for transaction, 6.2.3

redo management, 6.2.3

REF CURSOR data type, 11.4.4.1.4

referenced object

See schema object dependency

referential integrity

serializable transactions and, 6.6.3

trigger for enforcing, 6.6.3

referential integrity constraint

See FOREIGN KEY constraint

REGEXP_COUNT function, 8.2

REGEXP_INSTR function, 8.2

REGEXP_LIKE condition, 8.2

REGEXP_REPLACE function, 8.2

back reference operator in, 8.4.1

REGEXP_SUBSTR function, 8.2

registration

dynamic, 19.1.1

for Continuous Query Notification, 15.6

in publish-subscribe model, 20.3

static, 19.1.1

regular expression, 8

in Oracle SQL, 8.2

in SQL statement, 8.5

metacharacter in, 8.1

POSIX standard and

See POSIX standard for regular expressions

Unicode and, 8.3

remote dependency management, 23.9

remote procedure call dependency management, 23.10

remote subprogram, 11.8.4

repeatable read, 6.3

locking tables explicitly for, 6.4

read-only transaction for, 6.3

REPEATABLE READ transaction isolation level

in Oracle Database, 6.6.1

transaction interactions with, 6.6.1

required public information, 19.1.2

resource manager (RM), 19.1.1

RESTRICT_REFERENCES pragma

for backward compatibility, 11.9.4.3

static and dynamic SQL and, 11.9.4.3.2

result cache, 11.4.7

RESULT_CACHE hint, 2.7.3.1

RESULT_CACHE_MODE session parameter, 2.7.3.3

resumable storage allocation, 6.9

RETENTION GUARANTEE clause for undo tablespace, 16.2.1

RETENTION option of ALTER TABLE statement, 16.2.4

RETURN_RESULT procedure, 11.4.5.3

reverse crossedition trigger, 24.3.2

reverse crossedition trigger SQL, 24.3.3.2.2

RFID (Radio Frequency Identification) technology, 22.7.1

RM (resource manager), 19.1.1

roles, 3.1

root edition, 24.1.2

rounding floating-point numbers, 7.3.2

row

address of (rowid), 7.6

locking explicitly, 6.4.4

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

ROW SHARE MODE option of LOCK TABLE statement, 6.4.2.1

rowid, 7.6

ROWID data type

ROWID pseudocolumn and, 7.6

ROWID pseudocolumn, 7.6

CQN and, 15.7.2.3

S

scalability, 2

scalar PL/SQL data type, 11.4.4.1

schema object dependency, 23

in distributed database, 23.9

invalidation and, 23.4

on nonexistence of other objects, 23.7

revoked privileges and, 23.4.2

shared pool and, 23.11

schema object type

editionable, 24.1.1.3

enabling for editions, 24.1.1.4

noneditionable, 24.1.1.3

searchable text, 7.5.4

secure application roles, 3.1

security

auditing, 3.6

external procedures for applications, 3.5

invoker’s rights and definer’s rights, 3.4.1

Java stored procedures default rights, 3.4.3

logon triggers and, 3.2

Oracle Data Redaction, 3.3

Oracle Database Vault, 3.3

Oracle Label Security, 3.3

Oracle Virtual Private Database, 3.3

privilege use, 3.1

privileges of invoking user, 3.4.2

role use, 3.1

secure application roles, 3.1

SELECT FOR UPDATE statement, 6.4.4

LOCK TABLE statement with, 6.4.5

referential integrity and

inside trigger, 6.6.3

outside trigger, 6.6.3

SELECT statement

bulk binding for, 11.4.8.2

referencing collection with, 11.4.8.2

with AS OF clause, 16.3

with FOR UPDATE clause

See SELECT FOR UPDATE statement

with VERSIONS BETWEEN clause, 16.4

semi-available table, 24.2.1

serendipitous change, 24.3.5

data transformation collisions and, 24.3.4.1.1

identifying, 24.3.4.1.1

serializable transaction

for concurrency control, 6.6

interaction with, 6.6.1

referential integrity and, 6.6.3

SERIALIZABLE transaction isolation level

compared to READ COMMITTED, 6.6.4.2

in Oracle Database, 6.6.1

transaction interactions with, 6.6.1

T

table

controlling user access to, 3.3

locking

choosing strategy for, 6.4.2

explicitly, 6.4

implicitly, 6.4.3

with maximum availability, 24.2.1

with semi-availability, 24.2.1

table annotation, 2.7.3.2

table result cache mode

annotation, 2.7.3.2

effective

determining, 2.7.3.4

displaying, 2.7.3.5

Tag Data Translation Markup Language Schema, 22.1

Temporal Validity Support, 1.9.4

temporary LOB instance, 7.5.3.1

thin client configuration, 17.1.3

thread-safe application, 19.3.9

three-tier architecture, 17.1.3

tight coupling, 19.1.1

time

default value for, 7.4.3

displaying, 7.4.3

current, 7.4.1

inserting, 7.4.3

U

undetected deadlock, 6.5

undo data, 16.1

UNDO_RETENTION parameter, 6.3

Unicode

data types for, 7.2

regular expressions and, 8.3

unified auditing, 3.6

UNIQUE constraint

crossedition trigger and, 24.3.4.1.1

dropping, 10.17

naming, 10.13.2

on FOREIGN KEY constraint, 10.8.2, 10.8.2

when to use, 10.7

unrepeatable read, 6.6.1

unusable edition

dropping edition and, 24.1.8

for materialized view, 24.1.1.2.1

retiring edition and, 24.1.7

upgrading applications online

See edition-based redefinition (EBR)

UROWID data type, 7.6

user access

See security

user interface, 17.2.1

stateful and stateless, 17.2.2

user lock, 6.5

user-defined subtype, 11.4.4.1.5

UTLLOCKT.SQL script, 6.5.2

V

VARCHAR data type, 7.2

VARCHAR data type class, 23.10.2.4

VARCHAR2 data type, 7.2

variable

cursor

See cursor variable

in C external subprogram

global, 18.13.6

static, 18.13.7

VERSIONS_ENDSCN pseudocolumn, 16.4

VERSIONS_ENDTIME pseudocolumn, 16.4

VERSIONS_OPERATION pseudocolumn, 16.4

VERSIONS_STARTSCN pseudocolumn, 16.4

VERSIONS_STARTTIME pseudocolumn, 16.4

VERSIONS_XID pseudocolumn, 16.4

view

constraint on, 10

editioned, FOREIGN KEY constraint and, 24.1.1.6

editioning

See editioning view

materialized, 1.9.2

that depends on editioned object, 24.1.1.2.1

virtual column, 24.1.1.2.2

VPD policy, editioning view and, 24.5.1

W

WAIT commit redo option, 6.2.3

WAIT option of LOCK TABLE statement, 6.4.2

web application, 14.1

implementing, 14.2

state and, 14.6.8

web services, 17.4.7

web toolkit

See PL/SQL Web Toolkit

white list

See ACCESSIBLE BY clause

wrap utility, debugging and, 11.10.3

writability of editioning view, 24.2.3

write-after-write dependency, 16.8.1

X

xa_open string, 19.3.3

XMLType data type, 7.5.5

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

Y

YY datetime format element, 7.4.2