Index

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 1
  • 64-bit IEEE 754 format 1

A

  • Abstract Data Type (ADT)
    • native floating-point data types in 1
    • resetting evolved 1
  • ACCESSIBLE BY clause
    • in package specification 1
    • stored subprogram and 1
  • actualization 1
  • actual object 1
  • ADDM (Automatic Database Diagnostic Monitor) 1
  • address of row (rowid) 1
  • administrators, restricting with Oracle Database Vault 1
  • ADT
    • See: Abstract Data Type (ADT)
  • AFTER SUSPEND trigger 1
  • agent 1
  • aggregate function 1
  • ALL_ARGUMENTS 1
  • ALL_DEPENDENCIES 1
  • ALL_ERRORS 1
  • ALL_IDENTIFIERS 1
  • ALL_STATEMENTS 1
  • altering application online
    • See: edition-based redefinition (EBR)
  • analytic function 1
  • ancestor edition 1
  • ANSI data type 1
  • ANYDATA data type 1
  • ANYDATASET data type 1
  • AP (application program) 1
  • application architecture 1
  • application domain index 1
  • application program (AP) 1
  • application SQL 1
  • APPLYING_CROSSEDITION_TRIGGER function 1
  • AQ (Oracle Advanced Queuing) 1
  • archive
    • See Flashback Data Archive 1
  • ARGn data type 1
  • arithmetic operation
    • with datetime data type 1
    • with native floating-point data type 1
  • assignment, reported by PL/Scope 1
  • auditing
    • available options 1
    • unified auditing 1
  • auditing policy, editioning view and 1
  • AUTHID clause
    • in package specification 1
    • stored subprogram and 1
  • AUTHID property
    • of invoked subprogram 1
    • of PL/SQL unit 1 , 2
  • Automatic Database Diagnostic Monitor (ADDM) 1
  • Automatic Undo Management system 1
  • Automatic Workload Repository (AWR) 1
  • autonomous transaction
    • nonblocking DDL statement in 1
    • trigger as 1
  • auto-tuning OCI client statement cache 1

B

  • backward compatibility
    • LONG and LONG RAW data types for 1
    • RESTRICT_REFERENCES pragma for 1
  • BATCH commit redo option 1
  • benchmark 1
  • BINARY_DOUBLE data type 1
  • BINARY_FLOAT data type 1
  • BINARY_INTEGER data type
    • See: PLS_INTEGER data type
  • binary floating-point number 1
  • binary format 1
  • binary large object (BLOB) data type 1
  • bind variables 1
  • block, PL/SQL 1
  • blocking DDL statement 1
  • BOOLEAN data type 1
  • branch 1
  • built-in data type
    • See: SQL data type
  • built-in function
    • See: SQL function
  • bulk binding 1
  • business rule 1

C

  • calling subprogram
    • See: invoking subprogram
  • call specification
    • for external subprogram 1
    • in package 1
    • location of 1
  • CALL statement 1
  • cascading invalidation 1
  • C external subprogram
    • callback with 1
    • global variable in 1
    • interface between PL/SQL and 1
    • invoking 1
    • loading 1
    • passing parameter to 1
    • publishing 1
    • running 1
    • service routine and 1
  • CHANGE_DUPKEY_ERROR_INDEX hint 1
  • character data type class 1
  • character data types 1
  • character large object (CLOB) data type 1
  • CHAR data type 1
  • CHECK constraint
    • compared to NOT NULL constraint 1
    • designing 1
    • multiple 1
    • naming 1
    • restrictions on 1
    • when to use 1
  • CLIENT_RESULT_CACHE_LAG server initialization parameter 1
  • CLIENT_RESULT_CACHE_SIZE server initialization parameter 1
  • client/server architecture 1
  • client configuration parameter 1
  • client notification 1
  • client result cache 1
  • client statement cache auto-tuning (OCI client session feature) 1
  • CLOB data type 1
  • coarse-grained invalidation 1
  • collection
    • referenced by DML statement 1
    • referenced by FOR loop 1
    • referenced by SELECT statement 1
  • column
    • generated 1
    • multiple foreign key constraints on 1
    • virtual 1
    • when to use default value for 1
  • commit redo management 1
  • COMPATIBLE server initialization parameter 1
  • compilation parameter 1
  • composite PL/SQL data type 1
  • concurrency
    • serializable transaction for 1
    • under explicit locking 1
  • conditional compilation 1
  • connection class 1
  • connection pool 1
  • connection pools
    • connection storms 1
    • design guidelines for logins 1
    • design guildelines 1
    • drained 1
    • guideline for preventing connection storms 1
    • guidelines for preventing programmatic session leaks 1
    • lock leaks 1
    • logical corruption 1
  • constraint
    • altering 1
    • CHECK
      • See CHECK constraint 1
    • compared to trigger 1
    • crossedition trigger and
      • collisions 1
      • dropping 1
    • deferring checking of 1
    • disabling
      • effect of 1
      • existing 1
      • new 1
      • reasons for 1
    • dropping 1
    • editioning view and 1
    • enabling
      • effect of 1
      • existing 1
      • new 1
    • exception to 1
    • FOREIGN KEY
      • See FOREIGN KEY constraint 1
    • minimizing overhead of 1
    • naming 1
    • on view 1
    • PRIMARY KEY
      • See PRIMARY KEY constraint 1
    • privileges needed for defining 1
    • referential integrity
      • See FOREIGN KEY constraint 1
    • renaming 1
    • UNIQUE
      • See UNIQUE constraint 1
    • viewing definition of 1
    • violation of 1
  • Continuous Query Notification (CQN)
    • example 1
  • converting data types
    • See: data type conversion
  • copy-on-change strategy 1
  • coupling 1
  • CQ_NOTIFICATION$_DESCRIPTOR object 1
  • CQ_NOTIFICATION$_QUERY object 1
  • CQ_NOTIFICATION$_REG_INFO object 1
  • CQ_NOTIFICATION$_ROW object 1
  • CQ_NOTIFICATION$_TABLE object 1
  • CQN (Continuous Query Notification) 1
  • CREATE_COVERAGE_TABLES procedure 1
  • CREATE OR REPLACE optimization
    • actualization and 1
  • crossedition trigger
    • creating 1
    • displaying information about 1
    • dropping 1
    • execution of 1
    • forward 1
    • interaction with editions 1
    • read-only editioning view and 1
    • read-write editioning view and 1
    • reverse 1
    • scope of 1
    • sharing child cursor and 1
  • crossedition trigger SQL
    • forward 1
    • reverse 1
  • cross-session PL/SQL function result cache 1
  • current date and time, displaying 1
  • current edition 1
  • cursor
    • crossedition trigger and 1
    • explicit 1
    • implicit 1
    • Oracle XA application and 1
    • schema object dependency and 1
    • session 1
  • cursor variable
    • advantages of 1
    • disadvantages of 1

D

  • database hardening 1
  • database logins, automated 1
  • Database Resident Connection Pool (DRCP) 1
  • data cartridge 1
  • data definition language statement
    • See: DDL statement
  • data integrity
    • data type and 1
  • data modeling 1
  • data type
    • ANSI 1
    • BOOLEAN 1
    • DB2 1
    • dynamic 1
    • external 1
    • for character data 1
    • for datetime data 1
    • for geographic data 1
    • for large amount of data 1
    • for multimedia data 1
    • for numeric data 1
    • for spatial data 1
    • for XML data 1
    • importance of correct 1
    • PL/SQL 1
    • PLS_INTEGER 1
    • REF CURSOR 1
    • SQL 1
    • SQL/DS 1
  • data type class 1
  • data type conversion
    • of ANSI and IBM data types 1
    • of datetime data types 1
    • of native floating-point data types 1
  • data type family
    • PL/SQL 1
    • SQL 1
  • date
    • default format for 1
    • displaying
      • current 1
    • inserting 1
  • datetime data type class 1
  • datetime data types
    • arithmetic operations with 1
    • conversion functions for 1
    • importing, exporting, and comparing 1
  • day, default value for 1
  • DB2 data type 1
  • DBA_STATEMENTS 1
  • DBA_STATEMENTS.SIGNATURE 1
  • DBA_STATEMENTS.TYPE Column 1
  • DBA_STATEMENTS.USAGE_CONTEXT_ID 1
  • DBA_STATEMENTS.USAGE_ID 1
  • DBMS_APPLICATION_INFO package 1
  • DBMS_DEBUG_JDWP 1
  • DBMS_DEBUG_JDWP package 1
  • DBMS_FLASHBACK_ARCHIVE procedures 1
  • DBMS_FLASHBACK.TRANSACTION_BACKOUT procedure 1
  • DBMS_FLASHBACK package 1
  • DBMS_HPROF.ANALYZE 1
  • DBMS_HPROF package 1
  • DBMS_LOCK package 1
  • DBMS_OUTPUT package 1
  • DBMS_PARALLEL_EXECUTE package 1
  • DBMS_PLSQL_CODE_COVERAGE 1 , 2
  • DBMS_SQL.RETURN_RESULT procedure 1
  • DBMS_STATS package 1
  • DBMS_TYPES package 1
  • DBMS_XA package 1
  • DDL_LOCK_TIMEOUTparameter 1
  • DDL statement
    • blocking 1
    • Flashback Data Archive and 1
    • for creating package 1
    • for creating subprogram 1
    • ineffective 1
    • nonblocking
      • in autonomous transaction 1
    • Oracle XA and 1
    • processing 1
    • that generates notification 1
  • deadlock, undetected 1
  • debugging
    • compiling PL/SQL unit for 1
    • external subprogram 1
    • subprogram 1
    • wrap utility and 1
  • decimal floating-point number 1
  • default column value 1
  • deferring constraint checks 1
  • definer’s rights 1
  • denormal floating-point number 1
  • dependency mode 1
  • dependent object
    • See: schema object dependency
  • dependent transaction 1
  • DEPRECATE PRAGMA 1
  • descendent edition 1
  • design
    • physical 1 , 2
  • DETERMINISTIC function
    • function-based index and 1
    • RPC signature and 1
  • dirty read 1
  • disabling constraint
    • effect of 1
    • existing 1
    • new 1
    • reasons for 1
  • distributed database
    • FOREIGN KEY constraint and 1
    • remote dependency management and 1
  • distributed transaction
    • remote subprogram and 1
  • DLL (dynamic link library) 1
  • DML_LOCKS initialization parameter 1
  • DML statement
    • bulk binding for 1
    • that references collection 1
  • domain index 1
  • double-precision IEEE 754 format 1
  • drivers, Oracle JDBC 1
  • DTP (X/Open Distributed Transaction architecture) 1
  • dynamically typed data 1
  • dynamic link library (DLL) 1
  • dynamic registration 1
  • dynamic SQL
    • implicit query results and 1
    • RESTRICT_REFERENCES pragma and 1

E

  • EBR (edition-based redefinition) 1
  • edition
    • ancestor 1
    • creating 1
    • crossedition triggers and 1
    • current 1
    • descendent 1
    • displaying information about 1
    • dropping 1
    • enabling for user and types 1
    • evaluation
      • See evaluation edition 1
    • leaf 1
    • making available
      • to all users 1
      • to some users 1
    • ora$base 1 , 2
    • retiring 1
    • root 1
    • scope of 1
    • session 1
    • unusable
      • See unusable edition 1
    • visibility of trigger in 1
  • EDITIONABLE property 1
  • editionable schema object type 1
  • edition-based redefinition (EBR) 1
  • editioned object
    • creating or replacing 1
    • name resolution and 1
  • editioning view
    • auditing policy and 1
    • changing base table of 1
    • changing writability of 1
    • covering table with 1
    • creating 1
    • displaying information about 1
    • partition-extended name for 1
    • preparing application for 1
    • read-only 1
    • read-write 1
    • replacing 1
    • scope of 1
    • SQL optimizer hint and 1
  • Electronic Product Code (EPC) 1
  • embedded PL/SQL gateway
    • how to use 1
  • enabling constraint
    • effect of 1
    • existing 1
    • new 1
  • enabling editions 1
  • encoding scheme, adding 1
  • environment, programming 1
  • EPC (Electronic Product Code) 1
  • evaluation edition
    • dropping edition and 1
    • for materialized view 1
    • for virtual column 1
    • retiring edition and 1
  • exception
    • IEEE 754 standard
      • not raised 1
      • raised during conversion 1
    • in multilanguage program 1
    • to constraint 1
  • exception handling
    • for storage allocation error 1
  • EXCLUSIVE MODE option of LOCK TABLE statement 1
  • EXECUTE privilege 1
  • execution plan
    • data type and 1
  • EXPLAIN PLAN statement 1
  • explicit cursor 1
  • EXPR data type 1
  • expression
    • index built on
      • See function-based index 1
    • regular
      • See regular expression 1
  • extensibility 1
  • external data type 1
  • external large object (BFILE) data type 1
  • external subprogram
    • call specification for 1
    • debugging 1
    • loading 1
    • managing for applications 1
    • publishing 1
  • external transaction manager 1

F

  • family of data types
    • PL/SQL 1
    • SQL 1
  • FAN event, load balancing advisory 1
  • Fast Application Notification (FAN) 1
  • fine-grained access control 1
  • fine-grained auditing (FGA) policy, editioning view and 1
  • fine-grained invalidation 1
  • firing order of triggers 1
  • FIXED_DATE initialization parameter 1
  • fixed-point data type 1
  • Flashback Data Archive 1
  • Flashback Transaction 1
  • FLOAT data type 1
  • floating-point data type
    • range and precision of 1
  • floating-point number
    • binary 1
    • components of 1
    • decimal 1
    • denormal 1
    • format of 1
    • rounding 1
    • subnormal 1
  • FORCE option of ALTER USER statement 1
  • FOREIGN KEY constraint
    • distributed databases and 1
    • dropping 1
    • editioned view and 1
    • enabling 1
    • Flashback Transaction and 1
    • indexing 1
    • multiple 1
    • naming 1
    • NOT NULL constraint on 1
    • NULL value and 1
    • privileges needed to create 1
    • referential integrity enforced by 1
    • UNIQUE constraint on 1
    • without other constraints 1
  • foreign key dependency 1
  • FOR loop
    • bulk binding for 1
    • that references collection 1
  • forward compatibility 1
  • forward crossedition trigger 1
  • forward crossedition trigger SQL 1
  • function
    • aggregate 1
    • analytic 1
    • built-in
      • See SQL function 1
    • DETERMINISTIC
      • function-based index and 1
      • RPC signature and 1
    • invoking from SQL statement 1
    • MGD_ID ADT 1
    • OCI or OCCI 1
    • PARALLEL_ENABLE, RPC signature and 1
    • PL/SQL, invoked by SQL statement 1
    • purity of
      • RPC signature and 1
    • result-cached 1
    • returning large amount of data from 1
    • SQL
      • See SQL function 1
    • SQL analytic 1
  • function-based index
    • example for faster case-insensitive searches 1
    • example for object columns 1
    • example for precomputing arithmetic expressions 1
    • optimizer and 1 , 2
  • function result cache 1

G

  • generated column 1
  • Geographic Information System (GIS) data 1
  • GET_LTXID_OUTCOME procedure 1
  • global transaction 1
  • global variable, in C external subprogram 1
  • greedy operator in regular expression 1
  • group commit 1

H

  • hierarchical profiler 1
  • historical data, importing and exporting 1
  • host language 1
  • host program 1
  • hot rollover 1

I

  • IA-32 and IA-64 instruction set architecture 1
  • IBM CICS 1
  • IBM Transarc Encina 1
  • Identity Code Package 1
  • IEEE 754 standard
    • exception
      • not raised 1
      • raised during conversion 1
    • special values supported by 1
  • IGNORE_ROW_ON_DUPKEY_INDEX hint 1
  • IMMEDIATE commit redo option 1
  • implementing database application 1
  • implicit cursor 1
  • independent transaction
    • See: autonomous transaction
  • index
    • domain 1
    • edition-based redefinition and 1
    • function-based
      • See function-based index 1
    • on MGD_ID column 1
  • infinity 1
  • in-flight transaction 1
  • INHERIT ANY PRIVILEGES system privilege 1
  • inherited object 1
  • INHERIT PRIVILEGES privilege 1
  • initialization parameter
    • DML_LOCKS 1
    • FIXED_DATE 1
    • NLS_DATE_FORMAT 1
  • instrumentation 1
  • integer data type class 1
  • integrity constraint
    • See: constraint
  • integrity of data
    • See: data integrity
  • interface
    • between PL/SQL and C 1
    • between PL/SQL and Java 1
    • program 1
    • TX 1
    • user
      • stateful or stateless 1
  • invalidation
    • cascading 1
    • coarse-grained 1
    • fine-grained 1
    • of dependent object 1
    • of package 1
  • invoker’s rights
    • affect on invoker’s privileges 1
    • Java stored procedures 1
  • invoking subprogram
    • from subprogram 1
    • from trigger 1
    • interactively from Oracle Database tools 1
    • through embedded PL/SQL gateway 1
  • isolation level
    • See: transaction isolation level
  • iterative data processing
    • about 1
    • arrays 1
    • manual parallelism 1
    • row by row 1

J

  • Java class method
    • calling 1
    • interface between PL/SQL and 1
    • publishing 1
  • Java Database Connectivity
    • See: Oracle JDBC
  • Java language
    • compared to PL/SQL 1
    • Oracle Database support for 1
  • Java stored procedures 1
  • Java Virtual Machine
    • See: Oracle JVM
  • JDBC
    • See: Oracle JDBC
  • JVM
    • See: Oracle JVM

K

  • key
    • foreign
      • See FOREIGN KEY constraint 1
    • primary
      • See PRIMARY KEY constraint 1
    • unique
      • See UNIQUE constraint 1

L

  • Large Object (LOB) 1
  • leaf edition 1
  • LGWR (log writer process) 1
  • lightweight queue 1
  • live operation 1
  • load balancing advisory FAN event 1
  • LOB
    • See: Large Object (LOB)
  • locking row explicitly 1
  • locking table
    • explicitly 1
    • implicitly 1
  • LOCK TABLE statement
    • SELECT FOR UPDATE statement with 1
  • logical design 1
  • logical transaction identifier (LTXID) 1
  • logical value 1
  • log writer process (LGWR) 1
  • LONG and LONG RAW data types 1
  • LONG data type 1
  • loose coupling 1
  • LTXID (logical transaction identifier) 1

M

  • maintaining database and application 1
  • main transaction 1
  • managing default rights 1
  • materialized view
    • that depends on editioned object 1
  • maximum availability of table 1
  • memory advisor 1
  • metacharacter in regular expression 1
  • metadata for SQL operator or function 1
  • metrics 1
  • MGD_ID ADT 1
  • MGD_ID database ADT function 1
  • mod_plsql module 1
  • mode
    • dependency 1
    • lock 1
    • serialized
      • See serializable transaction 1
  • MODIFY CONSTRAINT clause of ALTER TABLE statement 1
  • modifying
    • See: altering
  • monitoring database performance 1
  • multilanguage program
    • error or exception in 1
  • multiline mode 1
  • multilingual data 1
  • multimedia data 1

N

  • name resolution
    • editions and 1
  • NaN (not a number) 1
  • national character large object (NCLOB) data type 1
  • native execution 1
  • native floating-point data type
    • arithmetic operation with 1
    • binary format for 1
    • conversion functions for 1
    • in client interfaces 1
    • special values for 1
  • NCHAR data type 1
  • NCLOB data type 1
  • negative infinity 1
  • negative zero 1
  • nested subprogram 1
  • NLS_DATE_FORMAT initialization parameter 1
  • NO_RESULT_CACHE hint 1
  • nonblocking DDL statement
    • in autonomous transaction 1
  • NONEDITIONABLE property 1
  • noneditionable schema object type 1
  • noneditioned object
    • creating or replacing 1
    • name resolution and 1
    • that can depend on editioned object
      • dropping edition and 1
      • FORCE and 1
  • nongreedy operator in regular expression 1
  • nonpersistent queue 1
  • normalized significand 1
  • NOT NULL
    • See NOT NULL constraint 1
  • NOT NULL constraint
    • compared to CHECK constraint 1
    • naming 1
    • on FOREIGN KEY constraint 1
    • when to use 1
  • NOWAIT commit redo option 1
  • NOWAIT option of LOCK TABLE statement 1
  • NULL value
    • FOREIGN KEY constraint and 1
    • function-based index and 1
    • indexing and 1
  • NUMBER data type 1
  • number data type class 1
  • numeric data types 1
  • NVARCHAR2 data type 1

O

  • object
    • actual 1
    • dependent
      • See schema object dependency 1
    • editioned
      • See editioned object 1
    • inherited 1
    • large
      • See Large Object (LOB) 1
    • noneditioned
      • See noneditioned object 1
    • potentially editioned
      • with noneditioned dependents 1
    • referenced
      • See schema object dependency 1
    • size limit for PL/SQL stored 1
  • object change notification 1
  • OCCI
    • See: Oracle C++ Call Interface
  • OCI
    • See: Oracle Call Interface
  • OCI_ATTR_CHDES_DBNAME 1
  • OCI_ATTR_CHDES_NFTYPE 1
  • OCI_ATTR_CHDES_TABLE_CHANGES 1
  • OCI_ATTR_CHDES_TABLE_NAME 1
  • OCI_ATTR_CHDES_TABLE_OPFLAGS 1
  • OCI_ATTR_CHDES_TABLE_ROW_CHANGES 1
  • OCI_ATTR_CHDES_XID 1
  • OCI_ATTR_CHNF_CHANGELAG 1
  • OCI_ATTR_CHNF_ROWIDS 1
  • OCI_ATTR_CQ_QUERYID 1
  • OCI_ATTR_CQDES_OPERATION 1
  • OCI_ATTR_CQDES_QUERYID 1
  • OCI_ATTR_CQDES_TABLE_CHANGES 1
  • OCI_ATTR_SESSION_STATE attribute 1
  • OCI_ATTR_SUBSCR_CALLBACK 1
  • OCI_ATTR_SUBSCR_CQ_CHNF_QOSFLAGS 1
  • OCI_ATTR_SUBSCR_TIMEOUT 1
  • OCI_DTYPE_CQDES 1
  • OCI_SESSGET_PURITY_NEW attribute 1
  • OCI_SESSGET_PURITY_SELF attribute 1
  • OCI_SESSION_STATELESS attribute 1
  • OCI_SUBSCR_QOS_PURGE_ON_NTFN 1
  • OCIAnyData and OCIAnyDataSet interfaces 1
  • ODP.NET 1
  • online application upgrade
    • See: edition-based redefinition (EBR)
  • operator
    • in regular expression
      • greedy 1
      • nongreedy 1
    • metadata for 1
  • optimizer
    • editioning view and 1
    • function-based index and 1 , 2
    • RPC signature and 1
  • ORA_SDTZ system variable
    • effect of setting 1
  • ora$base edition 1 , 2
  • Oracle Advanced Queuing (AQ) 1
  • Oracle C++ Call Interface
    • building application with 1
    • kinds of functions in 1
    • native floating-point data types in 1
    • procedural and nonprocedural elements of 1
  • Oracle Call Interface
    • building application with 1
    • commit redo action in 1
    • compared to precompiler 1
    • kinds of functions in 1
    • native floating-point data types in 1
    • procedural and nonprocedural elements of 1
    • with Oracle XA 1
  • Oracle Database Tuning Pack 1
  • Oracle Database Vault 1
  • Oracle Data Provider for .NET 1
  • Oracle Data Redaction 1
  • Oracle data type
    • See: SQL data type
  • Oracle Extensibility Architecture, data cartridges and 1
  • Oracle Extensibility Architecture framework, user-defined aggregate functions and 1
  • Oracle Flashback Query 1
  • Oracle Flashback Technology
    • application development features 1
    • configuring database for 1
    • database administration features 1
    • performance guidelines for 1
  • Oracle Flashback Transaction Query 1
  • Oracle Flashback Version Query 1
  • Oracle JDBC
    • compared to Oracle SQLJ 1
    • native floating-point data types in 1
    • sample program
      • 2.0 1
      • pre-2.0 1
  • Oracle JDeveloper, Oracle SQLJ and 1
  • Oracle JVM 1
  • Oracle Label Security 1
  • Oracle Lock Management services 1
  • Oracle Multimedia 1
  • Oracle Real Application Clusters (Oracle RAC)
    • client result cache and 1
    • DRCP and 1
    • load balancing advisory FAN events and 1
    • Oracle XA and 1
    • runtime connection load balancing and 1
  • Oracle SQLJ
    • compared to Oracle JDBC 1
    • Oracle JDeveloper and 1
  • Oracle Text 1
  • Oracle Total Recall 1
  • Oracle Tuxedo 1
  • Oracle Virtual Private Database (VPD)
    • editioning view and 1
  • Oracle XA
    • Oracle RAC and 1
    • subprograms 1
    • when to use 1
  • out-of-space error 1
  • overloaded subprogram 1

P

  • package
    • creating 1
    • dropping 1
    • invalidation of 1
    • session state and 1
    • size limit for 1
    • synonym for 1
  • package body 1
  • package invalidation and 1
  • package specification 1
  • package subprogram 1
  • PARALLEL_ENABLE function
    • RPC signature and 1
  • parallelized SQL statement 1
  • parameter
    • compilation
      • See compilation parameter 1
    • initialization 1
  • partition-extended editioning view name 1
  • partitioning 1
  • performance 1
  • performance, data type and 1
  • performance goals 1
  • performance testing 1
  • persistent LOB instance 1
  • persistent queue 1
  • phantom read 1
  • physical design 1
  • PL/Scope 1 , 2
  • PL/Scope security model 1
  • PL/Scope tool 1
  • PL/SQL block 1
  • PL/SQL data type 1
  • PL/SQL function result cache 1
  • PL/SQL gateway 1
  • PL/SQL hierarchical profiler 1
  • PL/SQL Hierarchical Profiler 1
  • PL/SQL language
    • compared to Java 1
  • PL/SQL object
    • See: PL/SQL unit
  • PL/SQL optimize level 1
  • PL/SQL optimizer level 1
  • PL/SQL unit
    • compiling for debugging 1
    • CREATE OR REPLACE and 1
  • PL/SQL Web Toolkit 1
  • PLS_INTEGER data type 1
  • plshprof utility 1
  • PLSQL_CODE_COVERAGE package 1
  • pool, connection 1
  • positive infinity 1
  • positive zero 1
  • POSIX standard for regular expressions
    • operators defined in 1
    • Oracle SQL and 1
    • Oracle SQL multilingual extensions to 1
    • Oracle SQL PERL-influenced extensions to 1
  • potentially editioned object
    • with noneditioned dependents 1
  • precompiler
    • compared to Oracle Call Interface 1
    • Oracle XA and 1
  • PRIMARY KEY constraint
    • dropping 1
    • Flashback Transaction and 1
    • naming 1
  • primary key dependency 1
  • privileges
    • for debugging subprogram 1
    • for defining constraint 1
    • for Oracle Flashback Technology 1
    • for running subprogram 1
    • granting secure application roles 1
    • grouped into roles 1
    • INHERIT ANY PRIVILEGES system privilege 1
    • INHERIT PRIVILEGES privilege 1
    • revoked, object dependency and 1
  • Pro*C/C++ precompiler
    • native floating-point data types in 1
  • Pro*COBOL precompiler 1
  • procedure 1
    • See also: subprogram
  • product code 1
  • profiler 1
  • program interface 1
  • programming environment 1
  • public information, required 1
  • publish-subscribe model 1
  • purity of function
    • RPC signature and 1

Q

  • quality-of-service flag 1
  • query
    • registering for Continuous Query Notification 1
    • returning results to client
      • implicitly 1
  • Query Result Change Notification (QRCN) 1
  • query rewrite 1
  • queue 1

R

  • Radio Frequency Identification (RFID) technology 1
  • RAW data type 1
  • raw data type class 1
  • READ COMMITTED transaction isolation level
    • compared to SERIALIZABLE 1
    • in Oracle Database 1
    • transaction interactions with 1
  • read consistency
    • statement-level 1
    • transaction-level
      • locking tables explicitly for 1
      • read-only transaction for 1
  • read lock 1
  • read-only editioning view 1
  • read-only transaction 1
  • READ UNCOMMITTED transaction isolation level
    • in Oracle Database 1
    • transaction interactions with 1
  • read-write editioning view 1
  • record 1
  • redefinition, edition-based (EBR) 1
  • redo information for transaction 1
  • redo management 1
  • REF CURSOR data type 1
  • referenced object
    • See: schema object dependency
  • referential integrity
    • serializable transactions and 1
    • trigger for enforcing 1
  • referential integrity constraint
    • See: FOREIGN KEY constraint
  • REGEXP_COUNT function 1
  • REGEXP_INSTR function 1
  • REGEXP_LIKE condition 1
  • REGEXP_REPLACE function
    • back reference operator in 1
  • REGEXP_SUBSTR function 1
  • registration
    • dynamic 1
    • for Continuous Query Notification 1
    • in publish-subscribe model 1
    • static 1
  • regular expression
    • in Oracle SQL 1
    • in SQL statement 1
    • metacharacter in 1
    • POSIX standard and
      • See POSIX standard for regular expressions 1
    • Unicode and 1
  • remote dependency management 1
  • remote procedure call dependency management 1
  • remote subprogram 1
  • repeatable read
    • locking tables explicitly for 1
    • read-only transaction for 1
  • REPEATABLE READ transaction isolation level
    • in Oracle Database 1
    • transaction interactions with 1
  • required public information 1
  • resource manager (RM) 1
  • RESTRICT_REFERENCES pragma
    • for backward compatibility 1
    • static and dynamic SQL and 1
  • RESULT_CACHE_MODE session parameter 1
  • RESULT_CACHE hint 1
  • result cache 1
  • resumable storage allocation 1
  • RETENTION GUARANTEE clause for undo tablespace 1
  • RETENTION option of ALTER TABLE statement 1
  • RETURN_RESULT procedure 1
  • reverse crossedition trigger 1
  • reverse crossedition trigger SQL 1
  • RFID (Radio Frequency Identification) technology 1
  • RM (resource manager) 1
  • roles 1
  • root edition 1
  • rounding floating-point numbers 1
  • row
    • address of (rowid) 1
    • locking explicitly 1
  • ROW EXCLUSIVE MODE option of LOCK TABLE statement 1
  • rowid 1
  • ROWID data type
    • ROWID pseudocolumn and 1
  • ROWID pseudocolumn
    • CQN and 1
  • ROW SHARE MODE option of LOCK TABLE statement 1
  • RPC dependency management
    • RPC signature and 1
  • RR datetime format element 1
  • rule on queue 1
  • rules engine 1
  • runtime connection load balancing 1
  • runtime error
    • See: exception

S

  • scalability 1
  • scalar PL/SQL data type 1
  • schema object dependency
    • in distributed database 1
    • invalidation and 1
    • on nonexistence of other objects 1
    • revoked privileges and 1
    • shared pool and 1
  • schema object type
    • editionable 1
    • enabling for editions 1
    • noneditionable 1
  • searchable text 1
  • secure application roles 1
  • security
    • auditing 1
    • external procedures for applications 1
    • invoker’s rights and definer’s rights 1
    • Java stored procedures default rights 1
    • logon triggers and 1
    • Oracle Database Vault 1
    • Oracle Data Redaction 1
    • Oracle Label Security 1
    • Oracle Virtual Private Database 1
    • privileges of invoking user 1
    • privilege use 1
    • role use 1
    • secure application roles 1
  • SELECT FOR UPDATE statement
    • LOCK TABLE statement with 1
    • referential integrity and
      • inside trigger 1
      • outside trigger 1
  • SELECT statement
    • bulk binding for 1
    • referencing collection with 1
    • with AS OF clause 1
    • with FOR UPDATE clause
      • See SELECT FOR UPDATE statement 1
    • with VERSIONS BETWEEN clause 1
  • semi-available table 1
  • serendipitous change
    • data transformation collisions and 1
    • identifying 1
  • serializable transaction
    • for concurrency control 1
    • interaction with 1
    • referential integrity and 1
  • SERIALIZABLE transaction isolation level
    • compared to READ COMMITTED 1
    • in Oracle Database 1
    • transaction interactions with 1
  • server-side programming 1
  • service routine, C external subprogram and 1
  • session cursor 1
  • session edition 1
  • session purity 1
  • session state 1
  • session variable 1
  • set based processing 1
  • SET CONSTRAINTS statement 1
  • Setting ORA_SDTZ system variable
    • effect of 1
  • SET TRANSACTION statement with READ ONLY option 1
  • shared SQL area 1
  • SHARE MODE option of LOCK TABLE statement 1
  • SHARE ROW EXCLUSIVE MODE option of LOCK TABLE statement 1
  • side effects of subprogram 1
  • signature checking 1
  • single-precision IEEE 754 format 1
  • spatial data 1
  • specification, package
    • See: package specification
  • SQL, dynamic
    • See: dynamic SQL
  • SQL/DS data type 1
  • SQL Access Advisor 1
  • SQL advisor 1
  • SQL analytic function 1
  • SQL area, shared 1
  • SQL data type 1
  • SQL function
    • analytic 1
    • display type of 1
    • for data type conversion 1
    • metadata for 1
  • SQLJ
    • See: Oracle SQLJ
  • SQL optimizer hint and editioning view 1
  • SQL statement
    • application 1
    • crossedition trigger
      • forward 1
      • reverse 1
    • invoking PL/SQL function from 1
    • parallelized 1
    • processing
      • DDL statement 1
      • stages of 1
      • system management statement 1
  • SQL Trace facility (SQL_TRACE) 1
  • SQL Tuning Advisor 1
  • standalone subprogram 1
  • state
    • session 1
    • user interface and 1
    • web application and 1
  • stateful session 1
  • stateless session 1
  • statement
    • See: SQL statement
  • statement caching 1
  • statement-level read consistency 1 , 2
  • static pools
    • used to prevent connection storms 1
  • static registration 1
  • static SQL, RESTRICT_REFERENCES pragma and 1
  • static variable, in C external subprogram 1
  • statistics
    • for application 1
    • for identifier 1
  • storage allocation error 1
  • storage requirements, decreasing 1
  • stored standalone subprogram, dropping 1
  • stored subprogram 1
  • subnormal floating-point number 1
  • subprogram
    • creating 1
    • external
      • See external subprogram 1
    • invoking
      • See invoking subprogram 1
    • Oracle XA 1
    • overloaded 1
    • privileges needed to debug 1
    • privileges needed to run 1
    • remote 1
    • size limit for 1
    • synonym for 1
  • subscriber 1
  • subscription services 1
  • subtype
    • user-defined 1
  • synonym
    • CREATE OR REPLACE and 1
    • for package 1
    • for subprogram 1
  • SYSDATE function 1
  • system management statement 1

T

  • table
    • controlling user access to 1
    • locking
      • choosing strategy for 1
      • explicitly 1
      • implicitly 1
    • with maximum availability 1
    • with semi-availability 1
  • table annotation 1
  • table result cache mode
    • annotation 1
    • effective
      • determining 1
      • displaying 1
  • Tag Data Translation Markup Language Schema 1
  • Temporal Validity Support 1
  • temporary LOB instance 1
  • thin client configuration 1
  • thread-safe application 1
  • three-tier architecture 1
  • tight coupling 1
  • time
    • default value for 1
    • displaying
      • current 1
    • inserting 1
  • time-stamp checking 1
  • time-stamp dependency mode 1
  • TIMESTAMP WITH LOCAL TIME ZONE
    • examples 1
  • TIMESTAMP WITH TIME ZONE
    • examples 1
  • TM (transaction manager) 1
  • TPM (transaction processing monitor) 1
  • tracing tools 1
  • transaction
    • autonomous
      • trigger as 1
    • choosing isolation level for 1
    • dependent 1
    • determining outcome after outage 1
    • distributed
      • remote subprogram and 1
    • ensuring idempotence of 1
    • global 1
    • grouping operations into 1
    • improving performance of 1
    • in-flight 1
    • main 1
    • read-only 1
    • redo entry for 1
    • serializable
      • See serializable transaction 1
    • that invokes remote subprogram 1
  • Transaction Guard 1 , 2
  • transaction history table 1
  • transaction interaction
    • kinds of 1
    • serializable transaction and 1
    • transaction isolation level and 1
  • transaction isolation level
    • choosing 1
    • setting 1
    • transaction interaction and 1
  • transaction-level read consistency
    • locking tables explicitly for 1
    • read-only transaction for 1
  • transaction manager (TM) 1
  • transaction processing monitor (TPM) 1
  • transaction set consistency 1
  • transform
    • applying 1
  • trigger
    • AFTER SUSPEND 1
    • as autonomous transaction 1
    • automating database login with 1
    • compared to constraint 1
    • crossedition
      • See crossedition trigger 1
    • enforcing referential integrity with 1
    • in edition
      • firing order of 1
      • visibility of 1
      • what kind can fire 1
    • invoking subprogram from 1
    • size limit for 1
  • TRUST assertion (deprecated) 1
  • TRUST keyword in RESTRICT_REFERENCES pragma 1
  • two-phase commit protocol 1
  • two-tier architecture 1
  • TX interface 1

U

  • undetected deadlock 1
  • UNDO_RETENTION parameter 1
  • undo data 1
  • Unicode
    • data types for 1
    • regular expressions and 1
  • unified auditing 1
  • UNIQUE constraint
    • crossedition trigger and 1
    • dropping 1
    • naming 1
    • on FOREIGN KEY constraint 1
    • when to use 1
  • unrepeatable read 1
  • unusable edition
    • dropping edition and 1
    • for materialized view 1
    • retiring edition and 1
  • upgrading applications online
    • See: edition-based redefinition (EBR)
  • UROWID data type 1
  • user access
    • See: security
  • user-defined subtype 1
  • user interface
    • stateful and stateless 1
  • user lock 1
  • UTLLOCKT.SQL script 1

V

  • VARCHAR2 data type 1
  • VARCHAR data type 1
  • VARCHAR data type class 1
  • variable
    • cursor
      • See cursor variable 1 , 2
    • in C external subprogram
      • global 1
      • static 1
  • view
    • constraint on 1
    • editioned, FOREIGN KEY constraint and 1
    • editioning
      • See editioning view 1
    • materialized
      • that depends on editioned object 1
  • virtual column 1
  • VPD policy, editioning view and 1

W

  • WAIT commit redo option 1
  • WAIT option of LOCK TABLE statement 1
  • web application
    • implementing 1
    • state and 1
  • web services 1
  • web toolkit
    • See: PL/SQL Web Toolkit
  • white list
    • See: ACCESSIBLE BY clause
  • wrap utility, debugging and 1
  • writability of editioning view 1
  • write-after-write dependency 1

X

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

Y

  • YY datetime format element 1