Index
A
- Abstract Data Type (ADT) 14.4.4.3
- native floating-point data types in 10.3.7
- resetting evolved 28.2.1.4.2
- ACCESSIBLE BY clause
- accessor list
- See: ACCESSIBLE BY clause
- actualization 28.2.3
- actual object 28.2.3
- ADDM (Automatic Database Diagnostic Monitor) 4.3.1
- address of row (rowid) 10.6
- administrators, restricting with Oracle Database Vault 6.3
- ADT
- See: Abstract Data Type (ADT)
- AFTER SUSPEND trigger 9.9.2.1
- agent 24.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 2.9.1
- ancestor edition 28.2.2
- ANSI data type 10.5.7
- ANYDATA data type 10.5.6
- ANYDATASET data type 10.5.6
- AP (application program) 23.1.1
- application architecture 21.1
- application domain index 12.3
- application program (AP) 23.1.1
- application SQL 28.5.3.2.3
- APPLYING_CROSSEDITION_TRIGGER function 28.5.4.1.1
- AQ (Oracle Advanced Queuing) 24.2.2
- archive
- See Flashback Data Archive 20.9
- ARGn data type 10.7.1
- arithmetic operation
- assignment, reported by PL/Scope 15.5.1.2
- auditing
- auditing policy, editioning view and 28.7.1
- AUTHID clause
- AUTHID property
- Automatic Database Diagnostic Monitor (ADDM) 4.3.1
- Automatic Undo Management system 20.1
- Automatic Workload Repository (AWR) 4.5.6
- autonomous transaction 9.8
- auto-tuning OCI client statement cache 4.7
B
- backward compatibility
- BATCH commit redo option 9.2.3
- benchmark 4.1.3
- BINARY_DOUBLE data type 10.3
- BINARY_FLOAT data type 10.3
- BINARY_INTEGER data type
- See: PLS_INTEGER data type
- binary floating-point number 10.3.2
- binary format 10.3.2.1
- binary large object (BLOB) data type 10.5.2.1
- bind variables 5.1
- block, PL/SQL 14.1
- blocking DDL statement 9.7
- BOOLEAN data type 14.4.4.1.2
- branch 23.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 22.10
- cascading invalidation 27.4
- C external subprogram 22.13
- See also: external subprogram
- CHANGE_DUPKEY_ERROR_INDEX hint 28.5.4.1.1
- character data type class 27.10.2.4
- character data types 10.2
- character large object (CLOB) data type 10.5.2.1
- CHAR data type 10.2
- CHECK constraint
- CLIENT_RESULT_CACHE_LAG server initialization parameter 4.5.5.1.3
- CLIENT_RESULT_CACHE_SIZE server initialization parameter 4.5.5.1.2
- client/server architecture 21.1.1
- client configuration parameter 4.5.5.2
- client notification 24.2.3
- client result cache 4.5
- client statement cache auto-tuning (OCI client session feature) 4.7
- CLOB data type 10.2
- coarse-grained invalidation 27.4
- collection 14.4.4.2
- column
- generated 28.2.1.2.2
- multiple foreign key constraints on 13.8.3
- virtual 28.2.1.2.2
- when to use default value for 13.5
- commit redo management 9.2.3
- COMPATIBLE server initialization parameter 4.5.5.1.1
- compilation parameter 14.3
- composite PL/SQL data type 14.4.4.2
- concurrency
- conditional compilation 8.6
- connection class 4.10.7
- connection pool 21.6.1
- connection pools
- constraint 13, 13.4
- altering 13.15
- CHECK
- See CHECK constraint 13.12
- compared to trigger 13.1
- crossedition trigger and
- collisions 28.5.4.1.1
- dropping 28.5.6
- deferring checking of 13.8.4
- disabling
- dropping 13.17
- editioning view and 28.4.6
- enabling
- exception to 13.14.7
- FOREIGN KEY
- See FOREIGN KEY constraint 13.8
- minimizing overhead of 13.9
- naming 13.13.2
- on view 13
- PRIMARY KEY
- See PRIMARY KEY constraint 13.6
- privileges needed for defining 13.13.1
- referential integrity
- See FOREIGN KEY constraint 13.8
- renaming 13.16
- UNIQUE
- See UNIQUE constraint 13.7
- viewing definition of 13.19
- violation of 13.14.7
- Continuous Query Notification (CQN) 4.9, 19
- example 19.8.7
- converting data types
- See: data type conversion
- copy-on-change strategy 28.2.3
- coupling 23.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 27.4
- actualization and 28.2.3
- crossedition trigger 28.5
- crossedition trigger SQL
- forward 28.5.3.2.1
- reverse 28.5.3.2.2
- cross-session PL/SQL function result cache 14.4.7
- current date and time, displaying 10.4.1
- current edition 28.2.6
- cursor 14.4.5
- cursor variable 14.4.4.1.4
D
- database hardening 20.9
- database logins, automated 6.2
- Database Resident Connection Pool (DRCP) 4.10
- data cartridge 2.3.1
- data definition language statement
- See: DDL statement
- data integrity 13
- See also: constraint
- data type and 10.1.1
- data modeling 4.1.1
- data type
- ANSI 10.5.7
- BOOLEAN 14.4.4.1.2
- DB2 10.5.7
- dynamic 10.5.6
- external 10
- for character data 10.2
- for datetime data 10.4
- for geographic data 10.5.1
- for large amount of data 10.5.2
- for numeric data 10.3
- for spatial data 10.5.1
- for XML data 10.5.5
- importance of correct 10.1
- PL/SQL 14.4.4
- PLS_INTEGER 14.4.4.1.3
- REF CURSOR 14.4.4.1.4
- SQL 10
- SQL/DS 10.5.7
- data type class 27.10.2.4
- data type conversion
- data type family
- date 10.4
- See also: datetime data types
- datetime data type class 27.10.2.4
- datetime data types 10.4
- day, default value for 10.4.3
- DB2 data type 10.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 4.2.1
- DBMS_DEBUG_JDWP 14.11.3
- DBMS_DEBUG_JDWP package 14.11
- DBMS_FLASHBACK_ARCHIVE_MIGRATE 20.9.8
- DBMS_FLASHBACK_ARCHIVE procedures 20.9
- DBMS_FLASHBACK.TRANSACTION_BACKOUT procedure 20.8
- DBMS_FLASHBACK package 20.7
- DBMS_HPROF.ANALYZE 16.5.2.6
- DBMS_HPROF package 16.2
- DBMS_LOCK package 9.5
- DBMS_OUTPUT package 14.11
- DBMS_PARALLEL_EXECUTE package 28.5.5
- DBMS_PLSQL_CODE_COVERAGE 17.1, 17.2
- DBMS_SQL.RETURN_RESULT procedure 14.4.5.3
- DBMS_STATS package 20.12
- DBMS_TYPES package 10.5.6
- DBMS_XA package 23.3.10
- DDL_LOCK_TIMEOUTparameter 9.7
- DDL statement
- deadlock, undetected 9.5
- debugging
- decimal floating-point number 10.3.2
- default column value 13.5
- deferring constraint checks 13.8.4
- definer’s rights 6.4.1
- denormal floating-point number 10.3.2.1
- dependency mode 27.10
- dependent object
- See: schema object dependency
- dependent transaction 20.8.1
- DEPRECATE PRAGMA 14.6
- descendent edition 28.2.2
- design
- DETERMINISTIC function
- dirty read 9.6.1
- disabling constraint
- distributed database
- distributed transaction 23.1.1
- remote subprogram and 14.9.4.2
- DLL (dynamic link library) 22.2
- DML_LOCKS initialization parameter 9.4
- DML statement
- domain index 12.3
- double-precision IEEE 754 format 10.3.2
- drivers, Oracle JDBC 21.4.2.1
- DTP (X/Open Distributed Transaction architecture) 23.1
- dynamically typed data 10.5.6
- dynamic link library (DLL) 22.2
- dynamic registration 23.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) 28.1
- edition 28.2
- ancestor 28.2.2
- creating 28.2.2
- crossedition triggers and 28.5.3
- current 28.2.6
- descendent 28.2.2
- displaying information about 28.6.1
- dropping 28.2.8
- enabling for user and types 28.2.1.4
- evaluation
- See evaluation edition 28.2.1.2
- leaf 28.2.2
- making available
- ora$base 28.2, 28.2.2
- retiring 28.2.7
- root 28.2.2
- scope of 28.2
- session 28.2.6
- unusable
- See unusable edition 28.2.1.2.1
- visibility of trigger in 28.5.3.1
- EDITIONABLE property 28.2.1.5
- editionable schema object type 28.2.1.3
- edition-based redefinition (EBR) 28.1
- editioned object 28.2.1
- creating or replacing 28.2.1.5.1
- name resolution and 28.2.1.1
- editioning view 28.4
- auditing policy and 28.7.1
- changing base table of 28.4.5
- changing writability of 28.4.3
- covering table with 28.7.1
- creating 28.4.1
- displaying information about 28.6.2
- partition-extended name for 28.4.2
- preparing application for 28.7.1
- read-only 28.4.1
- read-write 28.4.1
- replacing 28.4.4
- scope of 28.2
- SQL optimizer hint and 28.4.7
- Electronic Product Code (EPC) 26.7.2.1
- embedded PL/SQL gateway 18.2.1.2
- how to use 18.4
- enabling constraint
- enabling editions 28.2.1.4
- encoding scheme, adding 26.3.4
- environment, programming 21
- EPC (Electronic Product Code) 26.7.2.1
- evaluation edition 28.2.1.2
- dropping edition and 28.2.8
- for materialized view 28.2.1.2.1
- for virtual column 28.2.1.2.2
- retiring edition and 28.2.7
- exception
- exception handling 8.5
- for storage allocation error 9.9
- EXCLUSIVE MODE option of LOCK TABLE statement 9.4.2.4
- EXECUTE privilege 14.4.1
- execution plan 4.2.3
- data type and 10.1.3
- EXPLAIN PLAN statement 4.2.3
- explicit cursor 14.4.5
- EXPR data type 10.7.2
- expression
- extensibility 2.3
- external data type 10
- external large object (BFILE) data type 10.5.2.1
- external subprogram 22.2
- external transaction manager 23.1.1
F
- family of data types
- FAN event, load balancing advisory 3.4.3
- Fast Application Notification (FAN) 3.4.1
- fine-grained access control 6.3
- fine-grained auditing (FGA) policy, editioning view and 28.7.1
- fine-grained invalidation 27.4
- firing order of triggers 28.5.3.3
- FIXED_DATE initialization parameter 10.4.1
- fixed-point data type 10.3
- Flashback Archive 20.9
- Flashback Data Archive 20.9
- Flashback Transaction 20.8
- FLOAT data type 10.3
- floating-point data type 10.3
- See also: native floating-point data type
- range and precision of 10.3.2
- floating-point number
- FORCE option of ALTER USER statement 28.2.1.4.1
- FOREIGN KEY constraint 13.8
- distributed databases and 13.11
- dropping 13.17
- editioned view and 28.2.1.6
- enabling 13.18
- Flashback Transaction and 20.8.1
- indexing 13.10
- multiple 13.8.3
- naming 13.13.2
- NOT NULL constraint on 13.8.2
- NULL value and 13.8.1
- privileges needed to create 13.18.4
- referential integrity enforced by 13.18.5
- UNIQUE constraint on 13.8.2
- without other constraints 13.8.2
- foreign key dependency 20.8.1
- FOR loop
- forward compatibility 2.3
- forward crossedition trigger 28.5.1
- forward crossedition trigger SQL 28.5.3.2.1
- function 14.1
- See also: subprogram
- aggregate 14
- analytic 2.9.1
- built-in
- See SQL function 10.7
- DETERMINISTIC
- invoking from SQL statement 14.10
- MGD_ID ADT 26.3.3
- OCI or OCCI 21.7.2
- PARALLEL_ENABLE, RPC signature and 27.10.2
- PL/SQL, invoked by SQL statement 14.10
- purity of 14.10.4
- RPC signature and 27.10.2
- result-cached 14.4.7
- returning large amount of data from 14.4.6
- SQL
- See SQL function 10.4.5
- SQL analytic 2.9.1
- function-based index 12.4
- function result cache 14.4.7
I
- IA-32 and IA-64 instruction set architecture 10.3.5
- IBM CICS 23.1.1
- IBM Transarc Encina 23.1.1
- Identity Code Package 26
- IEEE 754 standard 10.3
- See also: native floating-point data type
- IGNORE_ROW_ON_DUPKEY_INDEX hint 28.5.4.1.1
- IMMEDIATE commit redo option 9.2.3
- implementing database application 4.1.1.3
- implicit cursor 14.4.5
- independent transaction
- See: autonomous transaction
- index 12
- infinity 10.3.3
- in-flight transaction 9.2.4
- INHERIT ANY PRIVILEGES system privilege 6.4.2
- inherited object 28.2.3
- INHERIT PRIVILEGES privilege 6.4.2
- initialization parameter 14.3
- instrumentation 5.2
- integer data type class 27.10.2.4
- integrity constraint
- See: constraint
- integrity of data
- See: data integrity
- interface 21.7
- See also: Oracle C++ Call Interface, Oracle Call Interface
- invalidation
- invoker’s rights 6.4.1
- invoking subprogram 14.9
- isolation level
- See: transaction isolation level
- iterative data processing
J
L
- Large Object (LOB) 10.5.2.1
- leaf edition 28.2.2
- LGWR (log writer process) 9.2.3
- lightweight queue 24.3
- live operation 28.1
- load balancing advisory FAN event 3.4.3
- LOB
- See: Large Object (LOB)
- locking row explicitly 9.4.4
- locking table
- LOCK TABLE statement 9.4.2
- SELECT FOR UPDATE statement with 9.4.5
- logical design 4.1.1.2.1
- logical transaction identifier (LTXID) 9.2.4.1
- logical value 14.4.4.1.2
- log writer process (LGWR) 9.2.3
- LONG and LONG RAW data types 10.5.2.2
- LONG data type 10.2
- loose coupling 23.1.1
- LTXID (logical transaction identifier) 9.2.4.1
M
- maintaining database and application 4.1.1.4
- main transaction 9.8
- managing default rights 6.4.3
- materialized view 2.9.2
- that depends on editioned object 28.2.1.2.1
- maximum availability of table 28.4.1
- memory advisor 4.3.4
- metacharacter in regular expression 11.1
- metadata for SQL operator or function 10.7
- metrics 4.1.2
- MGD_ID ADT 26.1
- MGD_ID database ADT function 26.3.3
- mod_plsql module 18.2.1.1
- mode
- MODIFY CONSTRAINT clause of ALTER TABLE statement 13.15
- modifying
- See: altering
- monitoring database performance 4.3
- multilanguage program 22.1
- error or exception in 22.11
- multiline mode 11.2
- multilingual data 11.4.2
N
- name resolution 27.7
- editions and 28.2.1.1
- NaN (not a number) 10.3.3
- national character large object (NCLOB) data type 10.5.2.1
- native execution 14.8
- native floating-point data type 10.3
- NCHAR data type 10.2
- NCLOB data type 10.2
- negative infinity 10.3.3
- negative zero 10.3.3
- nested subprogram 14.1
- NLS_DATE_FORMAT initialization parameter 10.4.1
- NO_RESULT_CACHE hint 4.5.3.1
- nonblocking DDL statement 9.7
- in autonomous transaction 9.8
- NONEDITIONABLE property 28.2.1.5
- noneditionable schema object type 28.2.1.3
- noneditioned object 28.2.1
- creating or replacing 28.2.1.5.1
- name resolution and 28.2.1.1
- that can depend on editioned object 28.2.1.2
- dropping edition and 28.2.8
- FORCE and 28.2.1.4.1
- nongreedy operator in regular expression 11.4.3
- nonpersistent queue 24.3
- normalized significand 10.3.2.1
- NOT NULL
- See NOT NULL constraint 13.4
- NOT NULL constraint
- NOWAIT commit redo option 9.2.3
- NOWAIT option of LOCK TABLE statement 9.4.2
- NULL value
- NUMBER data type 10.3
- number data type class 27.10.2.4
- numeric data types 10.3
- NVARCHAR2 data type 10.2
O
- object
- actual 28.2.3
- dependent
- See schema object dependency 27.1
- editioned
- See editioned object 28.2.1
- inherited 28.2.3
- large
- See Large Object (LOB) 10.5.2.1
- noneditioned
- See noneditioned object 28.2.1
- potentially editioned 28.2.1
- with noneditioned dependents 28.2.1.4.1
- referenced
- See schema object dependency 27.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 4.10.18
- 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 4.10.6
- OCI_SESSGET_PURITY_SELF attribute 4.10.6
- OCI_SESSION_STATELESS attribute 4.10.18
- OCI_SUBSCR_QOS_PURGE_ON_NTFN 19.8.4
- OCIAnyData and OCIAnyDataSet interfaces 10.5.6
- ODP.NET 21.9
- online application upgrade
- See: edition-based redefinition (EBR)
- operator
- optimizer
- ORA_SDTZ system variable
- effect of setting 25.4.12
- ora$base edition 28.2, 28.2.2
- Oracle Advanced Queuing (AQ) 24.2.2
- Oracle C++ Call Interface 21.7
- Oracle Call Interface 21.7
- Oracle Database Tuning Pack 4.3.4
- Oracle Database Vault 6.3
- Oracle Data Provider for .NET 21.9
- Oracle Data Redaction 6.3
- Oracle data type
- See: SQL data type
- Oracle Extensibility Architecture, data cartridges and 2.3.1
- Oracle Extensibility Architecture framework, user-defined aggregate functions and 2.3.3
- Oracle Flashback Data Archive
- Oracle Virtual Private Database 20.11
- Oracle Flashback Query 20.3
- Oracle Flashback Technology 20.1
- Oracle Flashback Transaction Query 20.5
- Oracle Flashback Version Query 20.4
- Oracle JDBC 21.4.2
- Oracle JDeveloper, Oracle SQLJ and 21.4.3.1
- Oracle JVM 21.4.1
- Oracle Label Security 6.3
- Oracle Lock Management services 9.5
- Oracle Real Application Clusters (Oracle RAC)
- Oracle SQLJ 21.4.3
- Oracle Text 10.5.4
- Oracle Total Recall 20.9
- Oracle Tuxedo 23.1.1
- Oracle Virtual Private Database
- Oracle Flashback Data Archive 20.11
- Oracle Virtual Private Database (VPD) 6.3
- editioning view and 28.7.1
- Oracle XA
- out-of-space error 9.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 27.10.2
- parallelized SQL statement 14.10.4.2
- parameter
- partition-extended editioning view name 28.4.2
- partitioning 2.9.3
- performance 4
- performance, data type and 10.1.3
- performance goals 4.1.2
- performance testing 4.4
- persistent LOB instance 10.5.2.1
- persistent queue 24.3
- phantom read 9.6.1
- physical design 4.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 21.3
- compared to Java 21.5
- PL/SQL object
- See: PL/SQL unit
- PL/SQL optimize level 14.3.1
- PL/SQL optimizer level 8.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 21.6.1
- positive infinity 10.3.3
- positive zero 10.3.3
- POSIX standard for regular expressions
- potentially editioned object 28.2.1
- with noneditioned dependents 28.2.1.4.1
- precompiler 21.6
- PRIMARY KEY constraint 13.6
- primary key dependency 20.8.1
- privileges 6.1
- for debugging subprogram 14.11.3.2
- for defining constraint 13.13.1
- for Oracle Flashback Technology 20.2.5
- for running subprogram 14.9.1
- granting secure application roles 6.1
- grouped into roles 6.1
- INHERIT ANY PRIVILEGES system privilege 6.4.2
- INHERIT PRIVILEGES privilege 6.4.2
- revoked, object dependency and 27.4.2
- Pro*C/C++ precompiler 21.6.1
- native floating-point data types in 10.3.7
- Pro*COBOL precompiler 21.6.2
- procedure 14.1
- See also: subprogram
- product code 26.7.2
- profiler 16
- program interface 21.2
- programming environment 21
- public information, required 23.1.2
- publish-subscribe model 24
- purity of function 14.10.4
- RPC signature and 27.10.2
R
- Radio Frequency Identification (RFID) technology 26.7.1
- RAW data type 10.5.2.2
- raw data type class 27.10.2.4
- READ COMMITTED transaction isolation level
- read consistency 9.4
- read lock 9.6.3
- read-only editioning view 28.4.1
- read-only transaction 9.3
- READ UNCOMMITTED transaction isolation level
- read-write editioning view 28.4.1
- record 14.4.4.2
- redefinition, edition-based (EBR) 28.1
- redo information for transaction 9.2.3
- redo management 9.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
- registration
- regular expression 11
- remote dependency management 27.9
- remote procedure call dependency management 27.10
- remote subprogram 14.9.4
- repeatable read 9.3
- REPEATABLE READ transaction isolation level
- required public information 23.1.2
- resource manager (RM) 23.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 4.5.3.3
- RESULT_CACHE hint 4.5.3.1
- result cache 14.4.7
- resumable storage allocation 9.9
- RETENTION GUARANTEE clause for undo tablespace 20.2.1
- RETENTION option of ALTER TABLE statement 20.2.4
- RETURN_RESULT procedure 14.4.5.3
- reverse crossedition trigger 28.5.2
- reverse crossedition trigger SQL 28.5.3.2.2
- RFID (Radio Frequency Identification) technology 26.7.1
- RM (resource manager) 23.1.1
- roles 6.1
- root edition 28.2.2
- rounding floating-point numbers 10.3.2
- row
- ROW EXCLUSIVE MODE option of LOCK TABLE statement 9.4.2.1
- rowid 10.6
- ROWID data type
- ROWID pseudocolumn and 10.6
- ROWID pseudocolumn 10.6
- See also: rowid
- CQN and 19.7.2.3
- ROW SHARE MODE option of LOCK TABLE statement 9.4.2.1
- RPC dependency management 27.10
- RPC signature and 27.10.2
- RR datetime format element 10.4.1
- rule on queue 24.3
- rules engine 24.3
- runtime connection load balancing 3.4
- runtime error
- See: exception
S
- scalability 4
- scalar PL/SQL data type 14.4.4.1
- schema object dependency 27
- schema object type
- searchable text 10.5.4
- secure application roles 6.1
- security
- auditing 6.6
- external procedures for applications 6.5
- invoker’s rights and definer’s rights 6.4.1
- Java stored procedures default rights 6.4.3
- logon triggers and 6.2
- Oracle Database Vault 6.3
- Oracle Data Redaction 6.3
- Oracle Label Security 6.3
- Oracle Virtual Private Database 6.3
- privileges of invoking user 6.4.2
- privilege use 6.1
- role use 6.1
- secure application roles 6.1
- SELECT FOR UPDATE statement 9.4.4
- SELECT statement
- semi-available table 28.4.1
- serendipitous change 28.5.5
- data transformation collisions and 28.5.4.1.1
- identifying 28.5.4.1.1
- serializable transaction
- SERIALIZABLE transaction isolation level 9.6.1
- See also: serializable transaction
- server-side programming 21.1.2
- service routine, C external subprogram and 22.12
- session cursor 14.4.5
- session edition 28.2.6
- session purity 4.10.6
- session state 27.4.1
- session variable 14.9.2
- set based processing 5.3.2
- SET CONSTRAINTS statement 13.8.4
- Setting ORA_SDTZ system variable
- effect of 25.4.12
- SET TRANSACTION statement with READ ONLY option 9.3
- shared SQL area 9.1.2
- SHARE MODE option of LOCK TABLE statement 9.4.2.2
- SHARE ROW EXCLUSIVE MODE option of LOCK TABLE statement 9.4.2.3
- side effects of subprogram 14.10.4
- signature checking 27.9.1
- single-precision IEEE 754 format 10.3.2
- spatial data 10.5.1
- specification, package
- See: package specification
- SQL, dynamic
- See: dynamic SQL
- SQL/DS data type 10.5.7
- SQL Access Advisor 4.3.4
- SQL advisor 4.3.4
- SQL analytic function 2.9.1
- SQL area, shared 9.1.2
- SQL data type 10
- SQL function
- SQLJ
- See: Oracle SQLJ
- SQL optimizer hint and editioning view 28.4.7
- SQL statement
- application 28.5.3.2.3
- crossedition trigger
- forward 28.5.3.2.1
- reverse 28.5.3.2.2
- invoking PL/SQL function from 14.10
- parallelized 14.10.4.2
- processing
- SQL Trace facility (SQL_TRACE) 4.2.2
- SQL Tuning Advisor 4.3.4
- standalone subprogram 14.1
- state
- stateful session 4.10.19
- stateless session 4.10.19
- statement
- See: SQL statement
- statement caching 4.6
- statement-level read consistency 9.3, 9.4
- static pools
- used to prevent connection storms 3.1.2
- static registration 23.1.1
- static SQL, RESTRICT_REFERENCES pragma and 14.10.4.3.3
- static variable, in C external subprogram 22.13.7
- statistics
- storage allocation error 9.9
- storage requirements, decreasing 10.1.2
- stored standalone subprogram, dropping 14.7
- stored subprogram 14.1
- subnormal floating-point number 10.3.2.1
- subprogram 14.1
- subscriber 24.3
- subscription services 24.3
- subtype 14.4.4.1
- user-defined 14.4.4.1.5
- synonym
- SYSDATE function 10.4.1
- system management statement 9.1.1
T
- table
- table annotation 4.5.3.2
- table result cache mode
- Tag Data Translation Markup Language Schema 26.1
- Temporal Validity Support 2.9.4
- temporary LOB instance 10.5.2.1
- thin client configuration 21.1.3
- thread-safe application 23.3.9
- three-tier architecture 21.1.3
- tight coupling 23.1.1
- time 10.4
- See also: datetime data types
- time-stamp checking 27.9.1
- time-stamp dependency mode 27.10.1
- TIMESTAMP WITH LOCAL TIME ZONE
- examples 25.4.11
- TIMESTAMP WITH TIME ZONE
- examples 25.4.11
- TM (transaction manager) 23.1.1
- TPM (transaction processing monitor) 23.1.1
- tracing tools 14
- transaction
- autonomous 9.8
- trigger as 9.9.2.1
- choosing isolation level for 9.6.4.2
- dependent 20.8.1
- determining outcome after outage 9.2.4
- distributed 23.1.1
- remote subprogram and 14.9.4.2
- ensuring idempotence of 9.2.4
- global 23.1.1
- grouping operations into 9.2.1
- improving performance of 9.2.2
- in-flight 9.2.4
- main 9.8
- read-only 9.3
- redo entry for 9.2.3
- serializable
- See serializable transaction 9.6
- that invokes remote subprogram 14.9.4.2
- autonomous 9.8
- Transaction Guard 9.2.4, 29
- transaction history table 29.4.2
- transaction interaction
- transaction isolation level
- transaction-level read consistency 9.3
- transaction manager (TM) 23.1.1
- transaction processing monitor (TPM) 23.1.1
- transaction set consistency 9.6.4.1
- transform 28.5.1
- applying 28.5.5
- 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 23.1.1
- two-tier architecture 21.1.3
- TX interface 23.1.1
U
- undetected deadlock 9.5
- UNDO_RETENTION parameter 9.3
- undo data 20.1
- Unicode
- unified auditing 6.6
- UNIQUE constraint
- crossedition trigger and 28.5.4.1.1
- dropping 13.17
- naming 13.13.2
- on FOREIGN KEY constraint 13.8.2
- when to use 13.7
- unrepeatable read 9.6.1
- unusable edition
- dropping edition and 28.2.8
- for materialized view 28.2.1.2.1
- retiring edition and 28.2.7
- upgrading applications online
- See: edition-based redefinition (EBR)
- UROWID data type 10.6
- user access
- See: security
- user-defined subtype 14.4.4.1.5
- user interface 21.2.1
- stateful and stateless 21.2.2
- user lock 9.5
- UTLLOCKT.SQL script 9.5.2
V
- VARCHAR2 data type 10.2
- VARCHAR data type 10.2
- VARCHAR data type class 27.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 28.2.1.6
- editioning
- See editioning view 28.4
- materialized 2.9.2
- that depends on editioned object 28.2.1.2.1
- virtual column 28.2.1.2.2
- VPD policy, editioning view and 28.7.1