TOC

 
   
   
  Table of Contents
  Index
  Reviews
  Examples
  Reader Reviews
  Errata
Oracle PL/SQL Programming Guide to Oracle 8 i Features
By Steven Feuerstein
 
Publisher : O'Reilly
Pub Date : October 1999
ISBN : 1-56592-675-7
Pages : 264
  Copyright
    Dedication
    Preface
      Structure of This Book
      About the Examples
      About the Disk
      Conventions Used in This Book
      How to Contact Us
      Acknowledgments
    Chapter 1.  Oracle8i: A Bounty for PL/SQL Developers
      Section 1.1.  What's in Oracle8i Release 8.1?
      Section 1.2.  And Then There's Java
      Section 1.3.  New PL/SQL Features Roundup
    Chapter 2.  Choose Your Transaction!
      Section 2.1.  Transaction Management in PL/SQL
      Section 2.2.  Defining Autonomous Transactions
      Section 2.3.  When to Use Autonomous Transactions
      Section 2.4.  Rules and Restrictions
      Section 2.5.  Examples
    Chapter 3.  Invoker Rights: Your Schema or Mine?
      Section 3.1.  A Look at the Definer Rights Model
      Section 3.2.  The Invoker Rights Model
      Section 3.3.  One Program, Multiple Schemas
      Section 3.4.  Combining the Definer and Invoker Rights Models
    Chapter 4.  Native Dynamic SQL in Oracle8i
      Section 4.1.  DBMS_SQL Versus NDS
      Section 4.2.  NDS Statement Summary
      Section 4.3.  Multirow Queries with Cursor Variables
      Section 4.4.  Binding Variables
      Section 4.5.  Working with Objects and Collections
      Section 4.6.  Building Applications with NDS
      Section 4.7.  NDS Utility Package
    Chapter 5.  Bulking Up with PL/SQL 8.1
      Section 5.1.  Context-Switching Problem Scenarios
      Section 5.2.  Bulk DML with the FORALL Statement
      Section 5.3.  Bulk Querying with the BULK COLLECT Clause
      Section 5.4.  Using Cursor Attributes
      Section 5.5.  Analyzing the Impact of Bulk Operations
    Chapter 6.  New Trigger Features in Oracle8i
      Section 6.1.  Triggers on Nested Table View Columns
      Section 6.2.  Database-Level Event Triggers
      Section 6.3.  Schema-Level Event Triggers
    Chapter 7.  New and Enhanced Built-in Packages in Oracle8i
      Section 7.1.  DBMS_PROFILER: Providing Code Profiling
      Section 7.2.  DBMS_TRACE: Providing a PL/SQL Trace Facility
      Section 7.3.  DBMS_RLS: Implementing Fine-Grained Access Control
      Section 7.4.  UTL_COLL: Using Collection Locators
      Section 7.5.  LOB Enhancements
      Section 7.6.  New DBMS_AQ and DBMS_AQADM Features
      Section 7.7.  New DBMS_UTILITY Features
    Chapter 8.  Deploying Fine-Grained Access Control
      Section 8.1.  FGAC Components
      Section 8.2.  CREATE CONTEXT: Creating Contexts
      Section 8.3.  SET_CONTEXT: Setting Context and Attribute Values
      Section 8.4.  SYS_CONTEXT and LIST_CONTEXT: Obtaining Context Information
      Section 8.5.  A Complete FGAC Example
    Chapter 9.  Calling Java from PL/SQL
      Section 9.1.  Oracle8i and Java
      Section 9.2.  Getting Ready to Use Java in Oracle
      Section 9.3.  A Simple Demonstration
      Section 9.4.  Using loadjava
      Section 9.5.  Using dropjava
      Section 9.6.  Managing Java in the Database
      Section 9.7.  Using DBMS_JAVA and DBMS_JAVA_TEST
      Section 9.8.  Publishing and Using Java in PL/SQL
      Section 9.9.  Examples
    Chapter 10.  More Goodies for Oracle8i PL/SQL Developers
      Section 10.1.  The NOCOPY Parameter Mode Hint
      Section 10.2.  Calling Packaged Functions in SQL
      Section 10.3.  SQL99 Compliance
      Section 10.4.  SQL Operations on Collections
      Section 10.5.  Miscellaneous and Minor Improvements
    Appendix A.  Appendix: What's on the Companion Disk?
      Section A.1.  Installing the Reference
      Section A.2.  Using the Reference
    Colophon
    Index

Top


Oracle PL. SQL Programming. Guide to Oracle8i Features
Oracle PL/SQL Programming: Guide to Oracle8i Features
ISBN: B000H2MK2W
EAN: N/A
Year: 1998
Pages: 107

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net