(Larger Image)
|
Oracle PL/SQL Best Practices
by Steven Feuerstein
Product Group: Book
Publisher: O'Reilly Media, Inc. (2001-04-15)
ISBN: 0596001215
EAN: 9780596001216
Dewy Decimal #: 005
Paperback: 204 pages
Edition: 1st
SKU: N1115
Condition: Good
|
Editorial Reviews
|
Product Description
In this book, Steven Feuerstein, widely recognized as one of the world's experts on the Oracle PL/SQL language, distills his many years of programming, writing, and teaching about PL/SQL into a set of PL/SQL language "best practices"--rules for writing code that is readable, maintainable, and efficient. Too often, developers focus on simply writing programs that run without errors--and ignore the impact of poorly written code upon both system performance and their ability (and their colleagues' ability) to maintain that code over time. Oracle PL/SQL Best Practices is a concise, easy-to-use reference to Feuerstein's recommendations for excellent PL/SQL coding. It answers the kinds of questions PL/SQL developers most frequently ask about their code: - How should I format my code?
- What naming conventions, if any, should I use?
- How can I write my packages so they can be more easily maintained?
- What is the most efficient way to query information from the database?
- How can I get all the developers on my team to handle errors the same way?
The book contains 120 best practices, divided by topic area. It's full of advice on the program development process, coding style, writing SQL in PL/SQL, data structures, control structures, exception handling, program and package construction, and built-in packages. It also contains a handy, pull-out quick reference card. As a helpful supplement to the text, code examples demonstrating each of the best practices are available on the O'Reilly web site. Oracle PL/SQL Best Practices is intended as a companion to O'Reilly's larger Oracle PL/SQL books. It's a compact, readable reference that you'll turn to again and again--a book that no serious developer can afford to be without.
|
Customer Reviews
|
Just a note
Rating  (5)
Date: 2008-09-03
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
Rating (5)
Date: 2008-07-30
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.
|
|
A set of 'best practices' for developing applications
Rating (5)
Date: 2008-02-07
0 out of 1 customers found this reveiw helpful
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 developing applications. The latest release of Oracle is covered in chapters which cover nine categories in chapters which are quick and easy to consult, arranged in a problem/solution format to reflect real-world programming examples and challenges.
|
|
A Handy Reference For Intermediate PL/SQL Programmers.
Rating  (4)
Date: 2003-03-15
5 out of 6 customers found this reveiw helpful
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.
|
|
Required Reading
Rating (5)
Date: 2002-10-28
2 out of 4 customers found this reveiw helpful
Simply put, this book should be required reading for anyone who considers themselves a professional PL/SQL developer. It is full of pearls and gems, and succinctly presents many, many programming proverbs that must be followed if developing in 0racle
|
|
|