Mastering Oracle PL/SQL: Practical Solutions

by Christopher Beck, Joel Kallman, Chaim Katz, David C. Knox, Connor McDonald

Overview

If you have mastered the fundamentals of the PL/SQL language and are now looking for an in-depth, practical guide to solving real problems with PL/SQL stored procedures, then this is the book for you.

Product Details

ISBN-13:	9781590592175
Publisher:	Apress
Publication date:	01/08/2004
Series:	Oaktable Series
Edition description:	First Edition
Pages:	648
Product dimensions:	7.01(w) x 9.25(h) x 0.30(d)

About the Author

Christopher Beck has a bachelor's degree in computer science from Rutgers University and has been working in the technology industry for 11 years. Starting off as a junior Ada software developer for a government systems integrator, he has spent the past 7 years with Oracle, most recently as a principal technologist. He specializes in core database technologies and web application development. Beck is also a cocreator of Oracle Portal, a commercial product that began as, in Beck's own words, a "science project," then became known as WebView.

Table of Contents

• Efficient PL/SQL
• Package It All Up
• The Vexed Subject of Cursors
• Effective Data Handling
• PL/SQL Optimization Techniques
• Triggers
• DBA Packages
• Security Packages
• Web Packages
• PL/SQL Debugging

Editorial Reviews

The Barnes & Noble Review
Don’t settle for passable PL/SQL. Write great code: robust, efficient, scalable, maintainable. Get Mastering Oracle PL/SQL: Practical Solutions.

The authors are members of the Oaktable Group, an elite, invitation-only organization of top Oracle consultants, architects, and developers. They’ve written the best PL/SQL books we’ve seen yet.

There’s outstanding coverage of cursors (including side-by-side “implicit vs. explicit” performance comparisons). You’ll learn how to more effectively integrate database and application data structures (and get more resilient code). There’s loads of optimization coverage (with ready-made solutions, plus techniques for avoiding “hidden overhead”).

Security. Web packages. Debugging. There’s even an advanced DBA toolkit here. If you’re a serious Oracle professional, you’ll wear this book out. Bill Camarda

Bill Camarda is a consultant, writer, and web/multimedia content developer. His 15 books include Special Edition Using Word 2003 and Upgrading & Fixing Networks for Dummies, Second Edition.

bn.com