Oracle8i, the long-awaited "Internet database" from Oracle Corporation, has hit the streets running--and you may find yourself struggling to keep up with Oracle's fast-moving technology. Oracle boasts that Oracle8i offers more than 150 new features, many of them designed to make its popular database programming language, PL/SQL, faster, more powerful, and easier to use.This concise and engaging book is both a companion to Oracle PL/SQL Programming (widely recognized as the "bible" for PL/SQL developers) and a guide designed to bring you up to speed as quickly as possible on the new PL/SQL features of Oracle8i. Following the style of Feuerstein's earlier books, the Guide to Oracle8i Features combines easy-to-understand descriptions of the new Oracle8i features with a wealth of interesting and informative examples.The major Oracle8i PL/SQL features include the following:
Autonomous transactions--the ability to commit or roll back changes without affecting the "main" transaction in the rest of your session
Invoker rights--At compilation time, you can now decide whether a program (or all programs in a package) should run under the authority of the definer or the invoker of that program
Native dynamic SQL--A native implementation of dynamic SQL that's faster and easier than the DBMS_SQL built-in package
Bulk binds and collects--A major performance improvement that lets you process multiple rows in a single operation
System-level database triggers--With this feature and Advanced Queueing (AQ), you can take advantage of the publish/subscribe capabilities of Oracle8i
Fine-grained access control--This feature lets you implement security policies with functions and then use those functions to implement row-level security on tables or views.
Many new and enhanced built-in packages--New packages include DBMS_JAVA, DBMS_PROFILER, DBMS_TRACE, and more. DBMS_UTILITY, DBMS_AQ, and others have been enhanced as well.
Calling Java methods from within PL/SQL--The book includes enough Java know-how to help you build simple Java classes, load them into the Oracle8i database, and leverage those classes from within your PL/SQL code.
Some PL/SQL developers are uneasy about what the introduction of Java means to their applications--and their programming future. But the two languages are expected to work well together in Oracle8i. You'll be able to take advantage of all the power of Java without giving up the performance and usability advantages of PL/SQL!Included with this book is a diskette containing an online tool developed by RevealNet, Inc., that provides point-and-click access to approximately 100 files of reusable source code and examples.The Guide to Oracle8i Features showcases all the powerful new features of Oracle8i designed especially for PL/SQL developers. You'll find it indispensable as you strive to take the fullest possible advantage of everything this exciting new version has to offer.Table of Contents:
Oracle8i: A Bounty for PL/SQL Developers
Choose Your Transaction!
Invoker Rights: Your Schema or Mine?
Native Dynamic SQL in Oracle8i
Bulking Up with PL/SQL 8.1
New Trigger Features in Oracle8i
New and Enhanced Built-in Packages in Oracle8i
Deploying Fine-Grained Access Control
Calling Java from PL/SQL
More Goodies for Oracle PL/SQL Developers
Chapter 1 Oracle8i: A Bounty for PL/SQL Developers
What's in Oracle8i Release 8.1?
And Then There's Java
New PL/SQL Features Roundup
Chapter 2 Choose Your Transaction!
Transaction Management in PL/SQL
Defining Autonomous Transactions
When to Use Autonomous Transactions
Rules and Restrictions
Chapter 3 Invoker Rights: Your Schema or Mine?
A Look at the Definer Rights Model
The Invoker Rights Model
One Program, Multiple Schemas
Combining the Definer and Invoker Rights Models
Chapter 4 Native Dynamic SQL in Oracle8i
DBMS_SQL Versus NDS
NDS Statement Summary
Multirow Queries with Cursor Variables
Working with Objects and Collections
Building Applications with NDS
NDS Utility Package
Chapter 5 Bulking Up with PL/SQL 8.1
Context-Switching Problem Scenarios
Bulk DML with the FORALL Statement
Bulk Querying with the BULK COLLECT Clause
Using Cursor Attributes
Analyzing the Impact of Bulk Operations
Chapter 6 New Trigger Features in Oracle8i
Triggers on Nested Table View Columns
Database-Level Event Triggers
Schema-Level Event Triggers
Chapter 7 New and Enhanced Built-in Packages in Oracle8i
DBMS_PROFILER: Providing Code Profiling
DBMS_TRACE: Providing a PL/SQL Trace Facility
DBMS_RLS: Implementing Fine-Grained Access Control
UTL_COLL: Using Collection Locators
New DBMS_AQ and DBMS_AQADM Features
New DBMS_UTILITY Features
Chapter 8 Deploying Fine-Grained Access Control
CREATE CONTEXT: Creating Contexts
SET_CONTEXT: Setting Context and Attribute Values
SYS_CONTEXT and LIST_CONTEXT: Obtaining Context Information
A Complete FGAC Example
Chapter 9 Calling Java from PL/SQL
Oracle8i and Java
Getting Ready to Use Java in Oracle
A Simple Demonstration
Managing Java in the Database
Using DBMS_JAVA and DBMS_JAVA_TEST
Publishing and Using Java in PL/SQL
Chapter 10 More Goodies for Oracle8i PL/SQL Developers
The NOCOPY Parameter Mode Hint
Calling Packaged Functions in SQL
SQL Operations on Collections
Miscellaneous and Minor Improvements
Appendix A Appendix: What's on the Companion Disk?
Installing the Reference
Using the Reference
Oracle PL/SQL Programming: Guide to Oracle8i Featu
Steven Feuerstein is considered one of the world's leading experts on the Oracle PL/SQL language. He is the author or coauthor of Oracle PL/SQL Programming, Oracle PL/SQL Best Practices, Oracle PL/SQL Programming: Guide to Oracle8i Features, Oracle PL/SQL Developer's Workbook, Oracle Built-in Packages, Advanced Oracle PL/SQL Programming with Packages, and several pocket reference books (all from O'Reilly & Associates). Steven is a Senior Technology Advisor with Quest Software, has been developing software since 1980, and worked for Oracle Corporation from 1987 to 1992.
Our look is the result of reader comments, our own experimentation, and feedback from distribution channels. Distinctive covers complement our distinctive approach to technical topics, breathing personality and life into potentially dry subjects. The insect on the cover of Oracle PL/SQL Programming: Guide to Oracle8i Features is a luna moth. One of the 100,000 species of moth, the luna moth (Actius luna) is found only in North America. The pale green color and delicate swirled tails of its wings make the luna moth one of the loveliest species of moth.Like the wings of all moths, the luna mothÂ¹s wings are covered with tiny, flattened, overlapping scales. The two pairs of wings move in tandem and operate as a single pair. When resting, these wings are spread open, unlike the butterflyÂ¹s wings, which fold closed in rest. The eye spots on the luna mothÂ¹s wings are intended to frighten away potential predators.The adult luna moth has a very short lifespan-approximately one week. During that short life, adult luna moths do not eat at all; they get all of their nourishment during the caterpillar stage. Luna moth caterpillars feed on tree leaves, and tend not to be very picky about what kind of tree.Although rarely sighted, the beautiful luna moth is not currently listed on the U.S. Fish and Wildlife Services Endangered Species List. Madeleine Newell was the production editor for this book, and Cindy Kogut of Editorial Ink was the copyeditor. Ellie Cutler and Nancy Kotary provided quality assurance, and Jeff Holcomb and Abby Myers provided production assistance. Pamela Murray wrote the index.Edie Freedman designed the cover of this book, using a nineteenth-century engraving from the Dover Pictorial Archive. Kathleen Wilson produced the cover layout and designed and produced the diskette label with QuarkXPress 3.3, using the ITC Garamond font. Whenever possible, our books use a durable and flexible lay-flat binding. If the page count exceeds the limit, perfect binding is used.The inside layout was designed by Alicia Cech, based on a series design by Nancy Priest, and implemented in FrameMaker 5.5 by Mike Sierra. The text and heading fonts are ITC Garamond Light and Garamond Book. The illustrations that appear in this book were produced by Robert Romano and Rhon Porter using Macromedia Freehand 8 and Adobe Photoshop 5. This colophon was written by Clairemarie Fisher OÂ¹Leary.
Oracle PL/SQL Programming Guide to Oracle8i Features Review
By Peter Hobday
Comments about oreilly Oracle PL/SQL Programming: Guide to Oracle8i Featu:
I disagree with the tone of most of the other reviews of this book. It makes a change to find examples that are not just based on EMP or SAL or simply boring beyond comprehension. Whilst I found some of Mr Feuerstein's comments a bit too flippant for my taste, it is a change to find an IT author who appears to be able to see beyond his monitor into the world outside. I do think, however, that the editorial staff ought to have softened the tone a little.