Oracle9i Instant PL/SQL Scripts [Paperback]

Kevin Loney (Author), Megh Thakkar (Author), Rachel Carmichael (Author)

Book Description

Publication Date: October 8, 2001 | Series: Oracle Press

This text provides readers with a comprehensive collection of SQL and PL/SQL scripts. It is organized into chapters by function and each script is fully documented with sample results shown. Readers can understand how the script works, learn to customize the script with confidence, and act properly on the script's results. Features include: scripts specifically for Oracle9i; a CD-ROM including major scripts from book; CD-icon with script name next to scripts that appear on the CD to allow for a quick search; a list of scripts and a brief description at the beginning of each chapter; and "Programmer's Notes" and "Annotations" that provide expert explanations on the scripts and how they can be customized.

Editorial Reviews

From the Back Cover

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

About the Author

Megh Thakkar (Sydney, Australia) is the Director of Database Technologies at Quest Software. Previously, he worked as a technical specialist at Oracle Corporation. Megh holds a master's degree in computer science and a bachelor's degree in electronics engineering. He also holds several industry vendor certifications, including OCP, MCSE, Novell Certified ECNE, SCO UNIX ACE, and he is a Lotus Notes Certified Consultant. Voted as the best speaker at the NSWOUG'2000 in Sydney, Australia, he is a frequent presenter at Oracle OpenWorld and various international Oracle User Groups. Kevin Loney (Wilmington, DE) is a veteran Oracle developer and DBA. He is among the most renowned members of the Oracle Professional community and is a regular presenter at IOUG-A, Oracle OpenWorld, and regional User Group conferences. Kevin is the author of several of Osborne's best-selling titles such as Oracle8i: The Complete Reference and Oracle 8i: DBA Handbook. Rachel Carmichael (Port Washington, NY) has been an Oracle DBA for more than nine years. She chairs the DBA SIG for the NYOUG. She is OCP certified and has presented at various seminars worldwide. She co-authored Oracle SQL & PL SQL Annotated Archives and Oracle DBA 101.

Product Details

• Paperback: 782 pages
• Publisher: McGraw-Hill Companies (October 8, 2001)
• Language: English
• ISBN-10: 0072132183
• ISBN-13: 978-0072132182
• Product Dimensions: 9.1 x 7.4 x 1.5 inches
• Shipping Weight: 2.8 pounds
• Average Customer Review: 5.0 out of 5 stars  See all reviews (1 customer review)
• Amazon Best Sellers Rank: #2,171,909 in Books (See Top 100 in Books)

Customer Reviews

Most Helpful Customer Reviews

9 of 11 people found the following review helpful:

5.0 out of 5 stars Starter kit for new DBAs, June 4, 2002

By 

Linda Zarate "IT Ops Consultant" (Azusa, CA United States) - See all my reviews

This review is from: Oracle9i Instant PL/SQL Scripts (Paperback)

This collection of scripts is a great starter kit for new DBAs because it contains highly useful code for nearly all of the basic administration, tuning and troubleshooting tasks encountered on the job.

What I like is this isn't just a collection of code on a CD ROM, but each script is carefully explained in the text of the book. For someone like myself who is still in OCP training the explanations are almost as valuable as the code. Although the title claims that the scripts are for Oracle 9i, they also work with 8i, and the book covers what modifications (if any) need to be made to use each script in earlier versions of Oracle.