Programming Books C Java PHP Python Learn more Browse Programming Books
Oracle PL/SQL Best Practices: Optimizing Oracle Code and over one million other books are available for Amazon Kindle. Learn more
Qty:1
  • List Price: $29.99
  • Save: $9.09 (30%)
FREE Shipping on orders over $35.
In Stock.
Ships from and sold by Amazon.com.
Gift-wrap available.
Add to Cart
Want it tomorrow, April 18? Order within and choose One-Day Shipping at checkout. Details
FREE Shipping on orders over $35.
Used: Very Good | Details
Condition: Used: Very Good
Comment: Former library copy with standard library markings. Eligible for FREE Super Saving Shipping! Fast Amazon shipping plus a hassle free return policy mean your satisfaction is guaranteed!
Add to Cart
Trade in your item
Get a $3.13
Gift Card.
Have one to sell?
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See all 2 images

Oracle PL/SQL Best Practices Paperback

ISBN-13: 978-0596514105 ISBN-10: 0596514107 Edition: Second Edition

See all 5 formats and editions Hide other formats and editions
Amazon Price New from Used from Collectible from
Kindle
"Please retry"
Paperback
"Please retry"
$20.90
$15.03 $13.94

Free%20Two-Day%20Shipping%20for%20College%20Students%20with%20Amazon%20Student



Frequently Bought Together

Oracle PL/SQL Best Practices + Oracle PL/SQL Programming
Price for both: $64.93

Buy the selected items together
  • Oracle PL/SQL Programming $44.03

NO_CONTENT_IN_FEATURE

Shop the new tech.book(store)
New! Introducing the tech.book(store), a hub for Software Developers and Architects, Networking Administrators, TPMs, and other technology professionals to find highly-rated and highly-relevant career resources. Shop books on programming and big data, or read this week's blog posts by authors and thought-leaders in the tech industry. > Shop now

Product Details

  • Paperback: 294 pages
  • Publisher: O'Reilly Media; Second Edition edition (October 29, 2007)
  • Language: English
  • ISBN-10: 0596514107
  • ISBN-13: 978-0596514105
  • Product Dimensions: 8.9 x 6 x 0.5 inches
  • Shipping Weight: 14.9 ounces (View shipping rates and policies)
  • Average Customer Review: 3.9 out of 5 stars  See all reviews (14 customer reviews)
  • Amazon Best Sellers Rank: #179,749 in Books (See Top 100 in Books)

Editorial Reviews

Review

'...(the book) is a good length for a computer book ... 182 pages. Too many computer books these days have many pages and little value. ...So don't buy a copy of this book; instead, buy 12 and make everybody on your team read it - only that way will you get the full benefit of the best practice.' - James Youngman, new@UK, December 2001 --This text refers to an out of print or unavailable edition of this title.

Book Description

Write the Best PL/SQL Code of Your Life

More About the Author

Steven Feuerstein is considered to be one of the world's leading experts on the Oracle PL/SQL language, having written ten books on PL/SQL, including Oracle PL/SQL Programming and Oracle PL/SQL Best Practices (all published by O'Reilly Media). Steven has been developing software since 1980, spent five years with Oracle (1987-1992), and has served as PL/SQL Evangelist for Quest Software since January 2001. He is an Oracle ACE Director and writes regularly for Oracle Magazine, which named him the PL/SQL Developer of the Year in both 2002 and 2006. He is also the first recipient of ODTUG's Lifetime Achievement Award (2009). Since 2005 he has focused his attention on improving the testing of PL/SQL programs, primarily through the creation of Quest Code Tester for Oracle, which automates PL/SQL code testing. Steven's online PL/SQL cyberhome is located at www.ToadWorld.com/SF; but you can also find out more about Steven at http://www.StevenFeuerstein.com.

Customer Reviews

3.9 out of 5 stars
Share your thoughts with other customers

Most Helpful Customer Reviews

20 of 21 people found the following review helpful By Jeff Bernknopf on April 23, 2001
Format: Paperback
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!
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
8 of 9 people found the following review helpful By Philip R. Heath TOP 500 REVIEWERVINE VOICE on March 15, 2003
Format: Paperback
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.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
7 of 8 people found the following review helpful By Allen Taylor on April 1, 2002
Format: Paperback
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.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
5 of 6 people found the following review helpful By Optimus on January 9, 2009
Format: Paperback
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%.
Furthermore referencing an excuses-application only confuses the reader, this is not something you can relate to.
Giving partial code and referring to code on the web is rather annoying.
Moral of the story: keep searching for better practices!
1 Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
7 of 9 people found the following review helpful By Anand Srinivasan on June 19, 2001
Format: Paperback
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 !
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
2 of 2 people found the following review helpful By C. Gill on September 17, 2009
Format: Paperback Verified Purchase
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.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
2 of 2 people found the following review helpful By Edelmiro Fuentes on July 30, 2008
Format: Paperback Verified Purchase
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.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again

Product Images from Customers

Most Recent Customer Reviews

Search
ARRAY(0xa7519fc0)

What Other Items Do Customers Buy After Viewing This Item?