List of Tables
- 3-1 Table Annotation Result Cache Modes
- 3-2 Effective Result Cache Table Mode
- 3-3 Client Configuration Parameters (Optional)
- 3-4 Setting Client Result Cache and Server Result Cache
- 3-5 Session Purity and Connection Class Defaults
- 8-1 COMMIT Statement Options
- 8-2 Examples of Concurrency Under Explicit Locking
- 8-3 Ways to Display Locking Information
- 8-4 ANSI/ISO SQL Isolation Levels and Possible Transaction Interactions
- 8-5 ANSI/ISO SQL Isolation Levels Provided by Oracle Database
- 8-6 Comparison of READ COMMITTED and SERIALIZABLE Transactions
- 8-7 Possible Transaction Outcomes
- 8-8 Object Types Supported for
CREATE
,ALTER
, andDROP
Commands - 9-1 SQL Character Data Types
- 9-2 Range and Precision of Floating-Point Data Types
- 9-3 Binary Floating-Point Format Components
- 9-4 Summary of Binary Format Storage Parameters
- 9-5 Special Values for Native Floating-Point Formats
- 9-6 Values Resulting from Exceptions
- 9-7 SQL Datetime Data Types
- 9-8 SQL Conversion Functions for Datetime Data Types
- 9-9 Large Objects (LOBs)
- 9-10 Display Types of SQL Functions
- 9-11 SQL Data Type Families
- 10-1 Identifier Built-in Domains
- 10-2 Tech Built-in Domains
- 10-3 Numeric Built-in Domains
- 10-4 Miscellaneous Built-in Domains
- 11-1 Oracle SQL Pattern-Matching Condition and Functions
- 11-2 Oracle SQL Pattern-Matching Options for Condition and Functions
- 11-3 POSIX Operators in Oracle SQL Regular Expressions
- 11-4 POSIX Operators and Multilingual Operator Relationships
- 11-5 PERL-Influenced Operators in Oracle SQL Regular Expressions
- 11-6 Explanation of the Regular Expression Elements
- 11-7 Explanation of the Regular Expression Elements
- 15-1 Identifier Types that PL/Scope Collects
- 15-2 Usages that PL/Scope Reports
- 16-1 Raw Profiler Output File Indicators
- 16-2 Function Names of Operations that the PL/SQL Hierarchical Profiler Tracks
- 16-3 PL/SQL Hierarchical Profiler Database Tables
- 16-4 DBMSHP_RUNS Table Columns
- 16-5 DBMSHP_FUNCTION_INFO Table Columns
- 16-6 DBMSHP_PARENT_CHILD_INFO Table Columns
- 17-1 DBMSPCC_RUNS Table Columns
- 17-2 DBMSPCC_UNITS Table Columns
- 17-3 DBMSPCC_BLOCKS Table Columns
- 18-1 Commonly Used Packages in the PL/SQL Web Toolkit
- 18-2 Mapping Between mod_plsql and Embedded PL/SQL Gateway DAD Attributes
- 18-3 Mapping Between mod_plsql and Embedded PL/SQL Gateway Global Attributes
- 18-4 Authentication Possibilities for a DAD
- 19-1 Continuous Query Notification Registration Options
- 19-2 Attributes of CQ_NOTIFICATION$_REG_INFO
- 19-3 Quality-of-Service Flags
- 19-4 Attributes of CQ_NOTIFICATION$_DESCRIPTOR
- 19-5 Attributes of CQ_NOTIFICATION$_TABLE
- 19-6 Attributes of CQ_NOTIFICATION$_QUERY
- 19-7 Attributes of CQ_NOTIFICATION$_ROW
- 20-1 PL/SQL Packages and Their Java and JavaScript Equivalents
- 21-1 Parameter Data Type Mappings
- 21-2 External Data Type Mappings
- 21-3 Properties and Data Types
- 22-1 Oracle Flashback Version Query Row Data Pseudocolumns
- 22-2 Flashback TRANSACTION_BACKOUT Options
- 22-3 Static Data Dictionary Views for Flashback Archive Files
- 25-1 General Structure of EPC Encodings
- 25-2 Identity Code Package ADTs
- 25-3 MGD_ID ADT Subprograms
- 25-4 DBMS_MGD_ID_UTL Package Utility Subprograms
- 25-5 Definition and Description of the MGD_ID_CATEGORY Metadata View
- 25-6 Definition and Description of the USER_MGD_ID_CATEGORY Metadata View
- 25-7 Definition and Description of the MGD_ID_SCHEME Metadata View
- 25-8 Definition and Description of the USER_MGD_ID_SCHEME Metadata View
- 28-1 LRA and Saga Annotations
- 28-2
saga_finalization$
table entries - 29-1 Reservation Table Columns
- 30-1 Required XA Features Published by Oracle Database
- 30-2 XA Library Subprograms
- 30-3 Oracle XA Interface Extensions
- 30-4 Required Fields of xa_open string
- 30-5 Optional Fields in the xa_open String
- 30-6 TX Interface Functions
- 30-7 TPM Replacement Statements
- 30-8 Sample Trace File Contents
- 30-9 Tightly and Loosely Coupled Transaction Branches
- 31-1 Errors Summary
- 32-1 Database Object Status
- 32-2 Operations that Cause Fine-Grained Invalidation
- 32-3 Data Type Classes
- 33-1 *_ Dictionary Views with Edition Information
- 33-2 *_ Dictionary Views with Editioning View Information
- 34-1 LTXID Condition or Situation, Application Actions, and Next LTXID to Use
- 34-2 Transaction Manager Conditions/ Situations and Actions