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) 16.4.4.3
  • ACCESSIBLE BY clause
    • in package specification 16.2
    • stored subprogram and 16.1
  • accessor list
    • See: ACCESSIBLE BY clause
  • actualization 35.2.3
  • actual object 35.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 25.3
  • aggregate function 16
  • ALL_ARGUMENTS 17.6
  • ALL_DEPENDENCIES 17.6
  • ALL_ERRORS 17.6
  • ALL_IDENTIFIERS 17.6
  • ALL_STATEMENTS 17.6
  • altering application online
    • See: edition-based redefinition (EBR)
  • analytic function 1.9.1
  • ancestor edition 35.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) 32.1.1
  • application architecture 22.1
  • Application Continuity
  • application domain index 12.3
  • application program (AP) 32.1.1
  • application SQL 35.5.3.2.3
  • APPLYING_CROSSEDITION_TRIGGER function 35.5.4.1.1
  • AQ (Oracle Advanced Queuing) 25.2.2
  • archive
    • See Flashback Data Archive 24.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 17.5.1.2
  • auditing
    • available options 5.6
    • unified auditing 5.6
  • auditing policy, editioning view and 35.7.1
  • AUTHID clause
    • in package specification 16.2
    • stored subprogram and 16.1
  • AUTHID property
  • Automatic Database Diagnostic Monitor (ADDM) 3.3.1
  • Automatic Undo Management system 24.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 29
  • backward compatibility
    • LONG and LONG RAW data types for 9.5.2.2
    • RESTRICT_REFERENCES pragma for 16.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 16.1
  • blocking DDL statement 8.7
  • BOOLEAN data type 16.4.4.1.2
  • branch 32.1.1
  • built-in data type
    • See: SQL data type
  • built-in function
    • See: SQL function
  • bulk binding 16.4.8
  • business rule 13

C

  • calling subprogram
    • See: invoking subprogram
  • call specification
    • for external subprogram 23.3
    • in package 16.2
    • location of 23.8
  • CALL statement 23.10
  • cascading invalidation 34.4
  • C external subprogram 23.13
    • See also: external subprogram
  • CHANGE_DUPKEY_ERROR_INDEX hint 35.5.4.1.1
  • character data type class 34.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 22.1.1
  • client configuration parameter 3.5.6.2
  • client notification 25.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 34.4
  • collection 16.4.4.2
  • column
  • commit redo management 8.2.3
  • COMPATIBLE server initialization parameter 3.5.6.1.1
  • compilation parameter 16.3
  • composite PL/SQL data type 16.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 22.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.5
  • Continuous Query Notification (CQN) 3.9, 21
  • converting data types
    • See: data type conversion
  • copy-on-change strategy 35.2.3
  • coupling 32.1.1
  • CQ_NOTIFICATION$_DESCRIPTOR object 21.10.1
  • CQ_NOTIFICATION$_QUERY object 21.10.3
  • CQ_NOTIFICATION$_REG_INFO object 21.7.6.2
  • CQ_NOTIFICATION$_ROW object 21.10.4
  • CQ_NOTIFICATION$_TABLE object 21.10.2
  • CQN (Continuous Query Notification) 21
  • CREATE_COVERAGE_TABLES procedure 19.3
  • CREATE OR REPLACE optimization 34.4
  • crossedition trigger 35.5
  • crossedition trigger SQL
  • cross-session PL/SQL function result cache 16.4.7
  • current date and time, displaying 9.4.1
  • current edition 35.2.6
  • cursor 16.4.5
  • cursor variable 16.4.4.1.4

D

  • database hardening 24.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 34.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 34.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 17.5.2
  • DBA_STATEMENTS.SIGNATURE 17.5.2.4
  • DBA_STATEMENTS.TYPE Column 17.5.2.1
  • DBA_STATEMENTS.USAGE_CONTEXT_ID 17.5.2.3
  • DBA_STATEMENTS.USAGE_ID 17.5.2.2
  • DBMS_APPLICATION_INFO package 3.2.1
  • DBMS_DEBUG_JDWP 16.11.3
  • DBMS_DEBUG_JDWP package 16.11
  • DBMS_FLASHBACK_ARCHIVE_MIGRATE 24.9.8
  • DBMS_FLASHBACK_ARCHIVE procedures 24.9
  • DBMS_FLASHBACK.TRANSACTION_BACKOUT procedure 24.8
  • DBMS_FLASHBACK package 24.7
  • DBMS_HPROF.ANALYZE 18.5.2.6
  • DBMS_HPROF package 18.2
  • DBMS_LOCK package 8.5
  • DBMS_OUTPUT package 16.11
  • DBMS_PARALLEL_EXECUTE package 35.5.5
  • DBMS_PLSQL_CODE_COVERAGE 19.1, 19.2
  • DBMS_SQL.RETURN_RESULT procedure 16.4.5.3
  • DBMS_STATS package 24.12
  • DBMS_TYPES package 9.5.6
  • DBMS_XA package 32.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.6
  • deferring constraint checks 13.9.4
  • definer’s rights 5.4.1
  • denormal floating-point number 9.3.2.1
  • dependency mode 34.10
  • dependent object
    • See: schema object dependency
  • dependent transaction 24.8.1
  • DEPRECATE PRAGMA 16.6
  • descendent edition 35.2.2
  • design
  • DETERMINISTIC function
  • developing Java saga applications 30.8
  • developing Java Saga applications A.1
    • saga annotations
  • developing saga applications 30
  • developing Saga applications
    • implementing Sagas 30.1
    • JMS Interface
      • JMS message properties 30.8.3
    • Oracle Saga framework
    • saga annotations 30.8.1
    • saga framework
  • dirty read 8.6.1
  • disabling constraint
  • distributed database
    • FOREIGN KEY constraint and 13.12
    • remote dependency management and 34.9
  • distributed transaction 32.1.1
  • DLL (dynamic link library) 23.2
  • DML_LOCKS initialization parameter 8.4
  • DML statement
  • domain index 12.3
  • double-precision IEEE 754 format 9.3.2
  • drivers, Oracle JDBC 22.4.2.1
  • DTP (X/Open Distributed Transaction architecture) 32.1
  • dynamically typed data 9.5.6
  • dynamic link library (DLL) 23.2
  • dynamic registration 32.1.1
  • dynamic SQL 16.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 35.7.1
  • fine-grained invalidation 34.4
  • firing order of triggers 35.5.3.3
  • FIXED_DATE initialization parameter 9.4.1
  • fixed-point data type 9.3
  • Flashback Archive 24.9
  • Flashback Data Archive 24.9
  • Flashback Time Travel 24.9
  • Flashback Transaction 24.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 35.2.1.4.1
  • FOREIGN KEY constraint 13.9
  • foreign key dependency 24.8.1
  • FOR loop
  • forward compatibility 1.3
  • forward crossedition trigger 35.5.1
  • forward crossedition trigger SQL 35.5.3.2.1
  • function 16.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 16.4.7

G

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

H

  • hierarchical profiler 18
  • historical data, importing and exporting 24.9
  • host language 22.7
  • host program 22.7
  • hot rollover 35.1

I

  • IA-32 and IA-64 instruction set architecture 9.3.5
  • IBM CICS 32.1.1
  • IBM Transarc Encina 32.1.1
  • Identity Code Package 27
  • 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 35.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 16.4.5
  • independent transaction
    • See: autonomous transaction
  • index 12
    • domain 12.3
    • edition-based redefinition and 35.4.6
    • function-based
      • See function-based index 12.4
    • on MGD_ID column 27.3.2
  • infinity 9.3.3
  • in-flight transaction 8.2.4
  • INHERIT ANY PRIVILEGES system privilege 5.4.2
  • inherited object 35.2.3
  • INHERIT PRIVILEGES privilege 5.4.2
  • initialization parameter 16.3
  • instrumentation 4.2
  • integer data type class 34.10.2.4
  • integrity constraint
    • See: constraint
  • integrity of data
    • See: data integrity
  • interface 22.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 16.9
    • from subprogram 16.9.3
    • from trigger 16.9.3
    • interactively from Oracle Database tools 16.9.2
    • through embedded PL/SQL gateway 20.4.4
  • isolation level
    • See: transaction isolation level
  • iterative data processing

J

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

L

  • Large Object (LOB) 9.5.2.1
  • leaf edition 35.2.2
  • LGWR (log writer process) 8.2.3
  • lightweight queue 25.3
  • live operation 35.1
  • load balancing advisory FAN event 2.4.3
  • LOB
    • See: Large Object (LOB)
  • lock-free reservation 31
    • about CHECK constraints 31.3.4
    • about concurrency in transactions 31.1
    • adding or modifying reservable columns 31.3.3
    • benefits 31.4
    • comparing optimistic and lock-free reservation 31.3.1
    • creating a reservable column 31.3.2
    • examples 31.3.5
    • guidelines 31.5
    • inserts and deletes guidelines 31.5.3
    • introduction 31.3
    • querying reservable column views 31.3.6
    • reservable column guidelines 31.5.1
    • reservation journal table columns 31.3.2.1
    • restrictions for reservation journal table 31.5.5
    • terminology 31.2
    • update statement guidelines 31.5.2
  • locking row explicitly 8.4.4
  • locking table
  • lock-less reservation
    • concurrent DDL guidelines 31.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 16.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 32.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 35.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 27.1
  • MGD_ID database ADT function 27.3.3
  • microservice architecture 28
  • mod_plsql module 20.2.1.1
  • mode
    • dependency 34.10
    • lock 8.4.2
    • serialized
      • See serializable transaction 8.6
  • MODIFY CONSTRAINT clause of ALTER TABLE statement 13.17
  • modifying
    • See: altering
  • monitoring database performance 3.3
  • multi-column use case domains
  • multilanguage program 23.1
    • error or exception in 23.11
  • multiline mode 11.2
  • multilingual data 11.4.2
  • multilingual engine 22.5
    • built-in MLE modules 22.5.8.3.1
    • calling JavaScript functions 22.5.8.4.1
    • call specification overview 22.5.6
    • concepts 22.5.2
    • create MLE call specification clauses 22.5.8.4.2
    • dynamic MLE execution overview 22.5.9.1
    • invoking JavaScript 22.5.7
    • invoking JavaScriptusing dynamic MLE execution 22.5.9
    • JavaScript MLE modules overview 22.5.5
    • managing JavaScript MLE modules 22.5.8.3
    • MLE environment overview 22.5.4
    • MLE execution contexts 22.5.3
    • other supported MLE features 22.5.11
    • privileges 22.5.10
    • running JavaScript code inline 22.5.9.4.1
    • running JavaScript Code using files 22.5.9.4.2
    • runtime isolation for dynamic execution 22.5.9.2
    • runtime isolation using MLE module contexts 22.5.8.1
    • specifying an environment for a call specification 22.5.8.2
    • specifying an environment on a call specification 22.5.9.3
    • user privileges 22.5.10.1
    • using dynamic MLE execution 22.5.9.4
    • using JavaScript MLE modules 22.5.8.4

N

  • name resolution 34.7
  • NaN (not a number) 9.3.3
  • national character large object (NCLOB) data type 9.5.2.1
  • native execution 16.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 16.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 35.2.1.5
  • noneditionable schema object type 35.2.1.3
  • noneditioned object 35.2.1
  • nongreedy operator in regular expression 11.4.3
  • nonpersistent queue 25.3
  • normalized significand 9.3.2.1
  • NOT NULL
    • See NOT NULL constraint 13.5
  • 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.9.1
    • function-based index and 12.4
    • indexing and 13.5
  • NUMBER data type 9.3
  • number data type class 34.10.2.4
  • numeric data types 9.3
  • NVARCHAR2 data type 9.2

O

  • object
    • actual 35.2.3
    • dependent
      • See schema object dependency 34.1
    • editioned
    • inherited 35.2.3
    • large
    • noneditioned
      • See noneditioned object 35.2.1
    • potentially editioned 35.2.1
    • referenced
      • See schema object dependency 34.1
    • size limit for PL/SQL stored 16.4.3
  • object change notification 21.1
  • OCCI
    • See: Oracle C++ Call Interface
  • OCI
    • See: Oracle Call Interface
  • OCI_ATTR_CHDES_DBNAME 21.8.6.1
  • OCI_ATTR_CHDES_NFTYPE 21.8.6.1
  • OCI_ATTR_CHDES_TABLE_CHANGES 21.8.6.1
  • OCI_ATTR_CHDES_TABLE_NAME 21.8.6.1.2
  • OCI_ATTR_CHDES_TABLE_OPFLAGS 21.8.6.1.2
  • OCI_ATTR_CHDES_TABLE_ROW_CHANGES 21.8.6.1.2
  • OCI_ATTR_CHDES_XID 21.8.6.1
  • OCI_ATTR_CHNF_CHANGELAG 21.8.4
  • OCI_ATTR_CHNF_ROWIDS 21.8.4
  • OCI_ATTR_CQ_QUERYID 21.8.5
  • OCI_ATTR_CQDES_OPERATION 21.8.6.1.1
  • OCI_ATTR_CQDES_QUERYID 21.8.6.1.1
  • OCI_ATTR_CQDES_TABLE_CHANGES 21.8.6.1.1
  • OCI_ATTR_SESSION_STATE attribute 3.10.24
  • OCI_ATTR_SUBSCR_CALLBACK 21.8.4
  • OCI_ATTR_SUBSCR_CQ_CHNF_QOSFLAGS 21.8.4
  • OCI_ATTR_SUBSCR_TIMEOUT 21.8.4
  • OCI_DTYPE_CQDES 21.8.6.1.1
  • OCI_SECURE_NOTIFICATION 21.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 21.8.4
  • OCIAnyData and OCIAnyDataSet interfaces 9.5.6
  • ODP.NET 22.10
  • online application upgrade
    • See: edition-based redefinition (EBR)
  • operator
  • optimizer
  • ora$base edition 35.2, 35.2.2
  • Oracle Advanced Queuing (AQ) 25.2.2
  • Oracle backend for Microservices and AI
  • Oracle C++ Call Interface 22.8
    • building application with 22.8.4
    • kinds of functions in 22.8.2
    • native floating-point data types in 9.3.7
    • procedural and nonprocedural elements of 22.8.3
  • Oracle Call Interface 22.8
    • building application with 22.8.4
    • commit redo action in 8.2.3
    • compared to precompiler 22.9
    • kinds of functions in 22.8.2
    • native floating-point data types in 9.3.7
    • procedural and nonprocedural elements of 22.8.3
    • with Oracle XA 32.3.5
  • Oracle Database Tuning Pack 3.3.4
  • Oracle Database Vault 5.3
  • Oracle Data Provider for .NET 22.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 24.11
  • Oracle Flashback Query 24.3
  • Oracle Flashback Technology 24.1
    • application development features 24.1.1
    • configuring database for 24.2
    • database administration features 24.1.2
    • performance guidelines for 24.12
  • Oracle Flashback Transaction Query 24.5
  • Oracle Flashback Version Query 24.4
  • Oracle JDBC 22.4.2
  • Oracle JDeveloper, Oracle SQLJ and 22.4.3.1
  • Oracle JVM 22.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 32.5.3
    • runtime connection load balancing and 2.4.1
  • Oracle sessionless transactions 33
    • benefits 33.4
    • capabilities 33.3
    • committing a sessionless transaction 33.5.10.1, 33.5.10.2
    • draining sessionless transactions 33.8
    • errors messages 33.5.13
    • finalizing a sessionless transaction 33.5.10
    • introduction 33.1
    • lifecycle 33.5.2
    • OCI example 33.5.11
    • Oracle Coordinated Distributed Transaction interoperability 33.6
    • overview 33.2
    • restrictions 33.7
    • resuming a suspended sessionless transaction 33.5.9
    • rules and guidelines 33.5.12
    • starting a new sessionless transaction 33.5.6
    • suspending a sessionless transaction 33.5.8
    • using 33.5
      • active sessionless transaction 33.5.1
      • getting a GTRID 33.5.7
      • prerequisites 33.5.4
      • server round trips pre-call and post-call functions 33.5.3
      • setting a GTRID 33.5.5
      • timeout of suspended sessionless transaction 33.5.8.1
  • Oracle SQLJ 22.4.3
  • Oracle Text 9.5.4
  • Oracle Total Recall 24.9
  • Oracle Tuxedo 32.1.1
  • Oracle Virtual Private Database
    • Oracle Flashback Data Archive 24.11
  • Oracle Virtual Private Database (VPD) 5.3
  • Oracle XA
  • out-of-space error 8.9
  • overloaded subprogram 16.1

P

  • package
  • package body 16.2
  • package invalidation and 16.12
  • package specification 16.2
  • package subprogram 16.1
  • PARALLEL_ENABLE function
  • parallelized SQL statement 16.10.4.2
  • parameter
    • compilation
      • See compilation parameter 16.3
    • initialization 16.3
  • partition-extended editioning view name 35.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 25.3
  • phantom read 8.6.1
  • physical design 3.1.1.2.2
  • PL/Scope 16.11, 17.1
  • PL/Scope security model 17.2
  • PL/Scope tool 17
  • PL/SQL block 16.1
  • PL/SQL data type 16.4.4
  • PL/SQL function result cache 16.4.7
  • PL/SQL gateway 20.2.1
  • PL/SQL hierarchical profiler 18
  • PL/SQL Hierarchical Profiler 16.11
  • PL/SQL language 22.3
    • compared to Java 22.6
  • PL/SQL object
    • See: PL/SQL unit
  • PL/SQL optimize level 16.3.1
  • PL/SQL optimizer level 7.3
  • PL/SQL unit 16.3
  • PL/SQL Web Toolkit 20.2.2
  • PLS_INTEGER data type 16.4.4.1.3
  • plshprof utility 18.5
  • PLSQL_CODE_COVERAGE package 19.3
  • pool, connection 22.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 35.2.1
  • precompiler 22.7
    • compared to Oracle Call Interface 22.9
    • Oracle XA and 32.3.4
  • pre-validating JSON data 13.14
    • enabling precheck for a new table 13.14.2
    • enabling precheck for an exisitng table 13.14.3
    • guidelines for PRECHECK constraints 13.14.4
    • precheck syntax and definition 13.14.1
    • supported conditions for JSON schema validation 13.14.1.1
  • PRIMARY KEY constraint 13.7
  • primary key dependency 24.8.1
  • privileges 5.1
    • for debugging subprogram 16.11.3.2
    • for defining constraint 13.15.1
    • for Oracle Flashback Technology 24.2.5
    • for running subprogram 16.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 34.4.2
  • Pro*C/C++ precompiler 22.7.1
    • native floating-point data types in 9.3.7
  • Pro*COBOL precompiler 22.7.2
  • procedure 16.1
    • See also: subprogram
  • product code 27.7.2
  • profiler 18
  • program interface 22.2
  • programming environment 22
  • public information, required 32.1.2
  • publish-subscribe model 25
  • purity of function 16.10.4

Q

  • quality-of-service flag 21.7.6.2
  • query
    • registering for Continuous Query Notification 21.6
    • returning results to client 16.4.5
  • Query Result Change Notification (QRCN) 21.2
  • query rewrite 1.9.2
  • queue 25.3

R

  • Radio Frequency Identification (RFID) technology 27.7.1
  • RAW data type 9.5.2.2
  • raw data type class 34.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 35.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 35.4.1
  • record 16.4.4.2
  • redefinition, edition-based (EBR) 35.1
  • redo information for transaction 8.2.3
  • redo management 8.2.3
  • REF CURSOR data type 16.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 32.1.1
    • for Continuous Query Notification 21.6
    • in publish-subscribe model 25.3
    • static 32.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 34.9
  • remote procedure call dependency management 34.10
  • remote subprogram 16.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 32.1.2
  • RESET_STATE 6.5.1
  • resource manager (RM) 32.1.1
  • RESTRICT_REFERENCES pragma
  • RESULT_CACHE_MODE session parameter 3.5.3.3
  • RESULT_CACHE hint 3.5.3.1
  • result cache 16.4.7
  • resumable storage allocation 8.9
  • RETENTION GUARANTEE clause for undo tablespace 24.2.1
  • RETENTION option of ALTER TABLE statement 24.2.4
  • RETURN_RESULT procedure 16.4.5.3
  • reverse crossedition trigger 35.5.2
  • reverse crossedition trigger SQL 35.5.3.2.2
  • RFID (Radio Frequency Identification) technology 27.7.1
  • RM (resource manager) 32.1.1
  • roles 5.1
  • root edition 35.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 34.10
  • RR datetime format element 9.4.1
  • rule on queue 25.3
  • rules engine 25.3
  • runtime connection load balancing 2.4
  • runtime error
    • See: exception

S

  • scalability 3
  • scalar PL/SQL data type 16.4.4.1
  • schema object dependency 34
    • in distributed database 34.9
    • invalidation and 34.4
    • on nonexistence of other objects 34.7
    • revoked privileges and 34.4.2
    • shared pool and 34.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 16.4.8.2
    • referencing collection with 16.4.8.2
    • with AS OF clause 24.3
    • with FOR UPDATE clause
      • See SELECT FOR UPDATE statement 8.4.4
    • with VERSIONS BETWEEN clause 24.4
  • semi-available table 35.4.1
  • serendipitous change 35.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 22.1.2
  • service routine, C external subprogram and 23.12
  • session cursor 16.4.5
  • session edition 35.2.6
  • session purity 3.10.7
  • session state 34.4.1
  • session variable 16.9.2
  • set based processing 4.3.2
  • SET CONSTRAINTS statement 13.9.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 16.10.4
  • signature checking 34.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 35.4.7
  • SQL statement
  • SQL Trace facility (SQL_TRACE) 3.2.2
  • SQL Tuning Advisor 3.3.4
  • standalone subprogram 16.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 32.1.1
  • static SQL, RESTRICT_REFERENCES pragma and 16.10.4.3.3
  • static variable, in C external subprogram 23.13.7
  • statistics
    • for application 18
    • for identifier 17
  • storage allocation error 8.9
  • storage requirements, decreasing 9.1.2
  • stored standalone subprogram, dropping 16.7
  • stored subprogram 16.1
  • subnormal floating-point number 9.3.2.1
  • subprogram 16.1
  • subscriber 25.3
  • subscription services 25.3
  • subtype 16.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 35.4.1
    • with semi-availability 35.4.1
  • table annotation 3.5.3.2
  • table DDL change notification 37
  • table result cache mode
  • Tag Data Translation Markup Language Schema 27.1
  • Temporal Validity Support 1.9.4
  • temporary LOB instance 9.5.2.1
  • thin client configuration 22.1.3
  • thread-safe application 32.3.9
  • three-tier architecture 22.1.3
  • tight coupling 32.1.1
  • time 9.4
    • See also: datetime data types
  • time-stamp checking 34.9.1
  • time-stamp dependency mode 34.10.1
  • TM (transaction manager) 32.1.1
  • TPM (transaction processing monitor) 32.1.1
  • tracing tools 16
  • transaction
  • transaction guard
    • rolling operation support 36.7
    • transient logical standby 36.7.1
  • Transaction Guard 8.2.4, 36
  • transaction history table 36.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) 32.1.1
  • transaction processing monitor (TPM) 32.1.1
  • transaction set consistency 8.6.4.1
  • transform 35.5.1
  • Transparent Application Continuity
  • trigger 16.1
    • AFTER SUSPEND 8.9.2.1
    • as autonomous transaction 8.9.2.1
    • automating database login with 5.2
    • compared to constraint 13.2
    • crossedition
      • See crossedition trigger 35.5
    • enforcing referential integrity with 8.6.3
    • in edition
    • invoking subprogram from 16.9.3
    • size limit for 16.4.3
  • TRUST assertion (deprecated) 16.10.4.3.2
  • TRUST keyword in RESTRICT_REFERENCES pragma 16.10.4.3.2
  • two-phase commit protocol 32.1.1
  • two-tier architecture 22.1.3
  • TX interface 32.1.1

U

  • undetected deadlock 8.5
  • UNDO_RETENTION parameter 8.3
  • undo data 24.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 16.4.4.1.5
  • user interface 22.2.1
    • stateful and stateless 22.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 20.1
  • web services 22.4.6
  • web toolkit
    • See: PL/SQL Web Toolkit
  • wrap utility, debugging and 16.11.3.1
  • writability of editioning view 35.4.3
  • write-after-write dependency 24.8.1

X

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

Y

  • YY datetime format element 9.4.2