Oracle9i Instant PL/SQL Scripts (Oracle Press) - Softcover

Loney, Kevin; Thakkar, Megh; Carmichael, Rachel

Softcover

ISBN 10: 0072132183 ISBN 13: 9780072132182

Publisher: McGraw-Hill Education, 2001

Synopsis

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.

About this title

About the Authors

Kevin Loney (Wilmington, DE) is a veteran Oracle developer and DBA. He is the author of the best-selling Oracle8 DBA Handbook and co-author of Advanced Tuning and Administration and Oracle8i: The Complete Reference. He frequently makes presentations at Oracle conferences and contributes to Oracle Magazine

Megh Thakkar (Sydney, Australia) is the Director of Database Technologies at Quest Software. Previously, he worked as a technical specialist at Oracle Corporation. Thakkar holds a masters degree in computer science and a bachelors 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 NSWOUG2000 in Sydney, Australia, he is a frequent presenter at Oracle OpenWorld and various international Oracle User Groups.

Rachel Carmichael has been an Oracle DBA for over nine ears. She chairs the DBA Special Interest Group for the New ork Oracle Users Group, is both Chauncey and OCP certified, and has presented at various international and national conferences, including the ECO all-day DBA seminar for the past three years. She coauthored the Oracle Press book, Oracle SQL and PL/SQL Annotated Archives, 1998, with Kevin Loney, and this Oracle Press book, Oracle DBA 101, 2000, with Marlene Theriault and James Viscusi.

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

Edition details

• Publisher: McGraw-Hill Education
• Publication date: 2001
• Language: English
• ISBN 10: 0072132183
• ISBN 13: 9780072132182
• Binding: Paperback
• Edition number: 2
• Number of pages: 656