Index
A
- Abstract Data Type (ADT) 13.4.4.3
- native floating-point data types in 9.3.7
- resetting evolved 27.2.1.4.2
- ACCESSIBLE BY clause
- actualization 27.2.3
- actual object 27.2.3
- ADDM (Automatic Database Diagnostic Monitor) 3.3.1
- address of row (rowid) 9.6
- administrators, restricting with Oracle Database Vault 5.3
- ADT
- See: Abstract Data Type (ADT)
- AFTER SUSPEND trigger 8.9.2.1
- agent 23.3
- aggregate function 13
- ALL_ARGUMENTS 14.6
- ALL_DEPENDENCIES 14.6
- ALL_ERRORS 14.6
- ALL_IDENTIFIERS 14.6
- ALL_STATEMENTS 14.6
- altering application online
- See: edition-based redefinition (EBR)
- analytic function 1.9.1
- ancestor edition 27.2.2
- ANSI data type 9.5.6
- ANYDATA data type 9.5.5
- ANYDATASET data type 9.5.5
- AP (application program) 22.1.1
- application architecture 20.1
- application domain index 11.3
- application program (AP) 22.1.1
- application SQL 27.4.3.2.3
- APPLYING_CROSSEDITION_TRIGGER function 27.4.4.1.1
- AQ (Oracle Advanced Queuing) 23.2.2
- archive
- See Flashback Data Archive 19.9
- ARGn data type 9.7.1
- arithmetic operation
- assignment, reported by PL/Scope 14.5.1.2
- auditing
- auditing policy, editioning view and 27.6.1
- AUTHID clause
- AUTHID property
- Automatic Database Diagnostic Monitor (ADDM) 3.3.1
- Automatic Undo Management system 19.1
- Automatic Workload Repository (AWR) 3.5.6
- autonomous transaction 8.8
- auto-tuning OCI client statement cache 3.7
B
- 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 13.1
- blocking DDL statement 8.7
- BOOLEAN data type 13.4.4.1.2
- branch 22.1.1
- built-in data type
- See: SQL data type
- built-in function
- See: SQL function
- bulk binding 13.4.8
- business rule 12
C
- calling subprogram
- See: invoking subprogram
- call specification
- CALL statement 21.10
- cascading invalidation 26.4
- C external subprogram 21.13
- See also: external subprogram
- CHANGE_DUPKEY_ERROR_INDEX hint 27.4.4.1.1
- character data type class 26.10.2.4
- character data types 9.2
- character large object (CLOB) data type 9.5.2.1
- CHAR data type 9.2
- CHECK constraint
- CLIENT_RESULT_CACHE_LAG server initialization parameter 3.5.5.1.3
- CLIENT_RESULT_CACHE_SIZE server initialization parameter 3.5.5.1.2
- client/server architecture 20.1.1
- client configuration parameter 3.5.5.2
- client notification 23.2.3
- client result cache 3.5
- client statement cache auto-tuning (OCI client session feature) 3.7
- CLOB data type 9.2
- coarse-grained invalidation 26.4
- collection 13.4.4.2
- column
- generated 27.2.1.2.2
- multiple foreign key constraints on 12.8.3
- virtual 27.2.1.2.2
- when to use default value for 12.5
- commit redo management 8.2.3
- COMPATIBLE server initialization parameter 3.5.5.1.1
- compilation parameter 13.3
- composite PL/SQL data type 13.4.4.2
- concurrency
- conditional compilation 7.6
- connection class 3.10.6.2
- connection pool 20.6.1
- connection pools
- constraint 12, 12.4
- altering 12.15
- CHECK
- See CHECK constraint 12.12
- compared to trigger 12.1
- crossedition trigger and
- collisions 27.4.4.1.1
- dropping 27.4.6
- deferring checking of 12.8.4
- disabling
- dropping 12.17
- editioning view and 27.3.6
- enabling
- exception to 12.14.7
- FOREIGN KEY
- See FOREIGN KEY constraint 12.8
- minimizing overhead of 12.9
- naming 12.13.2
- on view 12
- PRIMARY KEY
- See PRIMARY KEY constraint 12.6
- privileges needed for defining 12.13.1
- referential integrity
- See FOREIGN KEY constraint 12.8
- renaming 12.16
- UNIQUE
- See UNIQUE constraint 12.7
- viewing definition of 12.19
- violation of 12.14.7
- Continuous Query Notification (CQN) 3.9, 18
- example 18.8.7
- converting data types
- See: data type conversion
- copy-on-change strategy 27.2.3
- coupling 22.1.1
- CQ_NOTIFICATION$_DESCRIPTOR object 18.10.1
- CQ_NOTIFICATION$_QUERY object 18.10.3
- CQ_NOTIFICATION$_REG_INFO object 18.7.6.2
- CQ_NOTIFICATION$_ROW object 18.10.4
- CQ_NOTIFICATION$_TABLE object 18.10.2
- CQN (Continuous Query Notification) 18
- CREATE_COVERAGE_TABLES procedure 16.3
- CREATE OR REPLACE optimization 26.4
- actualization and 27.2.3
- crossedition trigger 27.4
- crossedition trigger SQL
- forward 27.4.3.2.1
- reverse 27.4.3.2.2
- cross-session PL/SQL function result cache 13.4.7
- current date and time, displaying 9.4.1
- current edition 27.2.6
- cursor 13.4.5
- cursor variable 13.4.4.1.4
D
- database hardening 19.9
- database logins, automated 5.2
- Database Resident Connection Pool (DRCP) 3.10
- data cartridge 1.3.1
- data definition language statement
- See: DDL statement
- data integrity 12
- See also: constraint
- data type and 9.1.1
- data modeling 3.1.1
- data type
- ANSI 9.5.6
- BOOLEAN 13.4.4.1.2
- DB2 9.5.6
- dynamic 9.5.5
- 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.4
- importance of correct 9.1
- PL/SQL 13.4.4
- PLS_INTEGER 13.4.4.1.3
- REF CURSOR 13.4.4.1.4
- SQL 9
- SQL/DS 9.5.6
- data type class 26.10.2.4
- data type conversion
- data type family
- date 9.4
- See also: datetime data types
- datetime data type class 26.10.2.4
- datetime data types 9.4
- day, default value for 9.4.3
- DB2 data type 9.5.6
- DBA_STATEMENTS 14.5.2
- DBA_STATEMENTS.SIGNATURE 14.5.2.4
- DBA_STATEMENTS.TYPE Column 14.5.2.1
- DBA_STATEMENTS.USAGE_CONTEXT_ID 14.5.2.3
- DBA_STATEMENTS.USAGE_ID 14.5.2.2
- DBMS_APPLICATION_INFO package 3.2.1
- DBMS_DEBUG_JDWP 13.11.3
- DBMS_DEBUG_JDWP package 13.11
- DBMS_FLASHBACK_ARCHIVE procedures 19.9
- DBMS_FLASHBACK.TRANSACTION_BACKOUT procedure 19.8
- DBMS_FLASHBACK package 19.7
- DBMS_HPROF.ANALYZE 15.5.2.6
- DBMS_HPROF package 15.2
- DBMS_LOCK package 8.5
- DBMS_OUTPUT package 13.11
- DBMS_PARALLEL_EXECUTE package 27.4.5
- DBMS_PLSQL_CODE_COVERAGE 16.1, 16.2
- DBMS_SQL.RETURN_RESULT procedure 13.4.5.3
- DBMS_STATS package 19.11
- DBMS_TYPES package 9.5.5
- DBMS_XA package 22.3.10
- DDL_LOCK_TIMEOUTparameter 8.7
- DDL statement
- deadlock, undetected 8.5
- debugging
- decimal floating-point number 9.3.2
- default column value 12.5
- deferring constraint checks 12.8.4
- definer’s rights 5.4.1
- denormal floating-point number 9.3.2.1
- dependency mode 26.10
- dependent object
- See: schema object dependency
- dependent transaction 19.8.1
- DEPRECATE PRAGMA 13.6
- descendent edition 27.2.2
- design
- DETERMINISTIC function
- dirty read 8.6.1
- disabling constraint
- distributed database
- distributed transaction 22.1.1
- remote subprogram and 13.9.4.2
- DLL (dynamic link library) 21.2
- DML_LOCKS initialization parameter 8.4
- DML statement
- domain index 11.3
- double-precision IEEE 754 format 9.3.2
- drivers, Oracle JDBC 20.4.2.1
- DTP (X/Open Distributed Transaction architecture) 22.1
- dynamically typed data 9.5.5
- dynamic link library (DLL) 21.2
- dynamic registration 22.1.1
- dynamic SQL 13.4.9
- implicit query results and 13.4.5.3
- RESTRICT_REFERENCES pragma and 13.10.4.3.3
E
- EBR (edition-based redefinition) 27.1
- edition 27.2
- ancestor 27.2.2
- creating 27.2.2
- crossedition triggers and 27.4.3
- current 27.2.6
- descendent 27.2.2
- displaying information about 27.5.1
- dropping 27.2.8
- enabling for user and types 27.2.1.4
- evaluation
- See evaluation edition 27.2.1.2
- leaf 27.2.2
- making available
- ora$base 27.2, 27.2.2
- retiring 27.2.7
- root 27.2.2
- scope of 27.2
- session 27.2.6
- unusable
- See unusable edition 27.2.1.2.1
- visibility of trigger in 27.4.3.1
- EDITIONABLE property 27.2.1.5
- editionable schema object type 27.2.1.3
- edition-based redefinition (EBR) 27.1
- editioned object 27.2.1
- creating or replacing 27.2.1.5.1
- name resolution and 27.2.1.1
- editioning view 27.3
- auditing policy and 27.6.1
- changing base table of 27.3.5
- changing writability of 27.3.3
- covering table with 27.6.1
- creating 27.3.1
- displaying information about 27.5.2
- partition-extended name for 27.3.2
- preparing application for 27.6.1
- read-only 27.3.1
- read-write 27.3.1
- replacing 27.3.4
- scope of 27.2
- SQL optimizer hint and 27.3.7
- Electronic Product Code (EPC) 25.7.2.1
- embedded PL/SQL gateway 17.2.1.2
- how to use 17.4
- enabling constraint
- enabling editions 27.2.1.4
- encoding scheme, adding 25.3.4
- environment, programming 20
- EPC (Electronic Product Code) 25.7.2.1
- evaluation edition 27.2.1.2
- dropping edition and 27.2.8
- for materialized view 27.2.1.2.1
- for virtual column 27.2.1.2.2
- retiring edition and 27.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 13.4.1
- execution plan 3.2.3
- data type and 9.1.3
- EXPLAIN PLAN statement 3.2.3
- explicit cursor 13.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 22.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 27.6.1
- fine-grained invalidation 26.4
- firing order of triggers 27.4.3.3
- FIXED_DATE initialization parameter 9.4.1
- fixed-point data type 9.3
- Flashback Data Archive 19.9
- Flashback Transaction 19.8
- FLOAT data type 9.3
- floating-point data type 9.3
- See also: native floating-point data type
- range and precision of 9.3.2
- floating-point number
- FORCE option of ALTER USER statement 27.2.1.4.1
- FOREIGN KEY constraint 12.8
- distributed databases and 12.11
- dropping 12.17
- editioned view and 27.2.1.6
- enabling 12.18
- Flashback Transaction and 19.8.1
- indexing 12.10
- multiple 12.8.3
- naming 12.13.2
- NOT NULL constraint on 12.8.2
- NULL value and 12.8.1
- privileges needed to create 12.18.4
- referential integrity enforced by 12.18.5
- UNIQUE constraint on 12.8.2
- without other constraints 12.8.2
- foreign key dependency 19.8.1
- FOR loop
- forward compatibility 1.3
- forward crossedition trigger 27.4.1
- forward crossedition trigger SQL 27.4.3.2.1
- function 13.1
- See also: subprogram
- aggregate 13
- analytic 1.9.1
- built-in
- See SQL function 9.7
- DETERMINISTIC
- invoking from SQL statement 13.10
- MGD_ID ADT 25.3.3
- OCI or OCCI 20.7.2
- PARALLEL_ENABLE, RPC signature and 26.10.2
- PL/SQL, invoked by SQL statement 13.10
- purity of 13.10.4
- RPC signature and 26.10.2
- result-cached 13.4.7
- returning large amount of data from 13.4.6
- SQL
- See SQL function 9.4.5
- SQL analytic 1.9.1
- function-based index 11.4
- function result cache 13.4.7
I
- IA-32 and IA-64 instruction set architecture 9.3.5
- IBM CICS 22.1.1
- IBM Transarc Encina 22.1.1
- Identity Code Package 25
- IEEE 754 standard 9.3
- See also: native floating-point data type
- IGNORE_ROW_ON_DUPKEY_INDEX hint 27.4.4.1.1
- IMMEDIATE commit redo option 8.2.3
- implementing database application 3.1.1.3
- implicit cursor 13.4.5
- independent transaction
- See: autonomous transaction
- index 11
- infinity 9.3.3
- in-flight transaction 8.2.4
- INHERIT ANY PRIVILEGES system privilege 5.4.2
- inherited object 27.2.3
- INHERIT PRIVILEGES privilege 5.4.2
- initialization parameter 13.3
- instrumentation 4.2
- integer data type class 26.10.2.4
- integrity constraint
- See: constraint
- integrity of data
- See: data integrity
- interface 20.7
- See also: Oracle C++ Call Interface, Oracle Call Interface
- invalidation
- invoker’s rights 5.4.1
- invoking subprogram 13.9
- isolation level
- See: transaction isolation level
- iterative data processing
J
L
- Large Object (LOB) 9.5.2.1
- leaf edition 27.2.2
- LGWR (log writer process) 8.2.3
- lightweight queue 23.3
- live operation 27.1
- load balancing advisory FAN event 2.4.3
- LOB
- See: Large Object (LOB)
- locking row explicitly 8.4.4
- locking table
- LOCK TABLE statement 8.4.2
- SELECT FOR UPDATE statement with 8.4.5
- logical design 3.1.1.2.1
- logical transaction identifier (LTXID) 8.2.4.1
- logical value 13.4.4.1.2
- log writer process (LGWR) 8.2.3
- LONG and LONG RAW data types 9.5.2.2
- LONG data type 9.2
- loose coupling 22.1.1
- LTXID (logical transaction identifier) 8.2.4.1
M
- maintaining database and application 3.1.1.4
- main transaction 8.8
- managing default rights 5.4.3
- materialized view 1.9.2
- that depends on editioned object 27.2.1.2.1
- maximum availability of table 27.3.1
- memory advisor 3.3.4
- metacharacter in regular expression 10.1
- metadata for SQL operator or function 9.7
- metrics 3.1.2
- MGD_ID ADT 25.1
- MGD_ID database ADT function 25.3.3
- mod_plsql module 17.2.1.1
- mode
- MODIFY CONSTRAINT clause of ALTER TABLE statement 12.15
- modifying
- See: altering
- monitoring database performance 3.3
- multilanguage program 21.1
- error or exception in 21.11
- multiline mode 10.2
- multilingual data 10.4.2
N
- name resolution 26.7
- editions and 27.2.1.1
- NaN (not a number) 9.3.3
- national character large object (NCLOB) data type 9.5.2.1
- native execution 13.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 13.1
- NLS_DATE_FORMAT initialization parameter 9.4.1
- NO_RESULT_CACHE hint 3.5.3.1
- nonblocking DDL statement 8.7
- in autonomous transaction 8.8
- NONEDITIONABLE property 27.2.1.5
- noneditionable schema object type 27.2.1.3
- noneditioned object 27.2.1
- creating or replacing 27.2.1.5.1
- name resolution and 27.2.1.1
- that can depend on editioned object 27.2.1.2
- dropping edition and 27.2.8
- FORCE and 27.2.1.4.1
- nongreedy operator in regular expression 10.4.3
- nonpersistent queue 23.3
- normalized significand 9.3.2.1
- NOT NULL
- See NOT NULL constraint 12.4
- NOT NULL constraint
- NOWAIT commit redo option 8.2.3
- NOWAIT option of LOCK TABLE statement 8.4.2
- NULL value
- NUMBER data type 9.3
- number data type class 26.10.2.4
- numeric data types 9.3
- NVARCHAR2 data type 9.2
O
- object
- actual 27.2.3
- dependent
- See schema object dependency 26.1
- editioned
- See editioned object 27.2.1
- inherited 27.2.3
- large
- See Large Object (LOB) 9.5.2.1
- noneditioned
- See noneditioned object 27.2.1
- potentially editioned 27.2.1
- with noneditioned dependents 27.2.1.4.1
- referenced
- See schema object dependency 26.1
- size limit for PL/SQL stored 13.4.3
- object change notification 18.1
- OCCI
- See: Oracle C++ Call Interface
- OCI
- See: Oracle Call Interface
- OCI_ATTR_CHDES_DBNAME 18.8.6.1
- OCI_ATTR_CHDES_NFTYPE 18.8.6.1
- OCI_ATTR_CHDES_TABLE_CHANGES 18.8.6.1
- OCI_ATTR_CHDES_TABLE_NAME 18.8.6.1.2
- OCI_ATTR_CHDES_TABLE_OPFLAGS 18.8.6.1.2
- OCI_ATTR_CHDES_TABLE_ROW_CHANGES 18.8.6.1.2
- OCI_ATTR_CHDES_XID 18.8.6.1
- OCI_ATTR_CHNF_CHANGELAG 18.8.4
- OCI_ATTR_CHNF_ROWIDS 18.8.4
- OCI_ATTR_CQ_QUERYID 18.8.5
- OCI_ATTR_CQDES_OPERATION 18.8.6.1.1
- OCI_ATTR_CQDES_QUERYID 18.8.6.1.1
- OCI_ATTR_CQDES_TABLE_CHANGES 18.8.6.1.1
- OCI_ATTR_SESSION_STATE attribute 3.10.15
- OCI_ATTR_SUBSCR_CALLBACK 18.8.4
- OCI_ATTR_SUBSCR_CQ_CHNF_QOSFLAGS 18.8.4
- OCI_ATTR_SUBSCR_TIMEOUT 18.8.4
- OCI_DTYPE_CQDES 18.8.6.1.1
- OCI_SECURE_NOTIFICATION 18.8.3
- OCI_SESSGET_PURITY_NEW attribute 3.10.6.1
- OCI_SESSGET_PURITY_SELF attribute 3.10.6.1
- OCI_SESSION_STATELESS attribute 3.10.15
- OCI_SUBSCR_QOS_PURGE_ON_NTFN 18.8.4
- OCIAnyData and OCIAnyDataSet interfaces 9.5.5
- ODP.NET 20.9
- online application upgrade
- See: edition-based redefinition (EBR)
- operator
- optimizer
- ORA_SDTZ system variable
- effect of setting 24.4.12
- ora$base edition 27.2, 27.2.2
- Oracle Advanced Queuing (AQ) 23.2.2
- Oracle C++ Call Interface 20.7
- Oracle Call Interface 20.7
- Oracle Database Tuning Pack 3.3.4
- Oracle Database Vault 5.3
- Oracle Data Provider for .NET 20.9
- Oracle Data Redaction 5.3
- Oracle data type
- See: SQL data type
- Oracle Extensibility Architecture, data cartridges and 1.3.1
- Oracle Extensibility Architecture framework, user-defined aggregate functions and 1.3.3
- Oracle Flashback Query 19.3
- Oracle Flashback Technology 19.1
- Oracle Flashback Transaction Query 19.5
- Oracle Flashback Version Query 19.4
- Oracle JDBC 20.4.2
- Oracle JDeveloper, Oracle SQLJ and 20.4.3.1
- Oracle JVM 20.4.1
- Oracle Label Security 5.3
- Oracle Lock Management services 8.5
- Oracle Real Application Clusters (Oracle RAC)
- Oracle SQLJ 20.4.3
- Oracle Text 9.5.3
- Oracle Total Recall 19.9
- Oracle Tuxedo 22.1.1
- Oracle Virtual Private Database (VPD) 5.3
- editioning view and 27.6.1
- Oracle XA
- out-of-space error 8.9
- overloaded subprogram 13.1
P
- package
- package body 13.2
- package invalidation and 13.12
- package specification 13.2
- package subprogram 13.1
- PARALLEL_ENABLE function
- RPC signature and 26.10.2
- parallelized SQL statement 13.10.4.2
- parameter
- partition-extended editioning view name 27.3.2
- partitioning 1.9.3
- performance 3
- performance, data type and 9.1.3
- performance goals 3.1.2
- performance testing 3.4
- persistent LOB instance 9.5.2.1
- persistent queue 23.3
- phantom read 8.6.1
- physical design 3.1.1.2.2
- PL/Scope 13.11, 14.1
- PL/Scope security model 14.2
- PL/Scope tool 14
- PL/SQL block 13.1
- PL/SQL data type 13.4.4
- PL/SQL function result cache 13.4.7
- PL/SQL gateway 17.2.1
- PL/SQL hierarchical profiler 15
- PL/SQL Hierarchical Profiler 13.11
- PL/SQL language 20.3
- compared to Java 20.5
- PL/SQL object
- See: PL/SQL unit
- PL/SQL optimize level 13.3.1
- PL/SQL optimizer level 7.3
- PL/SQL unit 13.3
- PL/SQL Web Toolkit 17.2.2
- PLS_INTEGER data type 13.4.4.1.3
- plshprof utility 15.5
- PLSQL_CODE_COVERAGE package 16.3
- pool, connection 20.6.1
- positive infinity 9.3.3
- positive zero 9.3.3
- POSIX standard for regular expressions
- potentially editioned object 27.2.1
- with noneditioned dependents 27.2.1.4.1
- precompiler 20.6
- PRIMARY KEY constraint 12.6
- primary key dependency 19.8.1
- privileges 5.1
- for debugging subprogram 13.11.3.2
- for defining constraint 12.13.1
- for Oracle Flashback Technology 19.2.5
- for running subprogram 13.9.1
- granting secure application roles 5.1
- grouped into roles 5.1
- INHERIT ANY PRIVILEGES system privilege 5.4.2
- INHERIT PRIVILEGES privilege 5.4.2
- revoked, object dependency and 26.4.2
- Pro*C/C++ precompiler 20.6.1
- native floating-point data types in 9.3.7
- Pro*COBOL precompiler 20.6.2
- procedure 13.1
- See also: subprogram
- product code 25.7.2
- profiler 15
- program interface 20.2
- programming environment 20
- public information, required 22.1.2
- publish-subscribe model 23
- purity of function 13.10.4
- RPC signature and 26.10.2
R
- Radio Frequency Identification (RFID) technology 25.7.1
- RAW data type 9.5.2.2
- raw data type class 26.10.2.4
- READ COMMITTED transaction isolation level
- read consistency 8.4
- read lock 8.6.3
- read-only editioning view 27.3.1
- read-only transaction 8.3
- READ UNCOMMITTED transaction isolation level
- read-write editioning view 27.3.1
- record 13.4.4.2
- redefinition, edition-based (EBR) 27.1
- redo information for transaction 8.2.3
- redo management 8.2.3
- REF CURSOR data type 13.4.4.1.4
- referenced object
- See: schema object dependency
- referential integrity
- referential integrity constraint
- See: FOREIGN KEY constraint
- REGEXP_COUNT function 10.2
- REGEXP_INSTR function 10.2
- REGEXP_LIKE condition 10.2
- REGEXP_REPLACE function 10.2
- back reference operator in 10.4.1
- REGEXP_SUBSTR function 10.2
- registration
- regular expression 10
- remote dependency management 26.9
- remote procedure call dependency management 26.10
- remote subprogram 13.9.4
- repeatable read 8.3
- REPEATABLE READ transaction isolation level
- required public information 22.1.2
- resource manager (RM) 22.1.1
- RESTRICT_REFERENCES pragma
- for backward compatibility 13.10.4.3
- static and dynamic SQL and 13.10.4.3.3
- RESULT_CACHE_MODE session parameter 3.5.3.3
- RESULT_CACHE hint 3.5.3.1
- result cache 13.4.7
- resumable storage allocation 8.9
- RETENTION GUARANTEE clause for undo tablespace 19.2.1
- RETENTION option of ALTER TABLE statement 19.2.4
- RETURN_RESULT procedure 13.4.5.3
- reverse crossedition trigger 27.4.2
- reverse crossedition trigger SQL 27.4.3.2.2
- RFID (Radio Frequency Identification) technology 25.7.1
- RM (resource manager) 22.1.1
- roles 5.1
- root edition 27.2.2
- rounding floating-point numbers 9.3.2
- row
- 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 18.7.2.3
- ROW SHARE MODE option of LOCK TABLE statement 8.4.2.1
- RPC dependency management 26.10
- RPC signature and 26.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 13.4.4.1
- schema object dependency 26
- schema object type
- searchable text 9.5.3
- 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 27.3.1
- serendipitous change 27.4.5
- data transformation collisions and 27.4.4.1.1
- identifying 27.4.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 13.4.5
- session edition 27.2.6
- session purity 3.10.6.1
- session state 26.4.1
- session variable 13.9.2
- set based processing 4.3.2
- SET CONSTRAINTS statement 12.8.4
- Setting ORA_SDTZ system variable
- effect of 24.4.12
- SET TRANSACTION statement with READ ONLY option 8.3
- shared SQL area 8.1.2
- SHARE MODE option of LOCK TABLE statement 8.4.2.2
- SHARE ROW EXCLUSIVE MODE option of LOCK TABLE statement 8.4.2.3
- side effects of subprogram 13.10.4
- signature checking 26.9.1
- single-precision IEEE 754 format 9.3.2
- spatial data 9.5.1
- specification, package
- See: package specification
- SQL, dynamic
- See: dynamic SQL
- SQL/DS data type 9.5.6
- SQL Access Advisor 3.3.4
- SQL advisor 3.3.4
- SQL analytic function 1.9.1
- SQL area, shared 8.1.2
- SQL data type 9
- SQL function
- SQLJ
- See: Oracle SQLJ
- SQL optimizer hint and editioning view 27.3.7
- SQL statement
- application 27.4.3.2.3
- crossedition trigger
- forward 27.4.3.2.1
- reverse 27.4.3.2.2
- invoking PL/SQL function from 13.10
- parallelized 13.10.4.2
- processing
- SQL Trace facility (SQL_TRACE) 3.2.2
- SQL Tuning Advisor 3.3.4
- standalone subprogram 13.1
- state
- stateful session 3.10.16
- stateless session 3.10.16
- statement
- See: SQL statement
- statement caching 3.6
- statement-level read consistency 8.3, 8.4
- static pools
- used to prevent connection storms 2.1.2
- static registration 22.1.1
- static SQL, RESTRICT_REFERENCES pragma and 13.10.4.3.3
- static variable, in C external subprogram 21.13.7
- statistics
- storage allocation error 8.9
- storage requirements, decreasing 9.1.2
- stored standalone subprogram, dropping 13.7
- stored subprogram 13.1
- subnormal floating-point number 9.3.2.1
- subprogram 13.1
- subscriber 23.3
- subscription services 23.3
- subtype 13.4.4.1
- user-defined 13.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 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 22.3.9
- three-tier architecture 20.1.3
- tight coupling 22.1.1
- time 9.4
- See also: datetime data types
- time-stamp checking 26.9.1
- time-stamp dependency mode 26.10.1
- TIMESTAMP WITH LOCAL TIME ZONE
- examples 24.4.11
- TIMESTAMP WITH TIME ZONE
- examples 24.4.11
- TM (transaction manager) 22.1.1
- TPM (transaction processing monitor) 22.1.1
- tracing tools 13
- transaction
- autonomous 8.8
- trigger as 8.9.2.1
- choosing isolation level for 8.6.4.2
- dependent 19.8.1
- determining outcome after outage 8.2.4
- distributed 22.1.1
- remote subprogram and 13.9.4.2
- ensuring idempotence of 8.2.4
- global 22.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 13.9.4.2
- autonomous 8.8
- Transaction Guard 8.2.4, 28
- transaction history table 28.4.2
- transaction interaction
- transaction isolation level
- transaction-level read consistency 8.3
- transaction manager (TM) 22.1.1
- transaction processing monitor (TPM) 22.1.1
- transaction set consistency 8.6.4.1
- transform 27.4.1
- applying 27.4.5
- trigger 13.1
- TRUST assertion (deprecated) 13.10.4.3.2
- TRUST keyword in RESTRICT_REFERENCES pragma 13.10.4.3.2
- two-phase commit protocol 22.1.1
- two-tier architecture 20.1.3
- TX interface 22.1.1
U
- undetected deadlock 8.5
- UNDO_RETENTION parameter 8.3
- undo data 19.1
- Unicode
- unified auditing 5.6
- UNIQUE constraint
- crossedition trigger and 27.4.4.1.1
- dropping 12.17
- naming 12.13.2
- on FOREIGN KEY constraint 12.8.2
- when to use 12.7
- unrepeatable read 8.6.1
- unusable edition
- dropping edition and 27.2.8
- for materialized view 27.2.1.2.1
- retiring edition and 27.2.7
- upgrading applications online
- See: edition-based redefinition (EBR)
- UROWID data type 9.6
- user access
- See: security
- user-defined subtype 13.4.4.1.5
- user interface 20.2.1
- stateful and stateless 20.2.2
- user lock 8.5
- UTLLOCKT.SQL script 8.5.2
V
- VARCHAR2 data type 9.2
- VARCHAR data type 9.2
- VARCHAR data type class 26.10.2.4
- variable
- cursor
- See cursor variable 13.4.4.1.4, 13.4.5
- in C external subprogram
- cursor
- view
- constraint on 12
- editioned, FOREIGN KEY constraint and 27.2.1.6
- editioning
- See editioning view 27.3
- materialized 1.9.2
- that depends on editioned object 27.2.1.2.1
- virtual column 27.2.1.2.2
- VPD policy, editioning view and 27.6.1