Oracle PL/SQL Best Practices: Write the Best PL/SQL Code of Your Life
Select Format
Select Condition 
Book Overview
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 11gR2, Feuerstein has rewritten this new edition in the style of his bestselling Oracle PL/SQL Programming. The text is organized in a problem/solution format, and chronicles the programming exploits of developers at a mythical company called My Flimsy Excuse, Inc., as they write code, make mistakes, and learn from those mistakes-and each other.
This book offers practical answers to some of the hardest questions faced by PL/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? Oracle PL/SQL Best Practices summarizes PL/SQL best practices in nine major categories: overall PL/SQL application development; programming standards; program testing, tracing, and debugging; variables and data structures; control logic; error handling; the use of SQL in PL/SQL; building procedures, functions, packages, and triggers; and overall program performance.
This book is a concise and entertaining guide that PL/SQL developers will turn to again and again as they seek out ways to write higher quality code and more successful applications.
"This book presents ideas that make the difference between a successful project and one that never gets off the ground. It goes beyond just listing a set of rules, and provides realistic scenarios that help the reader understand where the rules come from. This book should be required reading for any team of Oracle database professionals."
--Dwayne King, President, KRIDAN Consulting
This book offers practical answers to some of the hardest questions faced by PL/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? Oracle PL/SQL Best Practices summarizes PL/SQL best practices in nine major categories: overall PL/SQL application development; programming standards; program testing, tracing, and debugging; variables and data structures; control logic; error handling; the use of SQL in PL/SQL; building procedures, functions, packages, and triggers; and overall program performance.
This book is a concise and entertaining guide that PL/SQL developers will turn to again and again as they seek out ways to write higher quality code and more successful applications.
"This book presents ideas that make the difference between a successful project and one that never gets off the ground. It goes beyond just listing a set of rules, and provides realistic scenarios that help the reader understand where the rules come from. This book should be required reading for any team of Oracle database professionals."
--Dwayne King, President, KRIDAN Consulting
Format:Paperback
Language:English
ISBN:0596514107
ISBN13:9780596514105
Release Date:November 2007
Publisher:O'Reilly Media
Length:292 Pages
Weight:0.95 lbs.
Dimensions:0.5" x 6.0" x 8.9"
Customer Reviews
5 ratings
Just a note
Published by Thriftbooks.com User , 16 years ago
I really enjoyed reading this book. Even if I don't agree with everything, it's an extremely usefull book to read.
Nice story-telling style to explain the do's and don'ts
Published by Thriftbooks.com User , 16 years ago
A few years ago I bought the first edition of this book. It had a meaningful classification of the suggested best practices and each of them was presented in a consistent way e.g. Title, Example, Benefits, and Challenges. 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.
Well worth the price
Published by Thriftbooks.com User , 22 years ago
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. All of the practices strike me as at least arguable.It does what it sets out to do. I believe that it will help the reader use PL/SQL more effectively. In the next edition, I'd like to see a section on unit testing, using the utPLSQL system that Feuerstein is managing the development of.
Excellent resource for new or experienced PL/SQL programmers
Published by Thriftbooks.com User , 22 years ago
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.
Wisdom in a Package
Published by Thriftbooks.com User , 23 years ago
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 !
Copyright © 2025 Thriftbooks.com
Terms of Use | Privacy Policy | Do Not Sell/Share My Personal Information | Cookie Policy | Cookie Preferences | Accessibility Statement
ThriftBooks ® and the ThriftBooks ® logo are registered trademarks of Thrift Books Global, LLC
ThriftBooks ® and the ThriftBooks ® logo are registered trademarks of Thrift Books Global, LLC
