Oracle PL/SQL Programming, 4th Edition
Publisher: O'Reilly Media
Released: August 2005
Pages: 1200

For the past ten years, O'Reilly's Oracle PL/SQL Programming has been the bestselling book on PL/SQL, Oracle's powerful procedural language. Packed with examples and helpful recommendations, the book has helped everyone--from novices to experienced developers, and from Oracle Forms developers to database administrators--make the most of PL/SQL.

The fourth edition is a comprehensive update, adding significant new content and extending coverage to include the very latest Oracle version, Oracle Database 10g Release 2. It describes such new features as the PL/SQL optimizing compiler, conditional compilation, compile-time warnings, regular expressions, set operators for nested tables, nonsequential collections in FORALL, the programmer-defined quoting mechanism, the ability to backtrace an exception to a line number, a variety of new built-in packages, and support for IEEE 754 compliant floating-point numbers.

The new edition adds brand-new chapters on security (including encryption, row-level security, fine-grained auditing, and application contexts), file, email, and web I/O (including the built-in packages DBMS_OUTPUT, UTL_FILE, UTL_MAIL, UTL_SMTP, and UTL_HTTP) and globalization and localization.

Co-authored by the world's foremost PL/SQL authority, Steven Feuerstein, this classic reference provides language syntax, best practices, and extensive code, ranging from simple examples to complete applications--making it a must-have on your road to PL/SQL mastery. A companion web site contains many more examples and additional technical content for enhanced learning.

Table of Contents
Product Details
About the Author
Colophon
Recommended for You
Customer Reviews

REVIEW SNAPSHOT®

by PowerReviews
oreillyOracle PL/SQL Programming, 4th Edition
 
5.0

(based on 5 reviews)

Ratings Distribution

  • 5 Stars

     

    (5)

  • 4 Stars

     

    (0)

  • 3 Stars

     

    (0)

  • 2 Stars

     

    (0)

  • 1 Stars

     

    (0)

Reviewed by 5 customers

Sort by

Displaying reviews 1-5

Back to top

 
5.0

Great source of PL/SQL knowledge

By Kubik

from Warsaw, Poland

About Me Designer, Developer

Verified Reviewer

Pros

  • Easy to understand
  • Helpful examples
  • Well-written

Cons

    Best Uses

    • Intermediate
    • Student

    Comments about oreilly Oracle PL/SQL Programming, 4th Edition:

    I have used the book to prepare to my OCA PL/SQL Developer exams and I have to say, that it is the best book about PL/SQL Programming I've ever read. It's really well-written and you read it almost like a crime story. It describes every aspect of language and is detailed, but not boring.
    The only problem is it's weight.

     
    5.0

    eBook worth its weight in gold too

    By Klondike Mike

    from Yukon

    About Me Designer, Developer

    Pros

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

    Cons

      Best Uses

      • Intermediate
      • Novice
      • Student

      Comments about oreilly Oracle PL/SQL Programming, 4th Edition:

      I downloaded O'Reilly's electronic version of this book, and I have to add the eBook version is also worth it's weight in gold.

      Not only is the information in this book incredibly useful to any Oracle developer, but the eBook version adds extra usefulness and portability on a Laptop or mobile device that makes it something you can have on hand at all times.

      So once again... the eBook version? Literally worth its weight in pure gold. In fact, they should have called it Aurical PL/SQL Programming.

      (1 of 1 customers found this review helpful)

       
      5.0

      This book is worth its weight in gold

      By Amit

      from Undisclosed

      Comments about oreilly Oracle PL/SQL Programming, 4th Edition:

      I have developed an application or two using PL/SQL (even used Oracle forms & Reports) but I learnt PL/SQL on the go by googling; never found the time to sit down and learn it from the scratch-from the very basics.

      I was hoping that this book will add some basic and some advanced stuff to my knowledge *very quickly*; that was where I went wrong-it took quite some time and effort to finish it.

      Pluses:

      This book is worth its weight in gold; very clear very concise; lots of explanations and lots of code. An ideal companion for quick referencing while you are coding in PL/SQL. I had to spend a long time on the net once to understand how I/O and web based data is handled; I wish I had this book with me at that time.

      Minuses:

      This book is certainly not for beginners. At 1170 pages it’d mean a lot of information for somebody who has just started learning. There are some (actually a lot!) printing errors, even in the code that need to be taken care of.

      Overall a great reference book from the God of PL/SQL.

      (1 of 1 customers found this review helpful)

       
      5.0

      One To Own

      By Anonymous

      from Undisclosed

      Comments about oreilly Oracle PL/SQL Programming, 4th Edition:

      This is an excellent book that I constantly used. This is well written with easy to follow examples. If you haven't bought this book then I recommend you buy this one.

      (1 of 1 customers found this review helpful)

       
      5.0

      Waoooooh !!!!

      By denis.flotat

      from Undisclosed

      Comments about oreilly Oracle PL/SQL Programming, 4th Edition:

      It is not so often when i can read a book that is really useful in my every-developer-day.

      For PL/SQL programmers it is really the 'MUST HAVE' book.

      Every chapter is really full of useful informations and tips on the Oracle 10gR2.

      It gives me a real new interest in going deeper into efficient PL/SQL development (a sincere thank you to S.Feuerstein for this major book).

      Reading that book, i have also discovered other very useful tools (like Ounit and utPLSQL) developped by the author.

      Until now, i was mainly focused on ORACLE PRESS BOOKS (considering that they were supposed to always be the best to provide useful informations to Oracle developpers).

      Unfortunalely i discovered that most of the money i spent into Oracle Press books was not so profitable (the lastest Oracle PL/SQL 10g is a real shame compared to this book).

      => I had to spent lot of time trying to find solutions or simply practical explanation on Internet.

      If i had only one remark to the author of the 'Oracle PL/SQL Programming' release 4, it would deal with the miss of a chapter for programming PLSQL/XML (as it is supposed to be the most useful format these days !!!) => i have not found a very practical book on that subject.

      Displaying reviews 1-5

      Back to top

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