Oracle PL/SQL Programming, 5th Edition
Covers Versions Through Oracle Database 11g Release 2
Publisher: O'Reilly Media
Released: September 2009
Pages: 1232

This book is the definitive reference on PL/SQL, considered throughout the database community to be the best Oracle programming book available. Like its predecessors, this fifth edition of Oracle PL/SQL Programming covers language fundamentals, advanced coding techniques, and best practices for using Oracle's powerful procedural language. Thoroughly updated for Oracle Database 11g Release 2, this edition reveals new PL/SQL features and provides extensive code samples, ranging from simple examples to complex and complete applications, in the book and on the companion website.

This indispensable reference for both novices and experienced Oracle programmers will help you:

  • Get PL/SQL programs up and running quickly, with clear instructions for executing, tracing, testing, debugging, and managing PL/SQL code
  • Optimize PL/SQL performance with the aid of a brand-new chapter in the fifth edition
  • Explore datatypes, conditional and sequential control statements, loops, exception handling, security features, globalization and localization issues, and the PL/SQL architecture
  • Understand and use new Oracle Database 11g features, including the edition-based redefinition capability, the function result cache, the new CONTINUE statement, fine-grained dependency tracking, sequences in PL/SQL expressions, supertype invocation from subtypes, and enhancements to native compilation, triggers, and dynamic SQL
  • Use new Oracle Database 11g tools and techniques such as PL/Scope, the PL/SQL hierarchical profiler, and the SecureFiles technology for large objects
  • Build modular PL/SQL applications using procedures, functions, triggers, and packages
Table of Contents
Product Details
About the Author
Colophon
Recommended for You
Customer Reviews

REVIEW SNAPSHOT®

by PowerReviews
O'Reilly MediaOracle PL/SQL Programming, 5th Edition
 
4.4

(based on 5 reviews)

Ratings Distribution

  • 5 Stars

     

    (2)

  • 4 Stars

     

    (3)

  • 3 Stars

     

    (0)

  • 2 Stars

     

    (0)

  • 1 Stars

     

    (0)

100%

of respondents would recommend this to a friend.

Pros

  • Easy to understand (4)
  • Helpful examples (4)
  • Well-written (4)
  • Accurate (3)
  • Concise (3)

Cons

    Best Uses

    • Intermediate (5)
    • Novice (4)
    • Student (4)
    • Expert (3)
      • Reviewer Profile:
      • Developer (5)

    Reviewed by 5 customers

    Sort by

    Displaying reviews 1-5

    Back to top

    (2 of 3 customers found this review helpful)

     
    4.0

    Excellent Book. XML a Little Brief

    By Fred

    from Baltimore

    About Me Developer

    Pros

    • Accurate
    • Concise
    • Easy to understand
    • Helpful examples
    • Well-written

    Cons

      Best Uses

      • Expert
      • Intermediate

      Comments about O'Reilly Media Oracle PL/SQL Programming, 5th Edition:

      I was eager to have the 5th edition, providing coverage through Oracle Database 11g Release 2. I have learned a lot from the previous editions of this book.

      I quickly went to the XML discussion on page 426. I was hoping for a deeper discussion of XMLType. I was glad to see that the deprecated extractvalue function wasn't used in the example.

      (6 of 6 customers found this review helpful)

       
      5.0

      Good tutorial and prep for Oracle exams

      By John

      from Ireland

      About Me Designer, Developer

      Verified Reviewer

      Pros

      • Easy to understand
      • Oracle exam prep
      • Tutorial

      Cons

      • Long winded at times

      Best Uses

      • Expert
      • Intermediate
      • Novice
      • Student

      Comments about O'Reilly Media Oracle PL/SQL Programming, 5th Edition:

      Oh, yes, five stars.

      It's main strength is as a tutorial. If you are completely ignorant about a particular area of PL/SQL, this book will bring you up to speed painlessly. Or you can skim it to refresh an area that you have not used for a while.

      It complements the Oracle reference material very well and explains "why" as well as "how".

      The main author, Steven Feurerstein, is particularly keen to demonstrate how to build code that is easy to maintain. He continually emphasises the advantages of good programming practice over "quick and dirty" solutions, which still plague the IT industry.

      This is a great book to prepare for the Oracle PL/SQL certification exam 1Z0-144 (Program with PL/SQL). It will over-prepare you so that you can nail it. Steven's code style fits in with the code examples that you will see in the Oracle exam, so you will feel well at home there. His philosophy about "what are the advantages of so-and-so", which can be debatable, also fit in with what you will be asked in the exam.

      This book also covers the bulk of the subjects for the Oracle 1Z0-146 Exam (Advanced PL/SQL). However, two key chapters for this exam are not actually in the book. You can register your book to see the extra chapters on the web. They are Chapter 27 (Calling Java from PL/SQL) and Chapter 28 (External Procedures).

      On the down-side, it is a long book, sometimes needlessly so. For instance the chapter on Collections seemed to duplicate itself a lot. Perhaps it suffers from being added-to for new releases of Oracle rather than being re-written. A bit like what happens to our PL/SQL code over time.

      (5 of 5 customers found this review helpful)

       
      4.0

      Thank for very usefull book.

      By Martin

      from Montreal, Qc,Canada

      About Me Developer

      Verified Reviewer

      Pros

      • Concise
      • Easy to understand
      • Helpful examples
      • Well-written

      Cons

      • Big book

      Best Uses

      • Intermediate
      • Novice
      • Student

      Comments about O'Reilly Media Oracle PL/SQL Programming, 5th Edition:

      This is well done written book with many comprehensive example and you could use extra stuff if you want to dig more in an subject on web site.

      - It is a good reference.
      - It give a good idea of new feature on latest release.(11g/10g)
      - If you remember and use all this technique you will be a good programmer.

      There are few small mistakes that should not lost the reader. I tried to point then in Errata section of this web site to have a better 6th edition and may be a better electronic revision.

      For Expert: That could remember think we not use often because of the need.

      Thank, to have increased my skill.

      (7 of 7 customers found this review helpful)

       
      4.0

      Recommended book for all developers

      By Ramin Orujov

      from Baku, Azerbaijan

      About Me Developer

      Verified Reviewer

      Pros

      • Accurate
      • Concise
      • Easy to understand
      • Helpful examples
      • Well-written

      Cons

        Best Uses

        • Intermediate
        • Novice
        • Student

        Comments about O'Reilly Media Oracle PL/SQL Programming, 5th Edition:

        I really enjoyed reading this book! It is my main PL/SQL references. I learned good techniques and i already apply that knowledge at work.
        I recommend this book especially to beginner and intermediate PL/SQL developers. But experts also can refresh their knowledge and also learn some new features in Oracle 11g PL/SQL.
        I've already passed 1Z0-144 Oracle 11g PL/SQL certification exam using this book, now again using this book as a preparation guide to Oracle OCP 1Z0-146 PL/SQL certificatione exam.

        (13 of 13 customers found this review helpful)

         
        5.0

        Very Comprehensive, Solid Best Practices

        By jdruin

        from KY

        About Me Developer

        Verified Reviewer

        Pros

        • Accurate
        • Helpful examples
        • Well-written

        Cons

          Best Uses

          • Expert
          • Intermediate
          • Novice
          • Student

          Comments about O'Reilly Media Oracle PL/SQL Programming, 5th Edition:

          This could be the most comprehensive single volume on PL/SQL available. The coverage of topics is excellent.

          When programming in Oracle, it is great to have a single book to turn to when you need help, and the reader can be confident that good practice will be followed. (One of the authors is also the author of "Oracle PL/SQL Best Practices). The book is well organized grouping like topics together, providing lots of examples, providing source code, and links/listings to other resources.

          In general, topics covered include the programming environment, control flow, data types, embedding SQL inside PL/SQL, advanced topics, and references.

          One compliant would be the ordering of topics in the chapter showing variable binding. The chapter starts out showing non-bound variables (with examples) then later in the chapter shows a better way using bind variables. The problem with this approach is those learning for the first time will get their program going and are reluctant to change once it works. I would much rather see bind variables and security topics presenting with the best way first, then fall back on the less desirable methods in a section that covers "What to do when the best way does not work".

          Highly recommended for Oracle programmers and students learning Oracle and/or PL/SQL.

          Side note: PL/SQL Best Practices is a good companion to this book.

          Displaying reviews 1-5

          Back to top

           
          Buy 2 Get 1 Free Free Shipping Guarantee
          Buying Options
          Immediate Access - Go Digital what's this?