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 |