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) 15.4.4.3
  • ACCESSIBLE BY clause
    • in package specification 15.2
    • stored subprogram and 15.1
  • accessor list
    • See: ACCESSIBLE BY clause
  • actualization 34.2.3
  • actual object 34.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 24.3
  • aggregate function 15
  • ALL_ARGUMENTS 16.6
  • ALL_DEPENDENCIES 16.6
  • ALL_ERRORS 16.6
  • ALL_IDENTIFIERS 16.6
  • ALL_STATEMENTS 16.6
  • altering application online
    • See: edition-based redefinition (EBR)
  • analytic function 1.9.1
  • ancestor edition 34.2.2
  • annotations 10.2
  • ANSI data type 9.5.7
  • ANYDATA data type 9.5.6
  • ANYDATASET data type 9.5.6
  • AP (application program) 31.1.1
  • application architecture 21.1
  • Application Continuity
  • application domain index 12.3
  • application program (AP) 31.1.1
  • application SQL 34.5.3.2.3
  • APPLYING_CROSSEDITION_TRIGGER function 34.5.4.1.1
  • AQ (Oracle Advanced Queuing) 24.2.2
  • archive
    • See Flashback Data Archive 23.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 16.5.1.2
  • auditing
    • available options 5.6
    • unified auditing 5.6
  • auditing policy, editioning view and 34.7.1
  • AUTHID clause
    • in package specification 15.2
    • stored subprogram and 15.1
  • AUTHID property
  • Automatic Database Diagnostic Monitor (ADDM) 3.3.1
  • Automatic Undo Management system 23.1
  • Automatic Workload Repository (AWR) 3.5.7
  • 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

  • backend for Microservices and AI 28
  • backward compatibility
    • LONG and LONG RAW data types for 9.5.2.2
    • RESTRICT_REFERENCES pragma for 15.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.2.1
  • bind variables 4.1
  • block, PL/SQL 15.1
  • blocking DDL statement 8.7
  • BOOLEAN data type 15.4.4.1.2
  • branch 31.1.1
  • built-in data type
    • See: SQL data type
  • built-in function
    • See: SQL function
  • bulk binding 15.4.8
  • business rule 13

C

  • calling subprogram
    • See: invoking subprogram
  • call specification
    • for external subprogram 22.3
    • in package 15.2
    • location of 22.8
  • CALL statement 22.10
  • cascading invalidation 33.4
  • C external subprogram 22.13
    • See also: external subprogram
  • CHANGE_DUPKEY_ERROR_INDEX hint 34.5.4.1.1
  • character data type class 33.10.2.4
  • character data types 9.2
  • character large object (CLOB) data type 9.5.2.1
  • CHAR data type 9.2
  • CHECK constraint
  • CLIENT_RESULT_CACHE_LAG server initialization parameter 3.5.6.1.3
  • CLIENT_RESULT_CACHE_SIZE server initialization parameter 3.5.6.1.2
  • client/server architecture 21.1.1
  • client configuration parameter 3.5.6.2
  • client notification 24.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 33.4
  • collection 15.4.4.2
  • column
  • commit redo management 8.2.3
  • COMPATIBLE server initialization parameter 3.5.6.1.1
  • compilation parameter 15.3
  • composite PL/SQL data type 15.4.4.2
  • concurrency
    • serializable transaction for 8.6
    • under explicit locking 8.4.5
  • conditional compilation 7.6
  • connection class 3.10.8
  • connection pool 21.7.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 13, 13.4
  • Continuous Query Notification (CQN) 3.9, 20
  • converting data types
    • See: data type conversion
  • copy-on-change strategy 34.2.3
  • coupling 31.1.1
  • CQ_NOTIFICATION$_DESCRIPTOR object 20.10.1
  • CQ_NOTIFICATION$_QUERY object 20.10.3
  • CQ_NOTIFICATION$_REG_INFO object 20.7.6.2
  • CQ_NOTIFICATION$_ROW object 20.10.4
  • CQ_NOTIFICATION$_TABLE object 20.10.2
  • CQN (Continuous Query Notification) 20
  • CREATE_COVERAGE_TABLES procedure 18.3
  • CREATE OR REPLACE optimization 33.4
  • crossedition trigger 34.5
  • crossedition trigger SQL
  • cross-session PL/SQL function result cache 15.4.7
  • current date and time, displaying 9.4.1
  • current edition 34.2.6
  • cursor 15.4.5
  • cursor variable 15.4.4.1.4

D

  • database hardening 23.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 13
    • See also: constraint
  • data modeling 3.1.1
  • data type
  • data type class 33.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 33.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 16.5.2
  • DBA_STATEMENTS.SIGNATURE 16.5.2.4
  • DBA_STATEMENTS.TYPE Column 16.5.2.1
  • DBA_STATEMENTS.USAGE_CONTEXT_ID 16.5.2.3
  • DBA_STATEMENTS.USAGE_ID 16.5.2.2
  • DBMS_APPLICATION_INFO package 3.2.1
  • DBMS_DEBUG_JDWP 15.11.3
  • DBMS_DEBUG_JDWP package 15.11
  • DBMS_FLASHBACK_ARCHIVE_MIGRATE 23.9.8
  • DBMS_FLASHBACK_ARCHIVE procedures 23.9
  • DBMS_FLASHBACK.TRANSACTION_BACKOUT procedure 23.8
  • DBMS_FLASHBACK package 23.7
  • DBMS_HPROF.ANALYZE 17.5.2.6
  • DBMS_HPROF package 17.2
  • DBMS_LOCK package 8.5
  • DBMS_OUTPUT package 15.11
  • DBMS_PARALLEL_EXECUTE package 34.5.5
  • DBMS_PLSQL_CODE_COVERAGE 18.1, 18.2
  • DBMS_SQL.RETURN_RESULT procedure 15.4.5.3
  • DBMS_STATS package 23.12
  • DBMS_TYPES package 9.5.6
  • DBMS_XA package 31.3.10
  • DDL_LOCK_TIMEOUTparameter 8.7
  • DDL statement
  • deadlock, undetected 8.5
  • debugging
  • decimal floating-point number 9.3.2
  • default column value 13.5
  • deferring constraint checks 13.8.4
  • definer’s rights 5.4.1
  • denormal floating-point number 9.3.2.1
  • dependency mode 33.10
  • dependent object
    • See: schema object dependency
  • dependent transaction 23.8.1
  • DEPRECATE PRAGMA 15.6
  • descendent edition 34.2.2
  • design
  • DETERMINISTIC function
  • developing Java saga applications 29.8
  • developing Java Saga applications A.1
    • saga annotations
  • developing saga applications 29
  • developing Saga applications
    • implementing Sagas 29.1
    • JMS Interface
      • JMS message properties 29.8.3
    • Oracle Saga framework
    • saga annotations 29.8.1
    • saga framework
  • dirty read 8.6.1
  • disabling constraint
  • distributed database
    • FOREIGN KEY constraint and 13.11
    • remote dependency management and 33.9
  • distributed transaction 31.1.1
  • DLL (dynamic link library) 22.2
  • DML_LOCKS initialization parameter 8.4
  • DML statement
  • domain index 12.3
  • double-precision IEEE 754 format 9.3.2
  • drivers, Oracle JDBC 21.4.2.1
  • DTP (X/Open Distributed Transaction architecture) 31.1
  • dynamically typed data 9.5.6
  • dynamic link library (DLL) 22.2
  • dynamic registration 31.1.1
  • dynamic SQL 15.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 34.7.1
  • fine-grained invalidation 33.4
  • firing order of triggers 34.5.3.3
  • FIXED_DATE initialization parameter 9.4.1
  • fixed-point data type 9.3
  • Flashback Archive 23.9
  • Flashback Data Archive 23.9
  • Flashback Time Travel 23.9
  • Flashback Transaction 23.8
  • flexible use case domains
  • 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 34.2.1.4.1
  • FOREIGN KEY constraint 13.8
  • foreign key dependency 23.8.1
  • FOR loop
  • forward compatibility 1.3
  • forward crossedition trigger 34.5.1
  • forward crossedition trigger SQL 34.5.3.2.1
  • function 15.1
    • See also: subprogram
  • function-based index 12.4
    • example for faster case-insensitive searches 12.4.5
    • example for object columns 12.4.4
    • example for precomputing arithmetic expressions 12.4.3
    • optimizer and 12.4, 12.4.1
  • function result cache 15.4.7

G

  • generated column 34.2.1.2.2
  • Geographic Information System (GIS) data 9.5.1
  • GET_LTXID_OUTCOME procedure 8.2.4.2
  • global transaction 31.1.1
  • global variable, in C external subprogram 22.13.6
  • greedy operator in regular expression 11.4.1
  • group commit 8.2.3

H

  • hierarchical profiler 17
  • historical data, importing and exporting 23.9
  • host language 21.7
  • host program 21.7
  • hot rollover 34.1

I

  • IA-32 and IA-64 instruction set architecture 9.3.5
  • IBM CICS 31.1.1
  • IBM Transarc Encina 31.1.1
  • Identity Code Package 26
  • 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 34.5.4.1.1
  • IMMEDIATE commit redo option 8.2.3
  • implementing database application 3.1.1.3
  • implicit connection pooling 3.10.17
  • implicit connection pooling)
  • implicit cursor 15.4.5
  • independent transaction
    • See: autonomous transaction
  • index 12
    • domain 12.3
    • edition-based redefinition and 34.4.6
    • function-based
      • See function-based index 12.4
    • on MGD_ID column 26.3.2
  • infinity 9.3.3
  • in-flight transaction 8.2.4
  • INHERIT ANY PRIVILEGES system privilege 5.4.2
  • inherited object 34.2.3
  • INHERIT PRIVILEGES privilege 5.4.2
  • initialization parameter 15.3
  • instrumentation 4.2
  • integer data type class 33.10.2.4
  • integrity constraint
    • See: constraint
  • integrity of data
    • See: data integrity
  • interface 21.8
    • 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 15.9
    • from subprogram 15.9.3
    • from trigger 15.9.3
    • interactively from Oracle Database tools 15.9.2
    • through embedded PL/SQL gateway 19.4.4
  • isolation level
    • See: transaction isolation level
  • iterative data processing

J

  • Java class method 22.6
    • See also: external subprogram
  • Java Database Connectivity
    • See: Oracle JDBC
  • Java language
    • compared to PL/SQL 21.6
    • Oracle Database support for 21.4
  • JavaScript Support
  • 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 13.8
    • primary
      • See PRIMARY KEY constraint 13.6
    • unique
      • See UNIQUE constraint 13.7

L

  • Large Object (LOB) 9.5.2.1
  • leaf edition 34.2.2
  • LGWR (log writer process) 8.2.3
  • lightweight queue 24.3
  • live operation 34.1
  • load balancing advisory FAN event 2.4.3
  • LOB
    • See: Large Object (LOB)
  • lock-free reservation 30
    • about CHECK constraints 30.3.4
    • about concurrency in transactions 30.1
    • adding or modifying reservable columns 30.3.3
    • benefits 30.4
    • comparing optimistic and lock-free reservation 30.3.1
    • creating a reservable column 30.3.2
    • examples 30.3.5
    • guidelines 30.5
    • inserts and deletes guidelines 30.5.3
    • introduction 30.3
    • querying reservable column views 30.3.6
    • reservable column guidelines 30.5.1
    • reservation journal table columns 30.3.2.1
    • restrictions for reservation journal table 30.5.5
    • terminology 30.2
    • update statement guidelines 30.5.2
  • locking row explicitly 8.4.4
  • locking table
  • lock-less reservation
    • concurrent DDL guidelines 30.5.4
  • 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 15.4.4.1.2
  • log writer process (LGWR) 8.2.3
  • LONG and LONG RAW data types 9.5.2.2
  • LONG data type 9.2
  • loose coupling 31.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 34.4.1
  • memory advisor 3.3.4
  • metacharacter in regular expression 11.1
  • metadata for SQL operator or function 9.7
  • metrics 3.1.2
  • MGD_ID ADT 26.1
  • MGD_ID database ADT function 26.3.3
  • microservice architecture 27
  • mod_plsql module 19.2.1.1
  • mode
    • dependency 33.10
    • lock 8.4.2
    • serialized
      • See serializable transaction 8.6
  • MODIFY CONSTRAINT clause of ALTER TABLE statement 13.16
  • modifying
    • See: altering
  • monitoring database performance 3.3
  • multi-column use case domains
  • multilanguage program 22.1
    • error or exception in 22.11
  • multiline mode 11.2
  • multilingual data 11.4.2
  • multilingual engine 21.5
    • built-in MLE modules 21.5.8.3.1
    • calling JavaScript functions 21.5.8.4.1
    • call specification overview 21.5.6
    • concepts 21.5.2
    • create MLE call specification clauses 21.5.8.4.2
    • dynamic MLE execution overview 21.5.9.1
    • invoking JavaScript 21.5.7
    • invoking JavaScriptusing dynamic MLE execution 21.5.9
    • JavaScript MLE modules overview 21.5.5
    • managing JavaScript MLE modules 21.5.8.3
    • MLE environment overview 21.5.4
    • MLE execution contexts 21.5.3
    • other supported MLE features 21.5.11
    • privileges 21.5.10
    • running JavaScript code inline 21.5.9.4.1
    • running JavaScript Code using files 21.5.9.4.2
    • runtime isolation for dynamic execution 21.5.9.2
    • runtime isolation using MLE module contexts 21.5.8.1
    • specifying an environment for a call specification 21.5.8.2
    • specifying an environment on a call specification 21.5.9.3
    • user privileges 21.5.10.1
    • using dynamic MLE execution 21.5.9.4
    • using JavaScript MLE modules 21.5.8.4

N

  • name resolution 33.7
  • NaN (not a number) 9.3.3
  • national character large object (NCLOB) data type 9.5.2.1
  • native execution 15.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 15.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 34.2.1.5
  • noneditionable schema object type 34.2.1.3
  • noneditioned object 34.2.1
  • nongreedy operator in regular expression 11.4.3
  • nonpersistent queue 24.3
  • normalized significand 9.3.2.1
  • NOT NULL
    • See NOT NULL constraint 13.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 13.8.1
    • function-based index and 12.4
    • indexing and 13.4
  • NUMBER data type 9.3
  • number data type class 33.10.2.4
  • numeric data types 9.3
  • NVARCHAR2 data type 9.2

O

  • object
    • actual 34.2.3
    • dependent
      • See schema object dependency 33.1
    • editioned
    • inherited 34.2.3
    • large
    • noneditioned
      • See noneditioned object 34.2.1
    • potentially editioned 34.2.1
    • referenced
      • See schema object dependency 33.1
    • size limit for PL/SQL stored 15.4.3
  • object change notification 20.1
  • OCCI
    • See: Oracle C++ Call Interface
  • OCI
    • See: Oracle Call Interface
  • OCI_ATTR_CHDES_DBNAME 20.8.6.1
  • OCI_ATTR_CHDES_NFTYPE 20.8.6.1
  • OCI_ATTR_CHDES_TABLE_CHANGES 20.8.6.1
  • OCI_ATTR_CHDES_TABLE_NAME 20.8.6.1.2
  • OCI_ATTR_CHDES_TABLE_OPFLAGS 20.8.6.1.2
  • OCI_ATTR_CHDES_TABLE_ROW_CHANGES 20.8.6.1.2
  • OCI_ATTR_CHDES_XID 20.8.6.1
  • OCI_ATTR_CHNF_CHANGELAG 20.8.4
  • OCI_ATTR_CHNF_ROWIDS 20.8.4
  • OCI_ATTR_CQ_QUERYID 20.8.5
  • OCI_ATTR_CQDES_OPERATION 20.8.6.1.1
  • OCI_ATTR_CQDES_QUERYID 20.8.6.1.1
  • OCI_ATTR_CQDES_TABLE_CHANGES 20.8.6.1.1
  • OCI_ATTR_SESSION_STATE attribute 3.10.24
  • OCI_ATTR_SUBSCR_CALLBACK 20.8.4
  • OCI_ATTR_SUBSCR_CQ_CHNF_QOSFLAGS 20.8.4
  • OCI_ATTR_SUBSCR_TIMEOUT 20.8.4
  • OCI_DTYPE_CQDES 20.8.6.1.1
  • OCI_SECURE_NOTIFICATION 20.8.3
  • OCI_SESSGET_PURITY_NEW attribute 3.10.7
  • OCI_SESSGET_PURITY_SELF attribute 3.10.7
  • OCI_SESSION_STATELESS attribute 3.10.24
  • OCI_SUBSCR_QOS_PURGE_ON_NTFN 20.8.4
  • OCIAnyData and OCIAnyDataSet interfaces 9.5.6
  • ODP.NET 21.10
  • online application upgrade
    • See: edition-based redefinition (EBR)
  • operator
  • optimizer
  • ora$base edition 34.2, 34.2.2
  • Oracle Advanced Queuing (AQ) 24.2.2
  • Oracle backend for Microservices and AI
  • Oracle C++ Call Interface 21.8
    • building application with 21.8.4
    • kinds of functions in 21.8.2
    • native floating-point data types in 9.3.7
    • procedural and nonprocedural elements of 21.8.3
  • Oracle Call Interface 21.8
    • building application with 21.8.4
    • commit redo action in 8.2.3
    • compared to precompiler 21.9
    • kinds of functions in 21.8.2
    • native floating-point data types in 9.3.7
    • procedural and nonprocedural elements of 21.8.3
    • with Oracle XA 31.3.5
  • Oracle Database Tuning Pack 3.3.4
  • Oracle Database Vault 5.3
  • Oracle Data Provider for .NET 21.10
  • 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 Data Archive
    • Oracle Virtual Private Database 23.11
  • Oracle Flashback Query 23.3
  • Oracle Flashback Technology 23.1
    • application development features 23.1.1
    • configuring database for 23.2
    • database administration features 23.1.2
    • performance guidelines for 23.12
  • Oracle Flashback Transaction Query 23.5
  • Oracle Flashback Version Query 23.4
  • Oracle JDBC 21.4.2
  • Oracle JDeveloper, Oracle SQLJ and 21.4.3.1
  • Oracle JVM 21.4.1
  • Oracle Label Security 5.3
  • Oracle Lock Management services 8.5
  • Oracle Real Application Clusters (Oracle RAC)
    • client result cache and 3.5.6.1.2
    • DRCP and 3.10.26
    • load balancing advisory FAN events and 2.4.3
    • Oracle XA and 31.5.3
    • runtime connection load balancing and 2.4.1
  • Oracle sessionless transactions 32
    • benefits 32.4
    • capabilities 32.3
    • committing a sessionless transaction 32.5.10.1, 32.5.10.2
    • draining sessionless transactions 32.8
    • errors messages 32.5.13
    • finalizing a sessionless transaction 32.5.10
    • introduction 32.1
    • lifecycle 32.5.2
    • OCI example 32.5.11
    • Oracle Coordinated Distributed Transaction interoperability 32.6
    • overview 32.2
    • restrictions 32.7
    • resuming a suspended sessionless transaction 32.5.9
    • rules and guidelines 32.5.12
    • starting a new sessionless transaction 32.5.6
    • suspending a sessionless transaction 32.5.8
    • using 32.5
      • active sessionless transaction 32.5.1
      • getting a GTRID 32.5.7
      • prerequisites 32.5.4
      • server round trips pre-call and post-call functions 32.5.3
      • setting a GTRID 32.5.5
      • timeout of suspended sessionless transaction 32.5.8.1
  • Oracle SQLJ 21.4.3
  • Oracle Text 9.5.4
  • Oracle Total Recall 23.9
  • Oracle Tuxedo 31.1.1
  • Oracle Virtual Private Database
    • Oracle Flashback Data Archive 23.11
  • Oracle Virtual Private Database (VPD) 5.3
  • Oracle XA
  • out-of-space error 8.9
  • overloaded subprogram 15.1

P

  • package
  • package body 15.2
  • package invalidation and 15.12
  • package specification 15.2
  • package subprogram 15.1
  • PARALLEL_ENABLE function
  • parallelized SQL statement 15.10.4.2
  • parameter
    • compilation
      • See compilation parameter 15.3
    • initialization 15.3
  • partition-extended editioning view name 34.4.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.2.1
  • persistent queue 24.3
  • phantom read 8.6.1
  • physical design 3.1.1.2.2
  • PL/Scope 15.11, 16.1
  • PL/Scope security model 16.2
  • PL/Scope tool 16
  • PL/SQL block 15.1
  • PL/SQL data type 15.4.4
  • PL/SQL function result cache 15.4.7
  • PL/SQL gateway 19.2.1
  • PL/SQL hierarchical profiler 17
  • PL/SQL Hierarchical Profiler 15.11
  • PL/SQL language 21.3
    • compared to Java 21.6
  • PL/SQL object
    • See: PL/SQL unit
  • PL/SQL optimize level 15.3.1
  • PL/SQL optimizer level 7.3
  • PL/SQL unit 15.3
  • PL/SQL Web Toolkit 19.2.2
  • PLS_INTEGER data type 15.4.4.1.3
  • plshprof utility 17.5
  • PLSQL_CODE_COVERAGE package 18.3
  • pool, connection 21.7.1
  • positive infinity 9.3.3
  • positive zero 9.3.3
  • POSIX standard for regular expressions
    • operators defined in 11.4.1
    • Oracle SQL and 11.3
    • Oracle SQL multilingual extensions to 11.4.2
    • Oracle SQL PERL-influenced extensions to 11.4.3
  • potentially editioned object 34.2.1
  • precompiler 21.7
    • compared to Oracle Call Interface 21.9
    • Oracle XA and 31.3.4
  • pre-validating JSON data 13.13
    • enabling precheck for a new table 13.13.2
    • enabling precheck for an exisitng table 13.13.3
    • guidelines for PRECHECK constraints 13.13.4
    • precheck syntax and definition 13.13.1
    • supported conditions for JSON schema validation 13.13.1.1
  • PRIMARY KEY constraint 13.6
  • primary key dependency 23.8.1
  • privileges 5.1
    • for debugging subprogram 15.11.3.2
    • for defining constraint 13.14.1
    • for Oracle Flashback Technology 23.2.5
    • for running subprogram 15.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 33.4.2
  • Pro*C/C++ precompiler 21.7.1
    • native floating-point data types in 9.3.7
  • Pro*COBOL precompiler 21.7.2
  • procedure 15.1
    • See also: subprogram
  • product code 26.7.2
  • profiler 17
  • program interface 21.2
  • programming environment 21
  • public information, required 31.1.2
  • publish-subscribe model 24
  • purity of function 15.10.4

Q

  • quality-of-service flag 20.7.6.2
  • query
    • registering for Continuous Query Notification 20.6
    • returning results to client 15.4.5
  • Query Result Change Notification (QRCN) 20.2
  • query rewrite 1.9.2
  • queue 24.3

R

  • Radio Frequency Identification (RFID) technology 26.7.1
  • RAW data type 9.5.2.2
  • raw data type class 33.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 34.4.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 34.4.1
  • record 15.4.4.2
  • redefinition, edition-based (EBR) 34.1
  • redo information for transaction 8.2.3
  • redo management 8.2.3
  • REF CURSOR data type 15.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 11.2
  • REGEXP_INSTR function 11.2
  • REGEXP_LIKE condition 11.2
  • REGEXP_REPLACE function 11.2
    • back reference operator in 11.4.1
  • REGEXP_SUBSTR function 11.2
  • registering application data usage 10
  • registration
    • dynamic 31.1.1
    • for Continuous Query Notification 20.6
    • in publish-subscribe model 24.3
    • static 31.1.1
  • regular expression 11
    • in Oracle SQL 11.2
    • in SQL statement 11.5
    • metacharacter in 11.1
    • POSIX standard and
      • See POSIX standard for regular expressions 11.3
    • Unicode and 11.3
  • remote dependency management 33.9
  • remote procedure call dependency management 33.10
  • remote subprogram 15.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 31.1.2
  • RESET_STATE 6.5.1
  • resource manager (RM) 31.1.1
  • RESTRICT_REFERENCES pragma
  • RESULT_CACHE_MODE session parameter 3.5.3.3
  • RESULT_CACHE hint 3.5.3.1
  • result cache 15.4.7
  • resumable storage allocation 8.9
  • RETENTION GUARANTEE clause for undo tablespace 23.2.1
  • RETENTION option of ALTER TABLE statement 23.2.4
  • RETURN_RESULT procedure 15.4.5.3
  • reverse crossedition trigger 34.5.2
  • reverse crossedition trigger SQL 34.5.3.2.2
  • RFID (Radio Frequency Identification) technology 26.7.1
  • RM (resource manager) 31.1.1
  • roles 5.1
  • root edition 34.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 33.10
  • RR datetime format element 9.4.1
  • rule on queue 24.3
  • rules engine 24.3
  • runtime connection load balancing 2.4
  • runtime error
    • See: exception

S

  • scalability 3
  • scalar PL/SQL data type 15.4.4.1
  • schema object dependency 33
    • in distributed database 33.9
    • invalidation and 33.4
    • on nonexistence of other objects 33.7
    • revoked privileges and 33.4.2
    • shared pool and 33.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 15.4.8.2
    • referencing collection with 15.4.8.2
    • with AS OF clause 23.3
    • with FOR UPDATE clause
      • See SELECT FOR UPDATE statement 8.4.4
    • with VERSIONS BETWEEN clause 23.4
  • semi-available table 34.4.1
  • serendipitous change 34.5.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 21.1.2
  • service routine, C external subprogram and 22.12
  • session cursor 15.4.5
  • session edition 34.2.6
  • session purity 3.10.7
  • session state 33.4.1
  • session variable 15.9.2
  • set based processing 4.3.2
  • SET CONSTRAINTS statement 13.8.4
  • 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 15.10.4
  • signature checking 33.9.1
  • single-column use case domains
  • 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 34.4.7
  • SQL statement
  • SQL Trace facility (SQL_TRACE) 3.2.2
  • SQL Tuning Advisor 3.3.4
  • standalone subprogram 15.1
  • state
  • stateful session 3.10.25
  • stateless session 3.10.25
  • 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 31.1.1
  • static SQL, RESTRICT_REFERENCES pragma and 15.10.4.3.3
  • static variable, in C external subprogram 22.13.7
  • statistics
    • for application 17
    • for identifier 16
  • storage allocation error 8.9
  • storage requirements, decreasing 9.1.2
  • stored standalone subprogram, dropping 15.7
  • stored subprogram 15.1
  • subnormal floating-point number 9.3.2.1
  • subprogram 15.1
  • subscriber 24.3
  • subscription services 24.3
  • subtype 15.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 34.4.1
    • with semi-availability 34.4.1
  • table annotation 3.5.3.2
  • table DDL change notification 36
  • table result cache mode
  • Tag Data Translation Markup Language Schema 26.1
  • Temporal Validity Support 1.9.4
  • temporary LOB instance 9.5.2.1
  • thin client configuration 21.1.3
  • thread-safe application 31.3.9
  • three-tier architecture 21.1.3
  • tight coupling 31.1.1
  • time 9.4
    • See also: datetime data types
  • time-stamp checking 33.9.1
  • time-stamp dependency mode 33.10.1
  • TM (transaction manager) 31.1.1
  • TPM (transaction processing monitor) 31.1.1
  • tracing tools 15
  • transaction
  • transaction guard
    • rolling operation support 35.7
    • transient logical standby 35.7.1
  • Transaction Guard 8.2.4, 35
  • transaction history table 35.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) 31.1.1
  • transaction processing monitor (TPM) 31.1.1
  • transaction set consistency 8.6.4.1
  • transform 34.5.1
  • Transparent Application Continuity
  • trigger 15.1
    • AFTER SUSPEND 8.9.2.1
    • as autonomous transaction 8.9.2.1
    • automating database login with 5.2
    • compared to constraint 13.1
    • crossedition
      • See crossedition trigger 34.5
    • enforcing referential integrity with 8.6.3
    • in edition
    • invoking subprogram from 15.9.3
    • size limit for 15.4.3
  • TRUST assertion (deprecated) 15.10.4.3.2
  • TRUST keyword in RESTRICT_REFERENCES pragma 15.10.4.3.2
  • two-phase commit protocol 31.1.1
  • two-tier architecture 21.1.3
  • TX interface 31.1.1

U

  • undetected deadlock 8.5
  • UNDO_RETENTION parameter 8.3
  • undo data 23.1
  • Unicode
    • data types for 9.2
    • regular expressions and 11.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
  • use case domains 10.1
  • user access
    • See: security
  • user-defined subtype 15.4.4.1.5
  • user interface 21.2.1
    • stateful and stateless 21.2.2
  • user lock 8.5
  • using IF EXISTS and IF NOT EXISTS 8.10
  • 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 19.1
  • web services 21.4.6
  • web toolkit
    • See: PL/SQL Web Toolkit
  • wrap utility, debugging and 15.11.3.1
  • writability of editioning view 34.4.3
  • write-after-write dependency 23.8.1

X

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

Y

  • YY datetime format element 9.4.2