Structure of This Book This book is divided into ten chapters and one appendix, as follows . Chapter 1, introduces Oracle8 i and summarizes the new PL/SQL- related features. Chapter 2, describes autonomous transactions. This feature lets PL/SQL developers execute and then save or cancel certain statements without affecting the overall session's transaction. Chapter 3, describes a new feature of PL/SQL that lets you decide at the time of compilation whether a program, or all of the programs in a package, should run under the authority of the definer or the invoker of the program. Chapter 4, unveils a powerful replacement for (or at least an alternative to) the use of the DBMS_SQL built-in package. Chapter 5, describes bulk binds and collects. Bulk binds let you bundle DML operations (via the new FORALL statement) for bulk passing to the SQL layer; bulk collects let you retrieve multiple rows with an absolute minimum of context switches. Chapter 6, discusses how Oracle8 i has expanded the use of triggers to perform database- and schema-level operations and "publish" information about events taking place within the database. Chapter 7, describes the new built-in packages available in Oracle8 i and discusses changes to existing packages. Chapter 8, examines a new Oracle8 i feature that allows you to implement security policies with functions and then use those policies to implement row-level security on tables and views. Chapter 9, takes a look at what many people think is the most exciting feature of Oracle8 i the interface to Java. This chapter focuses on how you can call Java stored procedures ( JSPs) from within PL/SQL. Chapter 10, describes a variety of new features and performance improvements that don't fit into any other category. The appendix, What's on the Companion Disk? , explains how to install and use the software on the companion diskette. |
Team-Fly |
Top |