Books & Videos

Table of Contents

  1. Chapter 1 Oracle8i: A Bounty for PL/SQL Developers

    1. What's in Oracle8i Release 8.1?

    2. And Then There's Java

    3. New PL/SQL Features Roundup

  2. Chapter 2 Choose Your Transaction!

    1. Transaction Management in PL/SQL

    2. Defining Autonomous Transactions

    3. When to Use Autonomous Transactions

    4. Rules and Restrictions

    5. Examples

  3. Chapter 3 Invoker Rights: Your Schema or Mine?

    1. A Look at the Definer Rights Model

    2. The Invoker Rights Model

    3. One Program, Multiple Schemas

    4. Combining the Definer and Invoker Rights Models

  4. Chapter 4 Native Dynamic SQL in Oracle8i

    1. DBMS_SQL Versus NDS

    2. NDS Statement Summary

    3. Multirow Queries with Cursor Variables

    4. Binding Variables

    5. Working with Objects and Collections

    6. Building Applications with NDS

    7. NDS Utility Package

  5. Chapter 5 Bulking Up with PL/SQL 8.1

    1. Context-Switching Problem Scenarios

    2. Bulk DML with the FORALL Statement

    3. Bulk Querying with the BULK COLLECT Clause

    4. Using Cursor Attributes

    5. Analyzing the Impact of Bulk Operations

  6. Chapter 6 New Trigger Features in Oracle8i

    1. Triggers on Nested Table View Columns

    2. Database-Level Event Triggers

    3. Schema-Level Event Triggers

  7. Chapter 7 New and Enhanced Built-in Packages in Oracle8i

    1. DBMS_PROFILER: Providing Code Profiling

    2. DBMS_TRACE: Providing a PL/SQL Trace Facility

    3. DBMS_RLS: Implementing Fine-Grained Access Control

    4. UTL_COLL: Using Collection Locators

    5. LOB Enhancements

    6. New DBMS_AQ and DBMS_AQADM Features

    7. New DBMS_UTILITY Features

  8. Chapter 8 Deploying Fine-Grained Access Control

    1. FGAC Components

    2. CREATE CONTEXT: Creating Contexts

    3. SET_CONTEXT: Setting Context and Attribute Values

    4. SYS_CONTEXT and LIST_CONTEXT: Obtaining Context Information

    5. A Complete FGAC Example

  9. Chapter 9 Calling Java from PL/SQL

    1. Oracle8i and Java

    2. Getting Ready to Use Java in Oracle

    3. A Simple Demonstration

    4. Using loadjava

    5. Using dropjava

    6. Managing Java in the Database

    7. Using DBMS_JAVA and DBMS_JAVA_TEST

    8. Publishing and Using Java in PL/SQL

    9. Examples

  10. Chapter 10 More Goodies for Oracle8i PL/SQL Developers

    1. The NOCOPY Parameter Mode Hint

    2. Calling Packaged Functions in SQL

    3. SQL99 Compliance

    4. SQL Operations on Collections

    5. Miscellaneous and Minor Improvements

  1. Appendix A Appendix: What's on the Companion Disk?

    1. Installing the Reference

    2. Using the Reference

  2. Colophon