List of Tables

1-1 PL/SQL and Java Equivalent Software

2-1 Initialization Parameter and COMMIT Options for Managing Commit Redo

2-2 Use of COMMIT, SAVEPOINT, and ROLLBACK

2-3 Ways to Display Locking Information

2-4 Summary of ANSI Isolation Levels

2-5 ANSI Isolation Levels and Oracle Database

2-6 Read Committed Versus Serializable Transaction

2-7 Possible Transaction Outcomes

3-1 Components of the Binary Format for Floating-Point Numbers

3-2 Summary of Binary Format Parameters

3-3 Summary of Binary Format Storage Parameters

3-4 Range and Precision of IEEE 754 formats

3-5 Values Resulting from Exceptions

3-6 Large Object Datatypes

3-7 ANSI Datatype Conversions to Oracle Datatypes

3-8 SQL/DS, DB2 Datatype Conversions to Oracle Datatypes

4-1 SQL Regular Expression Functions and Conditions

4-2 POSIX Metacharacters in Oracle Database Regular Expressions

4-3 POSIX and Multilingual Operator Relationships

4-4 Perl-Influenced Extensions in Oracle Regular Expressions

4-5 Pattern Matching Modifiers

4-6 Explanation of the Regular Expression Elements in Example 4-1

4-7 Explanation of the Regular Expression Elements in Example 4-4

7-1 Attributes of Procedure Parameters

7-2 Parameter Modes

8-1 Code Comparison of DBMS_SQL Package and Native Dynamic SQL

8-2 Querying Using the DBMS_SQL Package and Native Dynamic SQL

8-3 DML Operation Using the DBMS_SQL Package and Native Dynamic SQL

8-4 DML Returning Operation Using the DBMS_SQL Package and Native Dynamic SQL

9-1 Comparison of Built-in Auditing and Trigger-Based Auditing

9-2 System-Defined Event Attributes

9-3 System Manager Events

9-4 Client Events

10-1 Flashback Version Query Row Data Pseudocolumns

11-1 Commonly Used Packages in the PL/SQL Web Toolkit

12-1 PSP Elements

13-1 Attributes of SYS.CHNF$_REG_INFO

13-2 DBMS_CHANGE_NOTIFICATION Subprograms

13-3 Attributes of SYS.CHNF$_DESC

13-4 Attributes of SYS.CHNF$_TDESC

13-5 Attributes of SYS.CHNF$_RDESC

14-1 Parameter Datatype Mappings

14-2 External Datatype Mappings

14-3 Properties and Datatypes

15-1 Required XA Features Published by Oracle Database

15-2 XA Library Subroutines

15-3 Additional Functions in the XA Interface for Oracle Database

15-4 Required Fields for the xa_open() string

15-5 Optional Fields in the xa_open() String

15-6 TX Interface Functions

15-7 TPM Replacement Commands

15-8 Sample Trace File Contents

15-9 Tightly and Loosely Coupled Transaction Branches