Oracle PL/SQL Best Practices
Optimizing Oracle Code
Publisher: O'Reilly Media
Final Release Date: April 2001
Pages: 208

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.
Table of Contents
Product Details
About the Author
Colophon
Recommended for You
Customer Reviews

REVIEW SNAPSHOT®

by PowerReviews
O'Reilly MediaOracle PL/SQL Best Practices
 
4.4

(based on 8 reviews)

Ratings Distribution

  • 5 Stars

     

    (4)

  • 4 Stars

     

    (3)

  • 3 Stars

     

    (1)

  • 2 Stars

     

    (0)

  • 1 Stars

     

    (0)

Reviewed by 8 customers

Sort by

Displaying reviews 1-8

Back to top

(1 of 1 customers found this review helpful)

 
4.0

Excellent books to learn Oracle PL/SQL

By Kelly Blue

from Sydney, Australia

About Me Developer

Pros

  • Accurate
  • Easy to understand

Cons

    Best Uses

    • Expert

    Comments about O'Reilly Media Oracle PL/SQL Best Practices:

    This is a great book to learn oracle.
    I find some useful "www.php-example.com/2011/05/19-basic-tutorial-to-learn-mysql.html" examples which helps me Oracle & MySQL with ready made code.

    Kelly Blue
    University of Technology, Sydney, Australia

    (1 of 1 customers found this review helpful)

     
    3.0

    Excellent Book!

    By Oracletube

    from Austin, Tx

    About Me Developer

    Pros

    • Accurate

    Cons

    • Not comprehensive enough

    Best Uses

    • Intermediate

    Comments about O'Reilly Media Oracle PL/SQL Best Practices:

    Just completed reading this book. A must for Oracle rookies and pro's alike.Thanks,[@]Social networking and knowledge sharing portal for Oracle professionals

    (1 of 1 customers found this review helpful)

     
    5.0

    Oracle PL/SQL Best Practices Review

    By David Laub

    from Undisclosed

    Comments about O'Reilly Media Oracle PL/SQL Best Practices:

    A definitive book.

    One minor complaint, on the topic of (not) always practicing what is preached.

    The example in Chapter 5 which uses dynamic SQL to find the nextval for any sequence parses the query EVERY time in a loop - vs. doing this once prior to the loop.

    Not only does this waste time, but it confuses the issue making it seem like the parse is being done differently every time through the loop.

    (3 of 3 customers found this review helpful)

     
    5.0

    Oracle PL/SQL Best Practices Review

    By Stew Stryker

    from Undisclosed

    Comments about O'Reilly Media Oracle PL/SQL Best Practices:

    Excellent summary of his other books

    Pulls together all those gems scattered throughout his other books. And these really are best-practices. Quick reading, wasting no words, just enough to get the point across so you can put it to work.

    I think Quest Software should include a copy of this book with every Knowledge Xpert license they sell.

    The pull-out card at the back of the book is very handy too.

    If you've read Steven's other books and really want to pull it all together and put some of his suggested methodologies into play, this is the book to help you do it.

     
    5.0

    Oracle PL/SQL Best Practices Review

    By RamPrasad Suswaram

    from Undisclosed

    Comments about O'Reilly Media Oracle PL/SQL Best Practices:

    This is one book which every pl/sql programmer (from a novice to an expert) should posses, and go through its contents once in a while so that he/she can get the best out of pl/sql

    (1 of 1 customers found this review helpful)

     
    5.0

    Oracle PL/SQL Best Practices Review

    By Steve Kahn

    from Undisclosed

    Comments about O'Reilly Media Oracle PL/SQL Best Practices:

    I have worked with Oracle software since 1987, and have amassed a large library of Oracle-related books. Simply stated, Feuerstein's book is the best of them all. In easy-to-read and easy-to-understand language, Steven has created a book that should be on the corner of every PL/SQL developer's desk. Following the precepts in this book will provide the single, most productivity-enhancing tool in the Oracle developer's repetoir.

    Highly recommended!

    (1 of 1 customers found this review helpful)

     
    4.0

    Oracle PL/SQL Best Practices Review

    By John Morelock

    from Undisclosed

    Comments about O'Reilly Media Oracle PL/SQL Best Practices:

    Steven Feuerstein once again shows why his books are in demand. The subject of efficient development within the Oracle framework is presented in a readable, understandable, and reasonable fashion. Where George Carlin reminds us of things we forgot were funny, Feuerstein reminds us of the good practices we were taught and, for whatever reason, have strayed from. In remarkably few words, the reader is presented with clear instructions and a sound explanation.

    The pull-out reference is an added bonus.

    Thank you. J. Morelock

     
    4.0

    Oracle PL/SQL Best Practices Review

    By Fawwad-uz-Zafar Siddiqi

    from Undisclosed

    Comments about O'Reilly Media Oracle PL/SQL Best Practices:

    Even I cannot expect the extra-ordinary interesting book for those who are now novice with the Oracle, I think this is one of the greatest book of Oralce PL/SQL, I think this is the most positive & definite time for this book. Because it will certainly capture the market of PL/SQL.

    I once again recommened this great book by Steven Feueristein.

    And thanks to Steven, to published this book on the right time. Good Going.

    Thank You

    Displaying reviews 1-8

    Back to top

     
    Buy 2 Get 1 Free Free Shipping Guarantee
    Buying Options
    Immediate Access - Go Digital what's this?
    Ebook: $13.99
    Formats:  DAISY, ePub, Mobi, PDF