Ships from: Garland, TX
Usually ships in 1-2 business days
Ships from: fallbrook, CA
Usually ships in 1-2 business days
Ships from: acton, MA
Usually ships in 1-2 business days
Ships from: Springfield, VA
Usually ships in 1-2 business days
Computer professionals increasingly rely on the Web, online help, and other online information sources to relieve information pain. Now O'Reilly's "Oracle PL/SQL CD Bookshelf allows convenient online access to updates of favorite O'Reilly Oracle books.
"The Oracle PL/SQL CD Bookshelf contains a powerhouse of Animal books for the Oracle PL/SQL developer—all readable with a web browser on a convenient CD-ROM. A bonus hard-copy book, "Oracle PL/SQL Programming: A Guide to Oracle 8i Features, is also included.
In addition, the CD-ROM includes the complete text of seven books:
"Oracle PL/SQL Programming; "Advanced PL/SQL Programming; "Oracle Web Applications; "Oracle Built-in Packages; "Oracle PL/SQL Pocket Reference; "Oracle Built-ins Pocket Reference; and "Oracle PL/SQL Programming: A Guide to Oracle 8i Features.
Never has it been easier to learn, or look up, needed information. Formatted in HTML," The Oracle PL/SQL CD Bookshelf can be read by any web browser. The books are fully searchable and cross-referenced. In addition to individual indexes for each book, there's a master index for the entire library.
| Preface | xi | |
| 1. | Oracle8i: A Bounty for PL/SQL Developers | 1 |
| What's in Oracle8i Release 8.1? | 1 | |
| And Then There's Java | 2 | |
| New PL/SQL Features Roundup | 3 | |
| 2. | Choose Your Transaction! | 13 |
| Transaction Management in PL/SQL | 13 | |
| Defining Autonomous Transactions | 14 | |
| When to Use Autonomous Transactions | 16 | |
| Rules and Restrictions | 18 | |
| Examples | 23 | |
| 3. | Invoker Rights: Your Schema or Mine? | 32 |
| A Look at the Definer Rights Model | 32 | |
| The Invoker Rights Model | 37 | |
| One Program, Multiple Schemas | 40 | |
| Combining the Definer and Invoker Rights Models | 45 | |
| 4. | Native Dynamic SQL in Oracle8i | 48 |
| DBMS_SQL Versus NDS | 49 | |
| NDS Statement Summary | 51 | |
| Multirow Queries with Cursor Variables | 56 | |
| Binding Variables | 63 | |
| Working with Objects and Collections | 69 | |
| Building Applications with NDS | 72 | |
| NDS Utility Package | 80 | |
| 5. | Bulking Up with PL/SQL 8.1 | 82 |
| Context-Switching Problem Scenarios | 83 | |
| Bulk DML with the FORALL Statement | 85 | |
| Bulk Querying with the BULK COLLECT Clause | 90 | |
| Using Cursor Attributes | 96 | |
| Analyzing the Impact of Bulk Operations | 99 | |
| 6. | New Trigger Features in Oracle8i | 102 |
| Triggers on Nested Table View Columns | 103 | |
| Database-Level Event Triggers | 106 | |
| Schema-Level Event Triggers | 116 | |
| 7. | New and Enhanced Built-in Packages in Oracle8i | 120 |
| DBMS_PROFILER: Providing Code Profiling | 122 | |
| DBMS_TRACE: Providing a PL/SQL Trace Facility | 125 | |
| DBMS_RLS: Implementing Fine-Grained Access Control | 128 | |
| UTL_COLL: Using Collection Locators | 134 | |
| LOB Enhancements | 136 | |
| New DBMS_AQ Features | 141 | |
| New DBMS_UTILITY Features | 151 | |
| 8. | Deploying Fine-Grained Access Control | 153 |
| FGAC Components | 154 | |
| CREATE CONTEXT: Creating Contexts | 155 | |
| SET_CONTEXT: Setting Context Attribute Values | 157 | |
| SYS_CONTEXT and LIST_CONTEXT: Obtaining Context Information | 158 | |
| A Complete FGAC Example | 163 | |
| 9. | Calling Java from PL/SQL | 171 |
| Oracle8i and Java | 171 | |
| Getting Ready to Use Java in Oracle | 173 | |
| A Simple Demonstration | 176 | |
| Using loadjava | 182 | |
| Using dropjava | 185 | |
| Managing Java in the Database | 186 | |
| Using DBMS_JAVA and DBMS_JAVA_TEST | 188 | |
| Publishing and Using Java in PL/SQL | 194 | |
| Examples | 202 | |
| 10. | More Goodies for Oracle8i PL/SQL Developers | 210 |
| The NOCOPY Parameter Mode Hint | 211 | |
| Calling Packaged Functions in SQL | 219 | |
| SQL99 Compliance | 225 | |
| SQL Operations on Collections | 230 | |
| Miscellaneous and Minor Improvements | 232 | |
| Appendix | What's on the Companion Disk? | 235 |
| Index | 239 |
Overview
Computer professionals increasingly rely on the Web, online help, and other online information sources to relieve information pain. Now O'Reilly's "Oracle PL/SQL CD Bookshelf allows convenient online access to updates of favorite O'Reilly Oracle books.
"The Oracle PL/SQL CD Bookshelf contains a powerhouse of Animal books for the Oracle PL/SQL developer—all readable with a web browser on a convenient CD-ROM. A bonus hard-copy book, "Oracle PL/SQL Programming: A Guide to Oracle 8i...