Publisher: O'Reilly Media Released: October 1999 Pages: 264
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 -
Examples -
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 -
Binding 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 -
LOB Enhancements -
New DBMS_AQ and DBMS_AQADM Features -
New DBMS_UTILITY Features -
Chapter 8 Deploying Fine-Grained Access Control -
FGAC Components -
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 -
Using loadjava -
Using dropjava -
Managing Java in the Database -
Using DBMS_JAVA and DBMS_JAVA_TEST -
Publishing and Using Java in PL/SQL -
Examples -
Chapter 10 More Goodies for Oracle8i PL/SQL Developers -
The NOCOPY Parameter Mode Hint -
Calling Packaged Functions in SQL -
SQL99 Compliance -
SQL Operations on Collections -
Miscellaneous and Minor Improvements -
Appendix A Appendix: What's on the Companion Disk? -
Installing the Reference -
Using the Reference -
Colophon |
- Title:
- Oracle PL/SQL Programming: Guide to Oracle8i Featu
- By:
- Steven Feuerstein
- Publisher:
- O'Reilly Media
- Formats:
-
- Print:
- October 1999
- Pages:
- 264
- Print ISBN:
- 978-1-56592-675-2
- | ISBN 10:
- 1-56592-675-7
|
-
Steven Feuerstein 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. View Steven Feuerstein's full profile page. |
Colophon 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. |
|
Description
|
Table of Contents
|
Product Details
|
About the Author
|
Colophon
|
 |
|
|
|
|
|
Recommended for You
|
Recently Viewed
|
|
|
By Toby Segaran
August 2007
Ebook: $31.99
Print & Ebook: $43.99
Print: $39.99
By Paul Albitz, Cricket Liu
April 2001
By Jonathan Corbet, Alessandro Rubini
June 2001
|
Customer Reviews
3/29/2003 5.0Oracle PL/SQL Programming Guide to Oracle8i Features Review By sethu pathy from Undisclosed 6/8/2001 5.0Oracle PL/SQL Programming Guide to Oracle8i Features Review By Joe Magni from Undisclosed 10/12/2000 5.0Oracle PL/SQL Programming Guide to Oracle8i Features Review By K Vainstein from Undisclosed 8/18/2000 5.0Oracle PL/SQL Programming Guide to Oracle8i Features Review By Lucy Lugaro from Undisclosed 7/18/2000 3.0Oracle PL/SQL Programming Guide to Oracle8i Features Review By Peter Hobday from Undisclosed |
|
|
