Oracle PL/SQL Best Practices, 2/e

In this compact book, Steven Feuerstein,widely recognized as one of the world's leading experts on the Oracle PL/SQLlanguage, distills his many years of programming, teaching, and writing aboutPL/SQL into a set of best practices-recommendations for developing successfulapplications. Covering the latest Oracle release, Oracle Database 11g,Feuerstein has rewritten this new edition in the style of his bestsellingOracle PL/SQL Programming. The text is organized in a problem/solution format,and chronicles the programming exploits of developers at a mythical companycalled My Flimsy Excuse, Inc., as they write code, make mistakes, and learnfrom those mistakes-and each other.

This book offers practical answers to some of the hardest questions faced byPL/SQL developers, including:

 

• What is the best way to write the SQL logic in my application code?
• How should I write my packages so they can be leveraged by my entire team of developers?
• How can I make sure that all my team's programs handle and record errors consistently?

OraclePL/SQL Best Practices summarizes PL/SQL best practices in nine majorcategories: overall PL/SQL application development; programming standards;program testing, tracing, and debugging; variables and data structures; controllogic; error handling; the use of SQL in PL/SQL; building procedures,functions, packages, and triggers; and overall program performance.

Thisbook is a concise and entertaining guide that PL/SQL developers will turn toagain and again as they seek out ways to write higher quality code and moresuccessful applications.

---