Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.
To get the free app, enter your mobile phone number.
Oracle PL/SQL Best Practices 2nd Edition
Use the Amazon App to scan ISBNs and compare prices.
Frequently Bought Together
Customers Who Bought This Item Also Bought
Top Customer Reviews
In the book, Steven covers the various topics that a developer needs to know. Starting from a high level view of the development process and coding styles/conventions, he drills down to the detailed technical issues of creating variables and data structures, control structures and exception handling. There is an excellent section on coding SQL statements in PL/SQL, which is one of the main reasons for writing PL/SQL to begin with. The book closes with an examination of functions, procedures and packages including several of Oracle's key built-in packages.
The best practices themselves are well-organized, concise and illustrated with specific examples. Steven provides his own insights for each best practice. As with all his books, this one is well thought out and worth twice the price!
In addition to good standards suggestions, the author also gives a lot of resources that are available to PL/SQL developers. One of the prime examples is utPLSQL, a unit testing tool for stored procedures and functions. The author gives numerous other web sites and tool suggestions throughout the book.
Anyone looking to increase their PL/SQL productivity should pick up this book.
This book has lead to an instant improvement in the quality of my PL/SQL code. I particularly like the Quick Reference card in the back of the book.
As the technology evolved (and the links mentioned were not there anymore), I bought this second edition expecting an update in the available tools to support the best practices and probably one or two chapters related to the new Oracle PL/SQL features. Those things were definitely there but I was surprised to find a totally rewritten book. Steven Feuerstein opted for a story-telling style instead of the formal approach followed in the first edition. By describing a project inside an imaginary company with its imaginary employees (each of them with a different character and a different way of working), it is definitely easier (and funnier) to read.
Good programming practices are common to all languages so I didn't expect any big surprises (naming conventions, layout, keeping procedures short, avoid repeating code, etc). What I found extremely valuable was the chapter about exception handling, the advice about how to implement a test-driven approach for the PL/SQL code, the reference to software tools (free and commercial) that can be used in the development process, and the online resources (PL/SQL code, articles).
My only criticism would be the Quick Reference provided in the book. After having read the book, it was not so easy for me to find again a particular section or example. I had to re-read a few pages in order to find what I was looking for (contrary to the first edition where this was very easy done).
I would recommend this book to any beginner or intermediate PL/SQL developer, although I am sure that even experienced ones will learn valuable things.
Make sure you keep it handy and follow these guidelines religiously in your application code.
Hats off to Steven and O'Reilly for another useful title !
Most Recent Customer Reviews
The best book on PL/SQL that I have run across. This writer also has some online tutorials that cover some specifics in more detail.Published 12 months ago by KM
Very informative; explanations are straight-forward and easily understood. Experienced programmers will benefit from this but may still want to pick and choose among the various... Read morePublished 18 months ago by DooWopFan
Clear, concise, to the point, detailed enough, thought provoking, including examples that you can view and download to your own needs.Published on May 19, 2014 by First time disgrunlted customer from amazon
I got this book when I started using Oracle. I ended up having to write sample code and set standards for other folks who were also new to Oracle and PL/SQL, and this book allowed... Read morePublished on September 17, 2009 by C. Gill
I expected a lot more from a guru. It can be helpful to give examples of what not to do, but these examples cover 50%. Read morePublished on January 9, 2009 by Optimus
I really enjoyed reading this book. Even if I don't agree with everything, it's an extremely usefull book to read.Published on September 3, 2008 by Anna O
Steven Feuerstein's ORACLE PL/SQL BEST PRACTICES, 2ND EDITION provides the author's years of programming, teaching and writing experiences in a set of 'best practices' for... Read morePublished on February 6, 2008 by Midwest Book Review
Simply put, this book should be required reading for anyone who considers themselves a professional PL/SQL developer. Read morePublished on October 28, 2002 by Steven J Kahn
1. I do not follow every practice in this book.
2. Only some of those I don't follow do I think I should follow.
3. Read more