1. Index

Index

Numerics  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 9.3.2
  • 64-bit IEEE 754 format 9.3.2

A

  • Abstract Data Type (ADT) 13.4.4.3
  • ACCESSIBLE BY clause
    • in package specification 13.2
    • stored subprogram and 13.1
  • actualization 27.2.3
  • actual object 27.2.3
  • ADDM (Automatic Database Diagnostic Monitor) 3.3.1
  • address of row (rowid) 9.6
  • administrators, restricting with Oracle Database Vault 5.3
  • ADT
    • See: Abstract Data Type (ADT)
  • AFTER SUSPEND trigger 8.9.2.1
  • agent 23.3
  • aggregate function 13
  • ALL_ARGUMENTS 14.6
  • ALL_DEPENDENCIES 14.6
  • ALL_ERRORS 14.6
  • ALL_IDENTIFIERS 14.6
  • ALL_STATEMENTS 14.6
  • altering application online
    • See: edition-based redefinition (EBR)
  • analytic function 1.9.1
  • ancestor edition 27.2.2
  • ANSI data type 9.5.7
  • ANYDATA data type 9.5.6
  • ANYDATASET data type 9.5.6
  • AP (application program) 22.1.1
  • application architecture 20.1
  • application domain index 11.3
  • application program (AP) 22.1.1
  • application SQL 27.4.3.2.3
  • APPLYING_CROSSEDITION_TRIGGER function 27.4.4.1.1
  • AQ (Oracle Advanced Queuing) 23.2.2
  • archive
    • See Flashback Data Archive 19.9
  • ARGn data type 9.7.1
  • arithmetic operation
    • with datetime data type 9.4.4
    • with native floating-point data type 9.3.5
  • assignment, reported by PL/Scope 14.5.1.2
  • auditing
    • available options 5.6
    • unified auditing 5.6
  • auditing policy, editioning view and 27.6.1
  • AUTHID clause
    • in package specification 13.2
    • stored subprogram and 13.1
  • AUTHID property
  • Automatic Database Diagnostic Monitor (ADDM) 3.3.1
  • Automatic Undo Management system 19.1
  • Automatic Workload Repository (AWR) 3.5.6
  • autonomous transaction 8.8
    • nonblocking DDL statement in 8.8
    • trigger as 8.9.2.1
  • auto-tuning OCI client statement cache 3.7

B

  • backward compatibility
    • LONG and LONG RAW data types for 9.5.3.2
    • RESTRICT_REFERENCES pragma for 13.10.4.3
  • BATCH commit redo option 8.2.3
  • benchmark 3.1.3
  • BINARY_DOUBLE data type 9.3
  • BINARY_FLOAT data type 9.3
  • BINARY_INTEGER data type
    • See: PLS_INTEGER data type
  • binary floating-point number 9.3.2
  • binary format 9.3.2.1
  • binary large object (BLOB) data type 9.5.3.1
  • bind variables 4.1
  • block, PL/SQL 13.1
  • blocking DDL statement 8.7
  • BOOLEAN data type 13.4.4.1.2
  • branch 22.1.1
  • built-in data type
    • See: SQL data type
  • built-in function
    • See: SQL function
  • bulk binding 13.4.8
  • business rule 12

C

  • calling subprogram
    • See: invoking subprogram
  • call specification
    • for external subprogram 21.3
    • in package 13.2
    • location of 21.8
  • CALL statement 21.10
  • cascading invalidation 26.4
  • C external subprogram 21.13
    • See also: external subprogram
  • CHANGE_DUPKEY_ERROR_INDEX hint 27.4.4.1.1
  • character data type class 26.10.2.4
  • character data types 9.2
  • character large object (CLOB) data type 9.5.3.1
  • CHAR data type 9.2
  • CHECK constraint
  • CLIENT_RESULT_CACHE_LAG server initialization parameter 3.5.5.1.3
  • CLIENT_RESULT_CACHE_SIZE server initialization parameter 3.5.5.1.2
  • client/server architecture 20.1.1
  • client configuration parameter 3.5.5.2
  • client notification 23.2.3
  • client result cache 3.5
  • client statement cache auto-tuning (OCI client session feature) 3.7
  • CLOB data type 9.2
  • coarse-grained invalidation 26.4
  • collection 13.4.4.2
  • column
  • commit redo management 8.2.3
  • COMPATIBLE server initialization parameter 3.5.5.1.1
  • compilation parameter 13.3
  • composite PL/SQL data type 13.4.4.2
  • concurrency
    • serializable transaction for 8.6
    • under explicit locking 8.4.5
  • conditional compilation 7.6
  • connection class 3.10.6.2
  • connection pool 20.6.1
  • connection pools
    • connection storms 2.1.1
    • design guidelines for logins 2.2
    • design guildelines 2.1
    • drained 2.3.1
    • guideline for preventing connection storms 2.1.2
    • guidelines for preventing programmatic session leaks 2.3
    • lock leaks 2.3.3
    • logical corruption 2.3.4
  • constraint 12, 12.4
  • Continuous Query Notification (CQN) 3.9, 18
  • converting data types
    • See: data type conversion
  • copy-on-change strategy 27.2.3
  • coupling 22.1.1
  • CQ_NOTIFICATION$_DESCRIPTOR object 18.10.1
  • CQ_NOTIFICATION$_QUERY object 18.10.3
  • CQ_NOTIFICATION$_REG_INFO object 18.7.6.2
  • CQ_NOTIFICATION$_ROW object 18.10.4
  • CQ_NOTIFICATION$_TABLE object 18.10.2
  • CQN (Continuous Query Notification) 18
  • CREATE_COVERAGE_TABLES procedure 16.3
  • CREATE OR REPLACE optimization 26.4
  • crossedition trigger 27.4
  • crossedition trigger SQL
  • cross-session PL/SQL function result cache 13.4.7
  • current date and time, displaying 9.4.1
  • current edition 27.2.6
  • cursor 13.4.5
  • cursor variable 13.4.4.1.4

D

  • database hardening 19.9
  • database logins, automated 5.2
  • Database Resident Connection Pool (DRCP) 3.10
  • data cartridge 1.3.1
  • data definition language statement
    • See: DDL statement
  • data integrity 12
    • See also: constraint
  • data modeling 3.1.1
  • data type
  • data type class 26.10.2.4
  • data type conversion
    • of ANSI and IBM data types 9.5.7
    • of datetime data types 9.4.5
    • of native floating-point data types 9.3.6
  • data type family
  • date 9.4
    • See also: datetime data types
  • datetime data type class 26.10.2.4
  • datetime data types 9.4
    • arithmetic operations with 9.4.4
    • conversion functions for 9.4.5
    • importing, exporting, and comparing 9.4.6
  • day, default value for 9.4.3
  • DB2 data type 9.5.7
  • DBA_STATEMENTS 14.5.2
  • DBA_STATEMENTS.SIGNATURE 14.5.2.4
  • DBA_STATEMENTS.TYPE Column 14.5.2.1
  • DBA_STATEMENTS.USAGE_CONTEXT_ID 14.5.2.3
  • DBA_STATEMENTS.USAGE_ID 14.5.2.2
  • DBMS_APPLICATION_INFO package 3.2.1
  • DBMS_DEBUG_JDWP 13.11.3
  • DBMS_DEBUG_JDWP package 13.11
  • DBMS_FLASHBACK_ARCHIVE procedures 19.9
  • DBMS_FLASHBACK.TRANSACTION_BACKOUT procedure 19.8
  • DBMS_FLASHBACK package 19.7
  • DBMS_HPROF.ANALYZE 15.5.2.6
  • DBMS_HPROF package 15.2
  • DBMS_LOCK package 8.5
  • DBMS_OUTPUT package 13.11
  • DBMS_PARALLEL_EXECUTE package 27.4.5
  • DBMS_PLSQL_CODE_COVERAGE 16.1, 16.2
  • DBMS_SQL.RETURN_RESULT procedure 13.4.5.3
  • DBMS_STATS package 19.11
  • DBMS_TYPES package 9.5.6
  • DBMS_XA package 22.3.10
  • DDL_LOCK_TIMEOUTparameter 8.7
  • DDL statement
  • deadlock, undetected 8.5
  • debugging
  • decimal floating-point number 9.3.2
  • default column value 12.5
  • deferring constraint checks 12.8.4
  • definer’s rights 5.4.1
  • denormal floating-point number 9.3.2.1
  • dependency mode 26.10
  • dependent object
    • See: schema object dependency
  • dependent transaction 19.8.1
  • DEPRECATE PRAGMA 13.6
  • descendent edition 27.2.2
  • design
  • DETERMINISTIC function
  • dirty read 8.6.1
  • disabling constraint
  • distributed database
    • FOREIGN KEY constraint and 12.11
    • remote dependency management and 26.9
  • distributed transaction 22.1.1
  • DLL (dynamic link library) 21.2
  • DML_LOCKS initialization parameter 8.4
  • DML statement
  • domain index 11.3
  • double-precision IEEE 754 format 9.3.2
  • drivers, Oracle JDBC 20.4.2.1
  • DTP (X/Open Distributed Transaction architecture) 22.1
  • dynamically typed data 9.5.6
  • dynamic link library (DLL) 21.2
  • dynamic registration 22.1.1
  • dynamic SQL 13.4.9

E

F

  • family of data types
  • FAN event, load balancing advisory 2.4.3
  • Fast Application Notification (FAN) 2.4.1
  • fine-grained access control 5.3
  • fine-grained auditing (FGA) policy, editioning view and 27.6.1
  • fine-grained invalidation 26.4
  • firing order of triggers 27.4.3.3
  • FIXED_DATE initialization parameter 9.4.1
  • fixed-point data type 9.3
  • Flashback Data Archive 19.9
  • Flashback Transaction 19.8
  • FLOAT data type 9.3
  • floating-point data type 9.3
    • See also: native floating-point data type
    • range and precision of 9.3.2
  • floating-point number
  • FORCE option of ALTER USER statement 27.2.1.4.1
  • FOREIGN KEY constraint 12.8
  • foreign key dependency 19.8.1
  • FOR loop
  • forward compatibility 1.3
  • forward crossedition trigger 27.4.1
  • forward crossedition trigger SQL 27.4.3.2.1
  • function 13.1
    • See also: subprogram
  • function-based index 11.4
    • example for faster case-insensitive searches 11.4.5
    • example for object columns 11.4.4
    • example for precomputing arithmetic expressions 11.4.3
    • optimizer and 11.4, 11.4.1
  • function result cache 13.4.7

G

  • generated column 27.2.1.2.2
  • Geographic Information System (GIS) data 9.5.1
  • GET_LTXID_OUTCOME procedure 8.2.4.2
  • global transaction 22.1.1
  • global variable, in C external subprogram 21.13.6
  • greedy operator in regular expression 10.4.1
  • group commit 8.2.3

H

  • hierarchical profiler 15
  • historical data, importing and exporting 19.9
  • host language 20.6
  • host program 20.6
  • hot rollover 27.1

I

  • IA-32 and IA-64 instruction set architecture 9.3.5
  • IBM CICS 22.1.1
  • IBM Transarc Encina 22.1.1
  • Identity Code Package 25
  • IEEE 754 standard 9.3
    • See also: native floating-point data type
    • exception
    • special values supported by 9.3.3
  • IGNORE_ROW_ON_DUPKEY_INDEX hint 27.4.4.1.1
  • IMMEDIATE commit redo option 8.2.3
  • implementing database application 3.1.1.3
  • implicit cursor 13.4.5
  • independent transaction
    • See: autonomous transaction
  • index 11
    • domain 11.3
    • edition-based redefinition and 27.3.6
    • function-based
      • See function-based index 11.4
    • on MGD_ID column 25.3.2
  • infinity 9.3.3
  • in-flight transaction 8.2.4
  • INHERIT ANY PRIVILEGES system privilege 5.4.2
  • inherited object 27.2.3
  • INHERIT PRIVILEGES privilege 5.4.2
  • initialization parameter 13.3
  • instrumentation 4.2
  • integer data type class 26.10.2.4
  • integrity constraint
    • See: constraint
  • integrity of data
    • See: data integrity
  • interface 20.7
    • See also: Oracle C++ Call Interface, Oracle Call Interface
  • invalidation
  • invoker’s rights 5.4.1
    • affect on invoker’s privileges 5.4.2
    • Java stored procedures 5.4.3
  • invoking subprogram 13.9
    • from subprogram 13.9.3
    • from trigger 13.9.3
    • interactively from Oracle Database tools 13.9.2
    • through embedded PL/SQL gateway 17.4.4
  • isolation level
    • See: transaction isolation level
  • iterative data processing

J

  • Java class method 21.6
    • See also: external subprogram
  • Java Database Connectivity
    • See: Oracle JDBC
  • Java language
    • compared to PL/SQL 20.5
    • Oracle Database support for 20.4
  • Java stored procedures 5.4.3
  • Java Virtual Machine
    • See: Oracle JVM
  • JDBC
    • See: Oracle JDBC
  • JVM
    • See: Oracle JVM

K

  • key
    • foreign
      • See FOREIGN KEY constraint 12.8
    • primary
      • See PRIMARY KEY constraint 12.6
    • unique
      • See UNIQUE constraint 12.7

L

  • Large Object (LOB) 9.5.3.1
  • leaf edition 27.2.2
  • LGWR (log writer process) 8.2.3
  • lightweight queue 23.3
  • live operation 27.1
  • load balancing advisory FAN event 2.4.3
  • LOB
    • See: Large Object (LOB)
  • locking row explicitly 8.4.4
  • locking table
  • LOCK TABLE statement 8.4.2
    • SELECT FOR UPDATE statement with 8.4.5
  • logical design 3.1.1.2.1
  • logical transaction identifier (LTXID) 8.2.4.1
  • logical value 13.4.4.1.2
  • log writer process (LGWR) 8.2.3
  • LONG and LONG RAW data types 9.5.3.2
  • LONG data type 9.2
  • loose coupling 22.1.1
  • LTXID (logical transaction identifier) 8.2.4.1

M

  • maintaining database and application 3.1.1.4
  • main transaction 8.8
  • managing default rights 5.4.3
  • materialized view 1.9.2
  • maximum availability of table 27.3.1
  • memory advisor 3.3.4
  • metacharacter in regular expression 10.1
  • metadata for SQL operator or function 9.7
  • metrics 3.1.2
  • MGD_ID ADT 25.1
  • MGD_ID database ADT function 25.3.3
  • mod_plsql module 17.2.1.1
  • mode
    • dependency 26.10
    • lock 8.4.2
    • serialized
      • See serializable transaction 8.6
  • MODIFY CONSTRAINT clause of ALTER TABLE statement 12.15
  • modifying
    • See: altering
  • monitoring database performance 3.3
  • multilanguage program 21.1
    • error or exception in 21.11
  • multiline mode 10.2
  • multilingual data 10.4.2
  • multimedia data 9.5.2

N

  • name resolution 26.7
  • NaN (not a number) 9.3.3
  • national character large object (NCLOB) data type 9.5.3.1
  • native execution 13.8
  • native floating-point data type 9.3
    • arithmetic operation with 9.3.5
    • binary format for 9.3.2.1
    • conversion functions for 9.3.6
    • in client interfaces 9.3.7
    • special values for 9.3.3
  • NCHAR data type 9.2
  • NCLOB data type 9.2
  • negative infinity 9.3.3
  • negative zero 9.3.3
  • nested subprogram 13.1
  • NLS_DATE_FORMAT initialization parameter 9.4.1
  • NO_RESULT_CACHE hint 3.5.3.1
  • nonblocking DDL statement 8.7
    • in autonomous transaction 8.8
  • NONEDITIONABLE property 27.2.1.5
  • noneditionable schema object type 27.2.1.3
  • noneditioned object 27.2.1
  • nongreedy operator in regular expression 10.4.3
  • nonpersistent queue 23.3
  • normalized significand 9.3.2.1
  • NOT NULL
    • See NOT NULL constraint 12.4
  • NOT NULL constraint
  • NOWAIT commit redo option 8.2.3
  • NOWAIT option of LOCK TABLE statement 8.4.2
  • NULL value
    • FOREIGN KEY constraint and 12.8.1
    • function-based index and 11.4
    • indexing and 12.4
  • NUMBER data type 9.3
  • number data type class 26.10.2.4
  • numeric data types 9.3
  • NVARCHAR2 data type 9.2

O

  • object
    • actual 27.2.3
    • dependent
      • See schema object dependency 26.1
    • editioned
    • inherited 27.2.3
    • large
    • noneditioned
      • See noneditioned object 27.2.1
    • potentially editioned 27.2.1
    • referenced
      • See schema object dependency 26.1
    • size limit for PL/SQL stored 13.4.3
  • object change notification 18.1
  • OCCI
    • See: Oracle C++ Call Interface
  • OCI
    • See: Oracle Call Interface
  • OCI_ATTR_CHDES_DBNAME 18.8.5.1
  • OCI_ATTR_CHDES_NFTYPE 18.8.5.1
  • OCI_ATTR_CHDES_TABLE_CHANGES 18.8.5.1
  • OCI_ATTR_CHDES_TABLE_NAME 18.8.5.1.2
  • OCI_ATTR_CHDES_TABLE_OPFLAGS 18.8.5.1.2
  • OCI_ATTR_CHDES_TABLE_ROW_CHANGES 18.8.5.1.2
  • OCI_ATTR_CHDES_XID 18.8.5.1
  • OCI_ATTR_CHNF_CHANGELAG 18.8.3
  • OCI_ATTR_CHNF_ROWIDS 18.8.3
  • OCI_ATTR_CQ_QUERYID 18.8.4
  • OCI_ATTR_CQDES_OPERATION 18.8.5.1.1
  • OCI_ATTR_CQDES_QUERYID 18.8.5.1.1
  • OCI_ATTR_CQDES_TABLE_CHANGES 18.8.5.1.1
  • OCI_ATTR_SESSION_STATE attribute 3.10.15
  • OCI_ATTR_SUBSCR_CALLBACK 18.8.3
  • OCI_ATTR_SUBSCR_CQ_CHNF_QOSFLAGS 18.8.3
  • OCI_ATTR_SUBSCR_TIMEOUT 18.8.3
  • OCI_DTYPE_CQDES 18.8.5.1.1
  • OCI_SESSGET_PURITY_NEW attribute 3.10.6.1
  • OCI_SESSGET_PURITY_SELF attribute 3.10.6.1
  • OCI_SESSION_STATELESS attribute 3.10.15
  • OCI_SUBSCR_QOS_PURGE_ON_NTFN 18.8.3
  • OCIAnyData and OCIAnyDataSet interfaces 9.5.6
  • ODP.NET 20.9
  • online application upgrade
    • See: edition-based redefinition (EBR)
  • operator
  • optimizer
  • ORA_SDTZ system variable
  • ora$base edition 27.2, 27.2.2
  • Oracle Advanced Queuing (AQ) 23.2.2
  • Oracle C++ Call Interface 20.7
    • building application with 20.7.4
    • kinds of functions in 20.7.2
    • native floating-point data types in 9.3.7
    • procedural and nonprocedural elements of 20.7.3
  • Oracle Call Interface 20.7
    • building application with 20.7.4
    • commit redo action in 8.2.3
    • compared to precompiler 20.8
    • kinds of functions in 20.7.2
    • native floating-point data types in 9.3.7
    • procedural and nonprocedural elements of 20.7.3
    • with Oracle XA 22.3.5
  • Oracle Database Tuning Pack 3.3.4
  • Oracle Database Vault 5.3
  • Oracle Data Provider for .NET 20.9
  • Oracle Data Redaction 5.3
  • Oracle data type
    • See: SQL data type
  • Oracle Extensibility Architecture, data cartridges and 1.3.1
  • Oracle Extensibility Architecture framework, user-defined aggregate functions and 1.3.3
  • Oracle Flashback Query 19.3
  • Oracle Flashback Technology 19.1
    • application development features 19.1.1
    • configuring database for 19.2
    • database administration features 19.1.2
    • performance guidelines for 19.11
  • Oracle Flashback Transaction Query 19.5
  • Oracle Flashback Version Query 19.4
  • Oracle JDBC 20.4.2
  • Oracle JDeveloper, Oracle SQLJ and 20.4.3.1
  • Oracle JVM 20.4.1
  • Oracle Label Security 5.3
  • Oracle Lock Management services 8.5
  • Oracle Multimedia 9.5.2
  • Oracle Real Application Clusters (Oracle RAC)
    • client result cache and 3.5.5.1.2
    • DRCP and 3.10.17
    • load balancing advisory FAN events and 2.4.3
    • Oracle XA and 22.5.3
    • runtime connection load balancing and 2.4.1
  • Oracle SQLJ 20.4.3
  • Oracle Text 9.5.4
  • Oracle Total Recall 19.9
  • Oracle Tuxedo 22.1.1
  • Oracle Virtual Private Database (VPD) 5.3
  • Oracle XA
  • out-of-space error 8.9
  • overloaded subprogram 13.1

P

  • package
  • package body 13.2
  • package invalidation and 13.12
  • package specification 13.2
  • package subprogram 13.1
  • PARALLEL_ENABLE function
  • parallelized SQL statement 13.10.4.2
  • parameter
    • compilation
      • See compilation parameter 13.3
    • initialization 13.3
  • partition-extended editioning view name 27.3.2
  • partitioning 1.9.3
  • performance 3
  • performance, data type and 9.1.3
  • performance goals 3.1.2
  • performance testing 3.4
  • persistent LOB instance 9.5.3.1
  • persistent queue 23.3
  • phantom read 8.6.1
  • physical design 3.1.1.2.2
  • PL/Scope 13.11, 14.1
  • PL/Scope security model 14.2
  • PL/Scope tool 14
  • PL/SQL block 13.1
  • PL/SQL data type 13.4.4
  • PL/SQL function result cache 13.4.7
  • PL/SQL gateway 17.2.1
  • PL/SQL hierarchical profiler 15
  • PL/SQL Hierarchical Profiler 13.11
  • PL/SQL language 20.3
    • compared to Java 20.5
  • PL/SQL object
    • See: PL/SQL unit
  • PL/SQL optimize level 13.3.1
  • PL/SQL optimizer level 7.3
  • PL/SQL unit 13.3
  • PL/SQL Web Toolkit 17.2.2
  • PLS_INTEGER data type 13.4.4.1.3
  • plshprof utility 15.5
  • PLSQL_CODE_COVERAGE package 16.3
  • pool, connection 20.6.1
  • positive infinity 9.3.3
  • positive zero 9.3.3
  • POSIX standard for regular expressions
    • operators defined in 10.4.1
    • Oracle SQL and 10.3
    • Oracle SQL multilingual extensions to 10.4.2
    • Oracle SQL PERL-influenced extensions to 10.4.3
  • potentially editioned object 27.2.1
  • precompiler 20.6
    • compared to Oracle Call Interface 20.8
    • Oracle XA and 22.3.4
  • PRIMARY KEY constraint 12.6
  • primary key dependency 19.8.1
  • privileges 5.1
    • for debugging subprogram 13.11.3.2
    • for defining constraint 12.13.1
    • for Oracle Flashback Technology 19.2.5
    • for running subprogram 13.9.1
    • granting secure application roles 5.1
    • grouped into roles 5.1
    • INHERIT ANY PRIVILEGES system privilege 5.4.2
    • INHERIT PRIVILEGES privilege 5.4.2
    • revoked, object dependency and 26.4.2
  • Pro*C/C++ precompiler 20.6.1
    • native floating-point data types in 9.3.7
  • Pro*COBOL precompiler 20.6.2
  • procedure 13.1
    • See also: subprogram
  • product code 25.7.2
  • profiler 15
  • program interface 20.2
  • programming environment 20
  • public information, required 22.1.2
  • publish-subscribe model 23
  • purity of function 13.10.4

Q

  • quality-of-service flag 18.7.6.2
  • query
    • registering for Continuous Query Notification 18.6
    • returning results to client 13.4.5
  • Query Result Change Notification (QRCN) 18.2
  • query rewrite 1.9.2
  • queue 23.3

R

  • Radio Frequency Identification (RFID) technology 25.7.1
  • RAW data type 9.5.3.2
  • raw data type class 26.10.2.4
  • READ COMMITTED transaction isolation level
    • compared to SERIALIZABLE 8.6.4.2
    • in Oracle Database 8.6.1
    • transaction interactions with 8.6.1
  • read consistency 8.4
    • statement-level 8.3
    • transaction-level 8.3
      • locking tables explicitly for 8.4
      • read-only transaction for 8.3
  • read lock 8.6.3
  • read-only editioning view 27.3.1
  • read-only transaction 8.3
  • READ UNCOMMITTED transaction isolation level
    • in Oracle Database 8.6.1
    • transaction interactions with 8.6.1
  • read-write editioning view 27.3.1
  • record 13.4.4.2
  • redefinition, edition-based (EBR) 27.1
  • redo information for transaction 8.2.3
  • redo management 8.2.3
  • REF CURSOR data type 13.4.4.1.4
  • referenced object
    • See: schema object dependency
  • referential integrity
    • serializable transactions and 8.6.3
    • trigger for enforcing 8.6.3
  • referential integrity constraint
    • See: FOREIGN KEY constraint
  • REGEXP_COUNT function 10.2
  • REGEXP_INSTR function 10.2
  • REGEXP_LIKE condition 10.2
  • REGEXP_REPLACE function 10.2
    • back reference operator in 10.4.1
  • REGEXP_SUBSTR function 10.2
  • registration
    • dynamic 22.1.1
    • for Continuous Query Notification 18.6
    • in publish-subscribe model 23.3
    • static 22.1.1
  • regular expression 10
    • in Oracle SQL 10.2
    • in SQL statement 10.5
    • metacharacter in 10.1
    • POSIX standard and
      • See POSIX standard for regular expressions 10.3
    • Unicode and 10.3
  • remote dependency management 26.9
  • remote procedure call dependency management 26.10
  • remote subprogram 13.9.4
  • repeatable read 8.3
    • locking tables explicitly for 8.4
    • read-only transaction for 8.3
  • REPEATABLE READ transaction isolation level
    • in Oracle Database 8.6.1
    • transaction interactions with 8.6.1
  • required public information 22.1.2
  • resource manager (RM) 22.1.1
  • RESTRICT_REFERENCES pragma
  • RESULT_CACHE_MODE session parameter 3.5.3.3
  • RESULT_CACHE hint 3.5.3.1
  • result cache 13.4.7
  • resumable storage allocation 8.9
  • RETENTION GUARANTEE clause for undo tablespace 19.2.1
  • RETENTION option of ALTER TABLE statement 19.2.4
  • RETURN_RESULT procedure 13.4.5.3
  • reverse crossedition trigger 27.4.2
  • reverse crossedition trigger SQL 27.4.3.2.2
  • RFID (Radio Frequency Identification) technology 25.7.1
  • RM (resource manager) 22.1.1
  • roles 5.1
  • root edition 27.2.2
  • rounding floating-point numbers 9.3.2
  • row
    • address of (rowid) 9.6
    • locking explicitly 8.4.4
  • ROW EXCLUSIVE MODE option of LOCK TABLE statement 8.4.2.1
  • rowid 9.6
  • ROWID data type
    • ROWID pseudocolumn and 9.6
  • ROWID pseudocolumn 9.6
    • See also: rowid
  • ROW SHARE MODE option of LOCK TABLE statement 8.4.2.1
  • RPC dependency management 26.10
  • RR datetime format element 9.4.1
  • rule on queue 23.3
  • rules engine 23.3
  • runtime connection load balancing 2.4
  • runtime error
    • See: exception

S

  • scalability 3
  • scalar PL/SQL data type 13.4.4.1
  • schema object dependency 26
    • in distributed database 26.9
    • invalidation and 26.4
    • on nonexistence of other objects 26.7
    • revoked privileges and 26.4.2
    • shared pool and 26.11
  • schema object type
  • searchable text 9.5.4
  • secure application roles 5.1
  • security
    • auditing 5.6
    • external procedures for applications 5.5
    • invoker’s rights and definer’s rights 5.4.1
    • Java stored procedures default rights 5.4.3
    • logon triggers and 5.2
    • Oracle Database Vault 5.3
    • Oracle Data Redaction 5.3
    • Oracle Label Security 5.3
    • Oracle Virtual Private Database 5.3
    • privileges of invoking user 5.4.2
    • privilege use 5.1
    • role use 5.1
    • secure application roles 5.1
  • SELECT FOR UPDATE statement 8.4.4
    • LOCK TABLE statement with 8.4.5
    • referential integrity and
  • SELECT statement
    • bulk binding for 13.4.8.2
    • referencing collection with 13.4.8.2
    • with AS OF clause 19.3
    • with FOR UPDATE clause
      • See SELECT FOR UPDATE statement 8.4.4
    • with VERSIONS BETWEEN clause 19.4
  • semi-available table 27.3.1
  • serendipitous change 27.4.5
  • serializable transaction
    • for concurrency control 8.6
    • interaction with 8.6.1
    • referential integrity and 8.6.3
  • SERIALIZABLE transaction isolation level 8.6.1
    • See also: serializable transaction
    • compared to READ COMMITTED 8.6.4.2
    • in Oracle Database 8.6.1
    • transaction interactions with 8.6.1
  • server-side programming 20.1.2
  • service routine, C external subprogram and 21.12
  • session cursor 13.4.5
  • session edition 27.2.6
  • session purity 3.10.6.1
  • session state 26.4.1
  • session variable 13.9.2
  • set based processing 4.3.2
  • SET CONSTRAINTS statement 12.8.4
  • Setting ORA_SDTZ system variable
  • SET TRANSACTION statement with READ ONLY option 8.3
  • shared SQL area 8.1.2
  • SHARE MODE option of LOCK TABLE statement 8.4.2.2
  • SHARE ROW EXCLUSIVE MODE option of LOCK TABLE statement 8.4.2.3
  • side effects of subprogram 13.10.4
  • signature checking 26.9.1
  • single-precision IEEE 754 format 9.3.2
  • spatial data 9.5.1
  • specification, package
    • See: package specification
  • SQL, dynamic
    • See: dynamic SQL
  • SQL/DS data type 9.5.7
  • SQL Access Advisor 3.3.4
  • SQL advisor 3.3.4
  • SQL analytic function 1.9.1
  • SQL area, shared 8.1.2
  • SQL data type 9
  • SQL function
  • SQLJ
    • See: Oracle SQLJ
  • SQL optimizer hint and editioning view 27.3.7
  • SQL statement
  • SQL Trace facility (SQL_TRACE) 3.2.2
  • SQL Tuning Advisor 3.3.4
  • standalone subprogram 13.1
  • state
  • stateful session 3.10.16
  • stateless session 3.10.16
  • statement
    • See: SQL statement
  • statement caching 3.6
  • statement-level read consistency 8.3, 8.4
  • static pools
    • used to prevent connection storms 2.1.2
  • static registration 22.1.1
  • static SQL, RESTRICT_REFERENCES pragma and 13.10.4.3.3
  • static variable, in C external subprogram 21.13.7
  • statistics
    • for application 15
    • for identifier 14
  • storage allocation error 8.9
  • storage requirements, decreasing 9.1.2
  • stored standalone subprogram, dropping 13.7
  • stored subprogram 13.1
  • subnormal floating-point number 9.3.2.1
  • subprogram 13.1
  • subscriber 23.3
  • subscription services 23.3
  • subtype 13.4.4.1
  • synonym
  • SYSDATE function 9.4.1
  • system management statement 8.1.1

T

  • table
    • controlling user access to 5.3
    • locking
    • with maximum availability 27.3.1
    • with semi-availability 27.3.1
  • table annotation 3.5.3.2
  • table result cache mode
  • Tag Data Translation Markup Language Schema 25.1
  • Temporal Validity Support 1.9.4
  • temporary LOB instance 9.5.3.1
  • thin client configuration 20.1.3
  • thread-safe application 22.3.9
  • three-tier architecture 20.1.3
  • tight coupling 22.1.1
  • time 9.4
    • See also: datetime data types
  • time-stamp checking 26.9.1
  • time-stamp dependency mode 26.10.1
  • TIMESTAMP WITH LOCAL TIME ZONE
  • TIMESTAMP WITH TIME ZONE
  • TM (transaction manager) 22.1.1
  • TPM (transaction processing monitor) 22.1.1
  • tracing tools 13
  • transaction
  • Transaction Guard 8.2.4, 28
  • transaction history table 28.4.2
  • transaction interaction
    • kinds of 8.6.1
    • serializable transaction and 8.6.1
    • transaction isolation level and 8.6.1
  • transaction isolation level
  • transaction-level read consistency 8.3
    • locking tables explicitly for 8.4
    • read-only transaction for 8.3
  • transaction manager (TM) 22.1.1
  • transaction processing monitor (TPM) 22.1.1
  • transaction set consistency 8.6.4.1
  • transform 27.4.1
  • trigger 13.1
    • AFTER SUSPEND 8.9.2.1
    • as autonomous transaction 8.9.2.1
    • automating database login with 5.2
    • compared to constraint 12.1
    • crossedition
      • See crossedition trigger 27.4
    • enforcing referential integrity with 8.6.3
    • in edition
    • invoking subprogram from 13.9.3
    • size limit for 13.4.3
  • TRUST assertion (deprecated) 13.10.4.3.2
  • TRUST keyword in RESTRICT_REFERENCES pragma 13.10.4.3.2
  • two-phase commit protocol 22.1.1
  • two-tier architecture 20.1.3
  • TX interface 22.1.1

U

  • undetected deadlock 8.5
  • UNDO_RETENTION parameter 8.3
  • undo data 19.1
  • Unicode
    • data types for 9.2
    • regular expressions and 10.3
  • unified auditing 5.6
  • UNIQUE constraint
  • unrepeatable read 8.6.1
  • unusable edition
  • upgrading applications online
    • See: edition-based redefinition (EBR)
  • UROWID data type 9.6
  • user access
    • See: security
  • user-defined subtype 13.4.4.1.5
  • user interface 20.2.1
    • stateful and stateless 20.2.2
  • user lock 8.5
  • UTLLOCKT.SQL script 8.5.2

V

W

  • WAIT commit redo option 8.2.3
  • WAIT option of LOCK TABLE statement 8.4.2
  • web application 17.1
  • web services 20.4.6
  • web toolkit
    • See: PL/SQL Web Toolkit
  • white list
    • See: ACCESSIBLE BY clause
  • wrap utility, debugging and 13.11.3.1
  • writability of editioning view 27.3.3
  • write-after-write dependency 19.8.1

X

  • X/Open Distributed Transaction Processing (DTP) architecture 22.1
  • xa_open string 22.3.3
  • XMLType data type 9.5.5

Y

  • YY datetime format element 9.4.2