Mastering Oracle PL/SQL

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.

There is ample evidence from community discussion lists that many developers really struggle when it comes to actually applying PL/SQL stored procedures to their real world problems. There are several books on the market that teach the PL/SQL language and will dedicate a few chapters to the fundamental of stored procedures. However, Mastering Oracle PL/SQL will help take them to the next level. It shows clearly the sort of problems that can (and should) be solved using stored procedures, and how to code them effectively. It focuses exclusively on real practical uses of PL/SQL in the database - as a highly efficient data handling language, as a database administration tool, a web development language, a security mechanism and more. It also shows how to exploit the versatile functionality of Java stored procedures, right in the database, to extend the capabilities of PL/SQL.

1 Efficient PL/SQL.- 2 Package It All Up.- 3 The Vexed Subject of Cursors.- 4 Effective Data Handling.- 5 PL/SQL Optimization Techniques.- 6 Triggers.- 7 DBA Packages.- 8 Security Packages.- 9 Web Packages.- 10 PL/SQL Debugging.- Appendix A Building DEBUG.- Database Design and Setup.- Package Layout.- Implementation.- Troubleshooting DEBUG.