List of Figures

1-1 The OCI Development Process

1-2 Software Layers

1-3 Objects and Their Relations

1-4 Supported Oracle Datatypes

2-1 Time Line for Two Transactions

2-2 Referential Integrity Check

2-3 Transaction Control Flow

2-4 Possible Sequences of Autonomous Transactions

2-5 Example: A Buy Order

2-6 Example: Bank Withdrawal—Sufficient Funds

2-7 Example: Bank Withdrawal—Insufficient Funds WITH Overdraft Protection

2-8 Example: Bank Withdrawal—Insufficient Funds WITHOUT Overdraft Protection

5-1 The VENDOR_PARTS Table

6-1 Table with NOT NULL Integrity Constraints

6-2 Table with a UNIQUE Key Constraint

6-3 Tables with Referential Integrity Constraints

7-1 Dependency Relationships

7-2 Exceptions and User-Defined Errors

11-1 PL/SQL Web Application

13-1 Example of Mid-Tier Caching

13-2 Basic Process of Database Change Notification

14-1 Multithreaded External Procedure Agent Architecture

14-2 Oracle Database and External Procedures

15-1 Possible DTP Model

16-1 Oracle Publish-Subscribe Functionality