From the authorized Oracle Press comes a complete guide to developing PL/SQL solutions quickly and easily. Inside, you'll find ready-to-run code and expert techniques with in-depth explanations that will help you understand the behaviors created, and even extend usage through customization. The CD-ROM contains scripts from the book and bonus chapters.
Perform Database and Application Management Tasks Efficiently
Access a handpicked collection of essential, ready-to-run scripts to help you develop PL/SQL solutions more quickly and easily than you ever imagined. Verify performance, obtain information about characteristics, simplify management of database objects and users, and more--all through the use of preassembled scripts. Plus, expert authors supplement the scripts with in-depth explanations that will help you understand the behaviors created and even extend usage through customization. Organized by function, this book provides a thorough collection of fully documented SQL and PL/SQL scripts, including a display of sample results to help you analyze and optimize your applications. *
Use ready-to-run code to develop instant Oracle solutions *
Develop and deploy custom PL/SQL applications *
Write for Oracle7 Release 7.x, Oracle8 Release 8.x, Oracle8i, and Oracle9i *
Learn to performance-tune applications and use diagnostic scripts *
Discover native dynamic SQL options available as of Oracle8i *
Understand subpartitions, reverse indexes, iots, and materialized views *
Utilize random number generators while managing data *
Optimize shared memory usage in the System Global Area *
Manage databases, users, storage, and more *
Manage Java in the database
CD-ROM contains major scripts from the book and bonus chapters with additional scripts including a full chapter on managing Java in the database