Index
A
- Abstract Data Type (ADT) 14.4.4.3
- native floating-point data types in 9.3.7
- resetting evolved 33.2.1.4.2
- ACCESSIBLE BY clause
- accessor list
- See: ACCESSIBLE BY clause
- actualization 33.2.3
- actual object 33.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 14
- ALL_ARGUMENTS 15.6
- ALL_DEPENDENCIES 15.6
- ALL_ERRORS 15.6
- ALL_IDENTIFIERS 15.6
- ALL_STATEMENTS 15.6
- altering application online
- See: edition-based redefinition (EBR)
- analytic function 1.9.1
- ancestor edition 33.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) 30.1.1
- application architecture 20.1
- Application Continuity
- RESET_STATE 6.5.1
- application domain index 12.3
- application program (AP) 30.1.1
- application SQL 33.5.3.2.3
- APPLYING_CROSSEDITION_TRIGGER function 33.5.4.1.1
- AQ (Oracle Advanced Queuing) 23.2.2
- archive
- See Flashback Data Archive 22.9
- ARGn data type 9.7.1
- arithmetic operation
- assignment, reported by PL/Scope 15.5.1.2
- auditing
- auditing policy, editioning view and 33.7.1
- AUTHID clause
- AUTHID property
- Automatic Database Diagnostic Monitor (ADDM) 3.3.1
- Automatic Undo Management system 22.1
- Automatic Workload Repository (AWR) 3.5.7
- autonomous transaction 8.8
- auto-tuning OCI client statement cache 3.7
B
- backend for Microservices and AI 27
- backward compatibility
- 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 14.1
- blocking DDL statement 8.7
- BOOLEAN data type 14.4.4.1.2
- branch 30.1.1
- built-in data type
- See: SQL data type
- built-in function
- See: SQL function
- bulk binding 14.4.8
- business rule 13
C
- calling subprogram
- See: invoking subprogram
- call specification
- CALL statement 21.10
- cascading invalidation 32.4
- C external subprogram 21.13
- See also: external subprogram
- CHANGE_DUPKEY_ERROR_INDEX hint 33.5.4.1.1
- character data type class 32.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 20.1.1
- client configuration parameter 3.5.6.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 32.4
- collection 14.4.4.2
- column
- generated 33.2.1.2.2
- multiple foreign key constraints on 13.8.3
- virtual 33.2.1.2.2
- when to use default value for 13.5
- commit redo management 8.2.3
- COMPATIBLE server initialization parameter 3.5.6.1.1
- compilation parameter 14.3
- composite PL/SQL data type 14.4.4.2
- concurrency
- conditional compilation 7.6
- connection class 3.10.8
- connection pool 20.7.1
- connection pools
- constraint 13, 13.4
- altering 13.16
- CHECK
- See CHECK constraint 13.12
- compared to trigger 13.1
- crossedition trigger and
- collisions 33.5.4.1.1
- dropping 33.5.6
- deferring checking of 13.8.4
- disabling
- dropping 13.18
- editioning view and 33.4.6
- enabling
- exception to 13.15.7
- FOREIGN KEY
- See FOREIGN KEY constraint 13.8
- minimizing overhead of 13.9
- naming 13.14.2
- on view 13
- PRIMARY KEY
- See PRIMARY KEY constraint 13.6
- privileges needed for defining 13.14.1
- referential integrity
- See FOREIGN KEY constraint 13.8
- renaming 13.17
- UNIQUE
- See UNIQUE constraint 13.7
- viewing definition of 13.20
- violation of 13.15.7
- Continuous Query Notification (CQN) 3.9, 19
- example 19.8.7
- converting data types
- See: data type conversion
- copy-on-change strategy 33.2.3
- coupling 30.1.1
- CQ_NOTIFICATION$_DESCRIPTOR object 19.10.1
- CQ_NOTIFICATION$_QUERY object 19.10.3
- CQ_NOTIFICATION$_REG_INFO object 19.7.6.2
- CQ_NOTIFICATION$_ROW object 19.10.4
- CQ_NOTIFICATION$_TABLE object 19.10.2
- CQN (Continuous Query Notification) 19
- CREATE_COVERAGE_TABLES procedure 17.3
- CREATE OR REPLACE optimization 32.4
- actualization and 33.2.3
- crossedition trigger 33.5
- crossedition trigger SQL
- forward 33.5.3.2.1
- reverse 33.5.3.2.2
- cross-session PL/SQL function result cache 14.4.7
- current date and time, displaying 9.4.1
- current edition 33.2.6
- cursor 14.4.5
- cursor variable 14.4.4.1.4
D
- database hardening 22.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 type and 9.1.1
- data modeling 3.1.1
- data type
- ANSI 9.5.7
- BOOLEAN 14.4.4.1.2
- DB2 9.5.7
- dynamic 9.5.6
- external 9
- for character data 9.2
- for datetime data 9.4
- for geographic data 9.5.1
- for large amount of data 9.5.2
- for numeric data 9.3
- for spatial data 9.5.1
- for XML data 9.5.5
- importance of correct 9.1
- PL/SQL 14.4.4
- PLS_INTEGER 14.4.4.1.3
- REF CURSOR 14.4.4.1.4
- SQL 9
- SQL/DS 9.5.7
- data type class 32.10.2.4
- data type conversion
- data type family
- date 9.4
- See also: datetime data types
- datetime data type class 32.10.2.4
- datetime data types 9.4
- day, default value for 9.4.3
- DB2 data type 9.5.7
- DBA_STATEMENTS 15.5.2
- DBA_STATEMENTS.SIGNATURE 15.5.2.4
- DBA_STATEMENTS.TYPE Column 15.5.2.1
- DBA_STATEMENTS.USAGE_CONTEXT_ID 15.5.2.3
- DBA_STATEMENTS.USAGE_ID 15.5.2.2
- DBMS_APPLICATION_INFO package 3.2.1
- DBMS_DEBUG_JDWP 14.11.3
- DBMS_DEBUG_JDWP package 14.11
- DBMS_FLASHBACK_ARCHIVE_MIGRATE 22.9.8
- DBMS_FLASHBACK_ARCHIVE procedures 22.9
- DBMS_FLASHBACK.TRANSACTION_BACKOUT procedure 22.8
- DBMS_FLASHBACK package 22.7
- version query 22.7.1
- DBMS_HPROF.ANALYZE 16.5.2.6
- DBMS_HPROF package 16.2
- DBMS_LOCK package 8.5
- DBMS_OUTPUT package 14.11
- DBMS_PARALLEL_EXECUTE package 33.5.5
- DBMS_PLSQL_CODE_COVERAGE 17.1, 17.2
- DBMS_SQL.RETURN_RESULT procedure 14.4.5.3
- DBMS_STATS package 22.12
- DBMS_TYPES package 9.5.6
- DBMS_XA package 30.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 32.10
- dependent object
- See: schema object dependency
- dependent transaction 22.8.1
- DEPRECATE PRAGMA 14.6
- descendent edition 33.2.2
- design
- DETERMINISTIC function
- developing Java saga applications 28.8
- developing Java Saga applications A.1
- saga
annotations
- example program 28.8.5
- saga
annotations
- developing saga
applications 28
- JMS Interface
- PL/SQL
interface
- example program 28.7.1
- saga
framework
- aftersaga callback 28.10
- finalizing a saga 28.9
- lock-free reservation integration 28.9.2
- managing sagas using PL/SQL 28.7
- message propagation 28.6.5
- saga framework setup example 28.6.7
- SagaInitiatior class 28.8.4.4
- saga interface 28.8.4.1
- SagaMessageContext Class 28.8.4.2
- SagaParticipant class 28.8.4.3
- saga interface 28.8.4
- why 26.4.2.1
- developing Saga applications
- dirty read 8.6.1
- disabling constraint
- distributed database
- distributed transaction 30.1.1
- remote subprogram and 14.9.4.2
- DLL (dynamic link library) 21.2
- DML_LOCKS initialization parameter 8.4
- DML statement
- domain index 12.3
- double-precision IEEE 754 format 9.3.2
- drivers, Oracle JDBC 20.4.2.1
- DTP (X/Open Distributed Transaction architecture) 30.1
- dynamically typed data 9.5.6
- dynamic link library (DLL) 21.2
- dynamic registration 30.1.1
- dynamic SQL 14.4.9
- implicit query results and 14.4.5.3
- RESTRICT_REFERENCES pragma and 14.10.4.3.3
E
- EBR (edition-based redefinition) 33.1
- edition 33.2
- ancestor 33.2.2
- creating 33.2.2
- crossedition triggers and 33.5.3
- current 33.2.6
- descendent 33.2.2
- displaying information about 33.6.1
- dropping 33.2.8
- enabling for user and types 33.2.1.4
- evaluation
- See evaluation edition 33.2.1.2
- leaf 33.2.2
- making available
- ora$base 33.2, 33.2.2
- retiring 33.2.7
- root 33.2.2
- scope of 33.2
- session 33.2.6
- unusable
- See unusable edition 33.2.1.2.1
- visibility of trigger in 33.5.3.1
- EDITIONABLE property 33.2.1.5
- editionable schema object type 33.2.1.3
- edition-based redefinition (EBR) 33.1
- editioned object 33.2.1
- creating or replacing 33.2.1.5.1
- name resolution and 33.2.1.1
- editioning view 33.4
- auditing policy and 33.7.1
- changing base table of 33.4.5
- changing writability of 33.4.3
- covering table with 33.7.1
- creating 33.4.1
- displaying information about 33.6.2
- partition-extended name for 33.4.2
- preparing application for 33.7.1
- read-only 33.4.1
- read-write 33.4.1
- replacing 33.4.4
- scope of 33.2
- SQL optimizer hint and 33.4.7
- efficient table DDL change
notification
- overview 35.1
- Electronic Product Code (EPC) 25.7.2.1
- embedded PL/SQL gateway 18.2.1.2
- how to use 18.4
- enabling constraint
- enabling editions 33.2.1.4
- encoding scheme, adding 25.3.4
- enumeration use case domains 10.1.7
- environment, programming 20
- EPC (Electronic Product Code) 25.7.2.1
- evaluation edition 33.2.1.2
- dropping edition and 33.2.8
- for materialized view 33.2.1.2.1
- for virtual column 33.2.1.2.2
- retiring edition and 33.2.7
- exception
- exception handling 7.5
- for storage allocation error 8.9
- EXCLUSIVE MODE option of LOCK TABLE statement 8.4.2.4
- EXECUTE privilege 14.4.1
- execution plan 3.2.3
- data type and 9.1.3
- EXPLAIN PLAN statement 3.2.3
- explicit cursor 14.4.5
- EXPR data type 9.7.2
- expression
- extensibility 1.3
- external data type 9
- external large object (BFILE) data type 9.5.2.1
- external subprogram 21.2
- external transaction manager 30.1.1
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 33.7.1
- fine-grained invalidation 32.4
- firing order of triggers 33.5.3.3
- FIXED_DATE initialization parameter 9.4.1
- fixed-point data type 9.3
- Flashback Archive 22.9
- Flashback Data Archive 22.9
- Flashback Time Travel 22.9
- Flashback Transaction 22.8
- flexible use case
domains
- associating domains with columns when creating tables 10.1.6.2
- associating domains with existing columns 10.1.6.3
- creating 10.1.6.1
- disassociating a domain from a column 10.1.6.4
- using DML 10.1.6.2.1
- 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 33.2.1.4.1
- FOREIGN KEY constraint 13.8
- distributed databases and 13.11
- dropping 13.18
- editioned view and 33.2.1.6
- enabling 13.19
- Flashback Transaction and 22.8.1
- indexing 13.10
- multiple 13.8.3
- naming 13.14.2
- NOT NULL constraint on 13.8.2
- NULL value and 13.8.1
- privileges needed to create 13.19.4
- referential integrity enforced by 13.19.5
- UNIQUE constraint on 13.8.2
- without other constraints 13.8.2
- foreign key dependency 22.8.1
- FOR loop
- forward compatibility 1.3
- forward crossedition trigger 33.5.1
- forward crossedition trigger SQL 33.5.3.2.1
- function 14.1
- See also: subprogram
- aggregate 14
- analytic 1.9.1
- built-in
- See SQL function 9.7
- DETERMINISTIC
- invoking from SQL statement 14.10
- MGD_ID ADT 25.3.3
- OCI or OCCI 20.8.2
- PARALLEL_ENABLE, RPC signature and 32.10.2
- PL/SQL, invoked by SQL statement 14.10
- purity of 14.10.4
- RPC signature and 32.10.2
- result-cached 14.4.7
- returning large amount of data from 14.4.6
- SQL
- See SQL function 9.4.5
- SQL analytic 1.9.1
- function-based index 12.4
- function result cache 14.4.7
I
- IA-32 and IA-64 instruction set architecture 9.3.5
- IBM CICS 30.1.1
- IBM Transarc Encina 30.1.1
- Identity Code Package 25
- IEEE 754 standard 9.3
- See also: native floating-point data type
- IGNORE_ROW_ON_DUPKEY_INDEX hint 33.5.4.1.1
- IMMEDIATE commit redo option 8.2.3
- implementing database application 3.1.1.3
- implicit connection pooling 3.10.15
- implicit connection pooling)
- implicit cursor 14.4.5
- independent transaction
- See: autonomous transaction
- index 12
- infinity 9.3.3
- in-flight transaction 8.2.4
- INHERIT ANY PRIVILEGES system privilege 5.4.2
- inherited object 33.2.3
- INHERIT PRIVILEGES privilege 5.4.2
- initialization parameter 14.3
- instrumentation 4.2
- integer data type class 32.10.2.4
- integrity constraint
- See: constraint
- integrity of data
- See: data integrity
- interface 20.8
- See also: Oracle C++ Call Interface, Oracle Call Interface
- invalidation
- invoker’s rights 5.4.1
- invoking subprogram 14.9
- isolation level
- See: transaction isolation level
- iterative data processing
J
L
- Large Object (LOB) 9.5.2.1
- leaf edition 33.2.2
- LGWR (log writer process) 8.2.3
- lightweight queue 23.3
- live operation 33.1
- load balancing advisory FAN event 2.4.3
- LOB
- See: Large Object (LOB)
- lock-free reservation 29
- about CHECK constraints 29.3.4
- about concurrency in transactions 29.1
- adding or modifying reservable columns 29.3.3
- benefits 29.4
- comparing optimistic and lock-free reservation 29.3.1
- creating a reservable column 29.3.2
- examples 29.3.5
- guidelines 29.5
- inserts and deletes guidelines 29.5.3
- introduction 29.3
- querying reservable column views 29.3.6
- reservable column guidelines 29.5.1
- reservation journal table columns 29.3.2.1
- restrictions for reservation journal table 29.5.5
- terminology 29.2
- update statement guidelines 29.5.2
- locking row explicitly 8.4.4
- locking table
- lock-less reservation
- concurrent DDL guidelines 29.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 14.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 30.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
- that depends on editioned object 33.2.1.2.1
- maximum availability of table 33.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 25.1
- MGD_ID database ADT function 25.3.3
- microservice architecture 26
- mod_plsql module 18.2.1.1
- mode
- MODIFY CONSTRAINT clause of ALTER TABLE statement 13.16
- modifying
- See: altering
- monitoring database performance 3.3
- multi-column use case domains
- multilanguage program 21.1
- error or exception in 21.11
- multiline mode 11.2
- multilingual data 11.4.2
- multilingual engine 20.5
- built-in MLE modules 20.5.8.3.1
- calling JavaScript functions 20.5.8.4.1
- call specification overview 20.5.6
- concepts 20.5.2
- create MLE call specification clauses 20.5.8.4.2
- dynamic MLE execution overview 20.5.9.1
- invoking
JavaScript 20.5.7
- using MLE modules 20.5.8
- invoking JavaScriptusing dynamic MLE execution 20.5.9
- JavaScript MLE modules overview 20.5.5
- managing JavaScript MLE modules 20.5.8.3
- MLE environment overview 20.5.4
- MLE execution contexts 20.5.3
- other supported MLE features 20.5.11
- privileges 20.5.10
- running JavaScript code inline 20.5.9.4.1
- running JavaScript Code using files 20.5.9.4.2
- runtime isolation for dynamic execution 20.5.9.2
- runtime isolation using MLE module contexts 20.5.8.1
- specifying an environment for a call specification 20.5.8.2
- specifying an environment on a call specification 20.5.9.3
- user privileges 20.5.10.1
- using dynamic MLE execution 20.5.9.4
- using JavaScript MLE modules 20.5.8.4
N
- name resolution 32.7
- editions and 33.2.1.1
- NaN (not a number) 9.3.3
- national character large object (NCLOB) data type 9.5.2.1
- native execution 14.8
- native floating-point data type 9.3
- NCHAR data type 9.2
- NCLOB data type 9.2
- negative infinity 9.3.3
- negative zero 9.3.3
- nested subprogram 14.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 33.2.1.5
- noneditionable schema object type 33.2.1.3
- noneditioned object 33.2.1
- creating or replacing 33.2.1.5.1
- name resolution and 33.2.1.1
- that can depend on editioned object 33.2.1.2
- dropping edition and 33.2.8
- FORCE and 33.2.1.4.1
- nongreedy operator in regular expression 11.4.3
- nonpersistent queue 23.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
- NUMBER data type 9.3
- number data type class 32.10.2.4
- numeric data types 9.3
- NVARCHAR2 data type 9.2
O
- object
- actual 33.2.3
- dependent
- See schema object dependency 32.1
- editioned
- See editioned object 33.2.1
- inherited 33.2.3
- large
- See Large Object (LOB) 9.5.2.1
- noneditioned
- See noneditioned object 33.2.1
- potentially editioned 33.2.1
- with noneditioned dependents 33.2.1.4.1
- referenced
- See schema object dependency 32.1
- size limit for PL/SQL stored 14.4.3
- object change notification 19.1
- OCCI
- See: Oracle C++ Call Interface
- OCI
- See: Oracle Call Interface
- OCI_ATTR_CHDES_DBNAME 19.8.6.1
- OCI_ATTR_CHDES_NFTYPE 19.8.6.1
- OCI_ATTR_CHDES_TABLE_CHANGES 19.8.6.1
- OCI_ATTR_CHDES_TABLE_NAME 19.8.6.1.2
- OCI_ATTR_CHDES_TABLE_OPFLAGS 19.8.6.1.2
- OCI_ATTR_CHDES_TABLE_ROW_CHANGES 19.8.6.1.2
- OCI_ATTR_CHDES_XID 19.8.6.1
- OCI_ATTR_CHNF_CHANGELAG 19.8.4
- OCI_ATTR_CHNF_ROWIDS 19.8.4
- OCI_ATTR_CQ_QUERYID 19.8.5
- OCI_ATTR_CQDES_OPERATION 19.8.6.1.1
- OCI_ATTR_CQDES_QUERYID 19.8.6.1.1
- OCI_ATTR_CQDES_TABLE_CHANGES 19.8.6.1.1
- OCI_ATTR_SESSION_STATE attribute 3.10.22
- OCI_ATTR_SUBSCR_CALLBACK 19.8.4
- OCI_ATTR_SUBSCR_CQ_CHNF_QOSFLAGS 19.8.4
- OCI_ATTR_SUBSCR_TIMEOUT 19.8.4
- OCI_DTYPE_CQDES 19.8.6.1.1
- OCI_SECURE_NOTIFICATION 19.8.3
- OCI_SESSGET_PURITY_NEW attribute 3.10.7
- OCI_SESSGET_PURITY_SELF attribute 3.10.7
- OCI_SESSION_STATELESS attribute 3.10.22
- OCI_SUBSCR_QOS_PURGE_ON_NTFN 19.8.4
- OCIAnyData and OCIAnyDataSet interfaces 9.5.6
- ODP.NET 20.10
- online application upgrade
- See: edition-based redefinition (EBR)
- operator
- optimizer
- ora$base edition 33.2, 33.2.2
- Oracle Advanced Queuing (AQ) 23.2.2
- Oracle backend for Microservices and
AI
- about 27.2
- Oracle C++ Call Interface 20.8
- Oracle Call Interface 20.8
- Oracle Database Tuning Pack 3.3.4
- Oracle Database Vault 5.3
- Oracle Data Provider for .NET 20.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 22.11
- Oracle Flashback Query 22.3
- Oracle Flashback Technology 22.1
- Oracle Flashback Transaction Query 22.5
- Oracle Flashback Version Query 22.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 Real Application Clusters (Oracle RAC)
- Oracle sessionless transactions 31
- benefits 31.4
- capabilities 31.3
- committing a sessionless transaction 31.5.10.1, 31.5.10.2
- errors messages 31.5.13
- finalizing a sessionless transaction 31.5.10
- introduction 31.1
- lifecycle 31.5.2
- OCI example 31.5.11
- Oracle Coordinated Distributed Transaction interoperability 31.6
- overview 31.2
- example use cases 31.3.1
- restrictions 31.7
- resuming a suspended sessionless transaction 31.5.9
- rules and guidelines 31.5.12
- starting a new sessionless transaction 31.5.6
- running DML statements 31.5.6.1
- suspending a sessionless transaction 31.5.8
- using 31.5
- Oracle SQLJ 20.4.3
- Oracle Text 9.5.4
- Oracle Total Recall 22.9
- Oracle Tuxedo 30.1.1
- Oracle Virtual Private Database
- Oracle Flashback Data Archive 22.11
- Oracle Virtual Private Database (VPD) 5.3
- editioning view and 33.7.1
- Oracle XA
- out-of-space error 8.9
- overloaded subprogram 14.1
P
- package
- package body 14.2
- package invalidation and 14.12
- package specification 14.2
- package subprogram 14.1
- PARALLEL_ENABLE function
- RPC signature and 32.10.2
- parallelized SQL statement 14.10.4.2
- parameter
- partition-extended editioning view name 33.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 23.3
- phantom read 8.6.1
- physical design 3.1.1.2.2
- PL/Scope 14.11, 15.1
- PL/Scope security model 15.2
- PL/Scope tool 15
- PL/SQL block 14.1
- PL/SQL data type 14.4.4
- PL/SQL function result cache 14.4.7
- PL/SQL gateway 18.2.1
- PL/SQL hierarchical profiler 16
- PL/SQL Hierarchical Profiler 14.11
- PL/SQL language 20.3
- compared to Java 20.6
- PL/SQL object
- See: PL/SQL unit
- PL/SQL optimize level 14.3.1
- PL/SQL optimizer level 7.3
- PL/SQL unit 14.3
- PL/SQL Web Toolkit 18.2.2
- PLS_INTEGER data type 14.4.4.1.3
- plshprof utility 16.5
- PLSQL_CODE_COVERAGE package 17.3
- pool, connection 20.7.1
- positive infinity 9.3.3
- positive zero 9.3.3
- POSIX standard for regular expressions
- potentially editioned object 33.2.1
- with noneditioned dependents 33.2.1.4.1
- precompiler 20.7
- pre-validating JSON data 13.13
- PRIMARY KEY constraint 13.6
- primary key dependency 22.8.1
- privileges 5.1
- for debugging subprogram 14.11.3.2
- for defining constraint 13.14.1
- for Oracle Flashback Technology 22.2.5
- for running subprogram 14.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 32.4.2
- Pro*C/C++ precompiler 20.7.1
- native floating-point data types in 9.3.7
- Pro*COBOL precompiler 20.7.2
- procedure 14.1
- See also: subprogram
- product code 25.7.2
- profiler 16
- program interface 20.2
- programming environment 20
- public information, required 30.1.2
- publish-subscribe model 23
- purity of function 14.10.4
- RPC signature and 32.10.2
R
- Radio Frequency Identification (RFID) technology 25.7.1
- RAW data type 9.5.2.2
- raw data type class 32.10.2.4
- READ COMMITTED transaction isolation level
- read consistency 8.4
- read lock 8.6.3
- read-only editioning view 33.4.1
- read-only transaction 8.3
- READ UNCOMMITTED transaction isolation level
- read-write editioning view 33.4.1
- record 14.4.4.2
- redefinition, edition-based (EBR) 33.1
- redo information for transaction 8.2.3
- redo management 8.2.3
- REF CURSOR data type 14.4.4.1.4
- referenced object
- See: schema object dependency
- referential integrity
- 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
- regular expression 11
- remote dependency management 32.9
- remote procedure call dependency management 32.10
- remote subprogram 14.9.4
- repeatable read 8.3
- REPEATABLE READ transaction isolation level
- required public information 30.1.2
- RESET_STATE 6.5.1
- resource manager (RM) 30.1.1
- RESTRICT_REFERENCES pragma
- for backward compatibility 14.10.4.3
- static and dynamic SQL and 14.10.4.3.3
- RESULT_CACHE_MODE session parameter 3.5.3.3
- RESULT_CACHE hint 3.5.3.1
- result cache 14.4.7
- resumable storage allocation 8.9
- RETENTION GUARANTEE clause for undo tablespace 22.2.1
- RETENTION option of ALTER TABLE statement 22.2.4
- RETURN_RESULT procedure 14.4.5.3
- reverse crossedition trigger 33.5.2
- reverse crossedition trigger SQL 33.5.3.2.2
- RFID (Radio Frequency Identification) technology 25.7.1
- RM (resource manager) 30.1.1
- roles 5.1
- root edition 33.2.2
- rounding floating-point numbers 9.3.2
- row
- 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
- CQN and 19.7.2.3
- ROW SHARE MODE option of LOCK TABLE statement 8.4.2.1
- RPC dependency management 32.10
- RPC signature and 32.10.2
- 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 14.4.4.1
- schema object dependency 32
- 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
- SELECT statement
- semi-available table 33.4.1
- serendipitous change 33.5.5
- data transformation collisions and 33.5.4.1.1
- identifying 33.5.4.1.1
- serializable transaction
- SERIALIZABLE transaction isolation level 8.6.1
- See also: serializable transaction
- server-side programming 20.1.2
- service routine, C external subprogram and 21.12
- session cursor 14.4.5
- session edition 33.2.6
- session purity 3.10.7
- session state 32.4.1
- session variable 14.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 14.10.4
- signature checking 32.9.1
- single-column use case
domains
- creating 10.1.4.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 33.4.7
- SQL statement
- application 33.5.3.2.3
- crossedition trigger
- forward 33.5.3.2.1
- reverse 33.5.3.2.2
- invoking PL/SQL function from 14.10
- parallelized 14.10.4.2
- processing
- SQL Trace facility (SQL_TRACE) 3.2.2
- SQL Tuning Advisor 3.3.4
- standalone subprogram 14.1
- state
- stateful session 3.10.23
- stateless session 3.10.23
- 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 30.1.1
- static SQL, RESTRICT_REFERENCES pragma and 14.10.4.3.3
- static variable, in C external subprogram 21.13.7
- statistics
- storage allocation error 8.9
- storage requirements, decreasing 9.1.2
- stored standalone subprogram, dropping 14.7
- stored subprogram 14.1
- subnormal floating-point number 9.3.2.1
- subprogram 14.1
- subscriber 23.3
- subscription services 23.3
- subtype 14.4.4.1
- user-defined 14.4.4.1.5
- synonym
- SYSDATE function 9.4.1
- system management statement 8.1.1
T
- table
- table annotation 3.5.3.2
- table DDL change notification 35
- table result cache mode
- Tag Data Translation Markup Language Schema 25.1
- Temporal Validity Support 1.9.4
- temporary LOB instance 9.5.2.1
- thin client configuration 20.1.3
- thread-safe application 30.3.9
- three-tier architecture 20.1.3
- tight coupling 30.1.1
- time 9.4
- See also: datetime data types
- time-stamp checking 32.9.1
- time-stamp dependency mode 32.10.1
- TM (transaction manager) 30.1.1
- TPM (transaction processing monitor) 30.1.1
- tracing tools 14
- transaction
- autonomous 8.8
- trigger as 8.9.2.1
- choosing isolation level for 8.6.4.2
- dependent 22.8.1
- determining outcome after outage 8.2.4
- distributed 30.1.1
- remote subprogram and 14.9.4.2
- ensuring idempotence of 8.2.4
- global 30.1.1
- grouping operations into 8.2.1
- improving performance of 8.2.2
- in-flight 8.2.4
- main 8.8
- read-only 8.3
- redo entry for 8.2.3
- serializable
- See serializable transaction 8.6
- that invokes remote subprogram 14.9.4.2
- autonomous 8.8
- transaction guard
- Transaction Guard 8.2.4, 34
- transaction history table 34.4.2
- transaction interaction
- transaction isolation level
- transaction-level read consistency 8.3
- transaction manager (TM) 30.1.1
- transaction processing monitor (TPM) 30.1.1
- transaction set consistency 8.6.4.1
- transform 33.5.1
- applying 33.5.5
- Transparent Application Continuity
- RESET_STATE 6.5.1
- trigger 14.1
- TRUST assertion (deprecated) 14.10.4.3.2
- TRUST keyword in RESTRICT_REFERENCES pragma 14.10.4.3.2
- two-phase commit protocol 30.1.1
- two-tier architecture 20.1.3
- TX interface 30.1.1
U
- undetected deadlock 8.5
- UNDO_RETENTION parameter 8.3
- undo data 22.1
- Unicode
- unified auditing 5.6
- UNIQUE constraint
- crossedition trigger and 33.5.4.1.1
- dropping 13.18
- naming 13.14.2
- on FOREIGN KEY constraint 13.8.2
- when to use 13.7
- unrepeatable read 8.6.1
- unusable edition
- dropping edition and 33.2.8
- for materialized view 33.2.1.2.1
- retiring edition and 33.2.7
- upgrading applications online
- See: edition-based redefinition (EBR)
- UROWID data type 9.6
- use case domains 10.1
- altering 10.1.4.4
- built-in domains 10.1.12
- creating
- specifying data type 10.1.8
- dictionary views 10.1.11.1
- dropping 10.1.4.6
- drop domain and recycle bin 10.1.4.6.1
- overview 10.1.1
- SQL functions 10.1.3, 10.1.10
- use case domain types 10.1.2
- Using
- associating domains with columns when creating tables 10.1.4.2
- associating domains with existing columns 10.1.4.3
- changing the domain associated with a column 10.1.9
- disassociating a domain from a column 10.1.4.5
- using DML 10.1.4.2.1
- Using multi-column domains
- user access
- See: security
- user-defined subtype 14.4.4.1.5
- user interface 20.2.1
- stateful and stateless 20.2.2
- user lock 8.5
- using IF EXISTS and IF NOT EXISTS 8.10
- UTLLOCKT.SQL script 8.5.2
V
- VARCHAR2 data type 9.2
- VARCHAR data type 9.2
- VARCHAR data type class 32.10.2.4
- variable
- cursor
- See cursor variable 14.4.4.1.4, 14.4.5
- in C external subprogram
- cursor
- view
- constraint on 13
- editioned, FOREIGN KEY constraint and 33.2.1.6
- editioning
- See editioning view 33.4
- materialized 1.9.2
- that depends on editioned object 33.2.1.2.1
- virtual column 33.2.1.2.2
- VPD policy, editioning view and 33.7.1