Oracle SQL & PL/SQL Annotated Archives

Customers who bought this book also bought:

Oracle Nt Handbook; Rama Velpuri, Anand Adkoli
Oracle8 Advanced Tuning & Administration; Eyal Aronoff, et al
Oracle Built-In Packages; Steven Feuerstein, et al
Oracle Scripts; Brian Lomasky, David C. Kreines

Reviews
Amazon.com
In Oracle SQL & PL/SQL Annotated Archives, authors Loney and Carmichael have assembled a topical collection of SQL & PL/SQL scripts for Oracle7 and Oracle8. Although this book is not by any means a tutorial for the database's programming language, even skillful database administrators can learn much from the illustrated techniques.

The book begins with a chapter of Oracle8-specific scripts that include warning indicators for password expirations, scripts for determining value distributions across table and index partitions, and others. The rest of the chapters are devoted to particular topics. The first section addresses performance management and includes several scripts for collecting statistics and managing the System Global Area. These performance-related scripts are extremely valuable for any developer.

Next comes a series of scripts related to monitoring transactions, diagnostic utilities to analyze data definition, and similar scripts for managing objects and space. Then it's on to diagnostic and utility scripts for managing users and some general database scripts. The book wraps up with a lengthy appendix that serves as an excellent reference to the PL/SQL language.

Each chapter begins with summary of its scripts, and they are also included on the CD-ROM. Explanatory text is clearly identified as annotations, but the majority of the book consists of highly technical reading. While this book does not make for a very entertaining read, it provides Oracle administrators with powerful tools they can turn to in a pinch. --Stephen Plain

Book Description
Only book to provide hundreds of ready-to-run SQL and PL/SQL scripts to programmers--they will be provided on the CD-ROM. Kevin Loney is one of the best-known names in the Oracle community--authored our all-time #1 title The Oracle Complete Reference. No other book has thousands of lines annitated code--providing in-depth understanding of how to use and customize each program--an exciting new offering to the programming community. A Natural extension of our PL/SQL Programming title with the same reliable backing of Oracle Press.

Synopsis
SQL and PL/SQL are the languages used to program Oracle databases and manipulate their data. This title provides hundreds of ready-to-run SQL and PL/SQL scripts to programmers on the CD-ROM. Also featured are thousands of lines of annotated code providing in-depth understanding how to use and customize each program.

From the Back Cover
The Ultimate Collection of SQL & PL/SQL Scripts and Expert Commentary. Add power and fine-tuning to your daily programming, administration, and management tasks with this collection of annotated SQL and PL/SQL scripts. This unique book and CD set from best-selling author Kevin Loney and Oracle DBA RAchel Carmichael provides you with an extensive collection of scripts - each accompanied by expert commentary on how to customize and use it. You'll also discover numerous proven techniques for resolving problems such as improperly sized memory areas, random number generation, and object dependency issues. The critical topics covered include: Performance tuning; Transaction management; Deadlock resolution; User management; Data and relationship management; Predicting and managing space requirements; Managing Oracle8-specific features including abstract data types, partitions, expiring passowrds, and more. Perform all your database and application management tasks more efficiently with the help of this valuable Oracle tool!

Back to Oracle
Back to Databases
Back to Main Index