Oracle PL/SQL Best Practices

  • ISBN13: 9780596514105
  • Condition: NEW
  • Notes: Brand New from Publisher. No Remainder Mark.

Product Description
In this compact book, Steven Feuerstein, widely recognized as one of the world’s leading experts on the Oracle PL/SQL language, distills his many years of programming, teaching, and writing about PL/SQL into a set of best practices-recommendations for developing successful applications. Covering the latest Oracle release, Oracle Database 11g, Feuerstein has rewritten this new edition in the style of his bestselling Oracle PL/SQL Programming. The text is organized in… More >>

Oracle PL/SQL Best Practices


  1. You can glean some of Steven Feuerstein’s insights on PL/SQL development from his other books on PL/SQL. In fact, his books were how I learned the subject and the basis for the PL/SQL guidelines that I have used within various companies for years. Here for the first time, however, Steven focuses completely on the practices that a PL/SQL developers needs to know to develop real world PL/SQL apps that are well-written and easy-to-maintain.

    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!
    Rating: 5 / 5

  2. I found this book to be an excellent (re-)introduction to good programming practices in PL/SQL. After reading the first few pages a little defensively (“I don’t make those sorts of mistakes do I?”) I soon realised that there was much to learn in this book as well as much that I had forgotten.

    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.
    Rating: 5 / 5

  3. This is not a text for learning PL/SQL programming. Feuerstein’s PL/SQL Programming text is much more suited for that. What you have in this book is information that the author has distilled from his other works. In a way it could be considered a summary as the title might suggest. This book is a must have for the leader of an organization that is beginning to use PL/SQL. You will find what you need for your programming standards here.

    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.
    Rating: 4 / 5

  4. I have been an avid reader of Steven’s books ever since I started learning PL/SQL as part of my career in Oracle. Without a doubt he is an authority on this proprietary language from Oracle and has a vast repository of code that he can proudly claim his own. This book is ideal for those who have experience working with applications built on Oracle. You may have encountered situations in which you probably chose an approach to solve a problem or get something done in a hurry without thinking through the implications on performance or taking recourse to some useful features in PL/SQL. These practices classified by topic will not only explain the wisdom but also illustrate how to use it.

    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 !
    Rating: 5 / 5

  5. 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 me to gain some wisdom quickly and point the rest in the right direction. I also had another Oracle reference book, but for schooling an Oracle novice on best practices, this was great. I ended up implementing a common exception handling package that was inspired by what I read in this book, and it turned out to be greatly needed.

    I wish it had been a bit more detailed in places, and if it were up to twice as long that would probably have made it better. The ability to look things up in an index was also strangely limited.

    The book isn’t perfect, but it was money very well spent.

    Rating: 4 / 5

Leave a comment