Oracle PL/SQL Programming: Guide to Oracle8i Features
Oracle PL/SQL Programming: Guide to Oracle8i Features
ISBN: B000H2MK2W
EAN: N/A
EAN: N/A
Year: 1998
Pages: 107
Pages: 107
Authors: Steven Feuerstein
- Main
- TOC
- 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 PLSQL Developers
- 1.1 What s in Oracle8i Release 8.1?
- 1.2 And Then There s Java
- 1.3 New PLSQL Features Roundup
- Chapter 2. Choose Your Transaction
- 2.1 Transaction Management in PLSQL
- 2.2 Defining Autonomous Transactions
- 2.3 When to Use Autonomous Transactions
- 2.4 Rules and Restrictions
- 2.5 Examples
- Chapter 3. Invoker Rights: Your Schema or Mine?
- 3.1 A Look at the Definer Rights Model
- 3.2 The Invoker Rights Model
- Invoker Rights for Dynamic SQLH2 P classdoc
- 3.4 Combining the Definer and Invoker Rights Models
- Chapter 4. Native Dynamic SQL in Oracle8i
- 4.1 DBMS_SQL Versus NDS
- 4.2 NDS Statement Summary
- 4.3 Multirow Queries with Cursor Variables
- 4.4 Binding Variables
- 4.5 Working with Objects and Collections
- 4.6 Building Applications with NDS
- 4.7 NDS Utility Package
- Chapter 5. Bulking Up with PLSQL 8.1
- 5.1 Context-Switching Problem Scenarios
- 5.2 Bulk DML with the FORALL Statement
- 5.3 Bulk Querying with the BULK COLLECT Clause
- 5.4 Using Cursor Attributes
- 5.5 Analyzing the Impact of Bulk Operations
- Chapter 6. New Trigger Features in Oracle8i
- 6.1 Triggers on Nested Table View Columns
- 6.2 Database-Level Event Triggers
- 6.3 Schema-Level Event Triggers
- Chapter 7. New and Enhanced Built-in Packages in Oracle8i
- 7.1 DBMS_PROFILER: Providing Code Profiling
- 7.2 DBMS_TRACE: Providing a PLSQL Trace Facility
- 7.3 DBMS_RLS: Implementing Fine-Grained Access Control
- 7.4 UTL_COLL: Using Collection Locators
- 7.5 LOB Enhancements
- 7.6 New DBMS_AQ and DBMS_AQADM Features
- 7.7 New DBMS_UTILITY Features
- Chapter 8. Deploying Fine-Grained Access Control
- 8.1 FGAC Components
- 8.2 CREATE CONTEXT: Creating Contexts
- 8.3 SET_CONTEXT: Setting Context and Attribute Values
- 8.4 SYS_CONTEXT and LIST_CONTEXT: Obtaining Context Information
- 8.5 A Complete FGAC Example
- Chapter 9. Calling Java from PLSQL
- 9.1 Oracle8i and Java
- 9.2 Getting Ready to Use Java in Oracle
- 9.3 A Simple Demonstration
- 9.4 Using loadjava
- 9.5 Using dropjava
- 9.6 Managing Java in the Database
- 9.7 Using DBMS_JAVA and DBMS_JAVA_TEST
- 9.8 Publishing and Using Java in PLSQL
- 9.9 Examples
- Chapter 10. More Goodies for Oracle8i PLSQL Developers
- 10.1 The NOCOPY Parameter Mode Hint
- 10.2 Calling Packaged Functions in SQL
- 10.3 SQL99 Compliance
- 10.4 SQL Operations on Collections
- 10.5 Miscellaneous and Minor Improvements
- Appendix A. Appendix: What s on the Companion Disk?
- A.1 Installing the Reference
- A.2 Using the Reference
- Colophon
- INDEX
- SYMBOL
- A
- B
- C
- D
- E
- F
- G
- H
- I
- J
- K
- L
- M
- N
- O
- P
- Q
- R
- S
- T
- U
- V
- W
- X
- Y
Oracle PL/SQL Programming: Guide to Oracle8i Features
ISBN: B000H2MK2W
EAN: N/A
EAN: N/A
Year: 1998
Pages: 107
Pages: 107
Authors: Steven Feuerstein