Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.


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

Subscriber Reviews

Average Rating: 4.666666666666667 out of 5 rating Based on 9 Ratings

"Excellent Book" - by margotk on 01-MAR-2012
Reviewer Rating: 1 star rating2 star rating3 star rating4 star rating5 star rating
As one expects from Feuerstein, this is an informative and indispensable text with excellent coverage of the features of Oracle PL/SQL. The book includes useful examples and canvases 'gotchas' that might otherwise be time-consuming traps for the uninitiated. I found the style and structure of the book very comprehensible.
Report as Inappropriate

"great overview" - by kaspencer on 03-NOV-2011
Reviewer Rating: 1 star rating2 star rating3 star rating4 star rating5 star rating
I didn't know much of anything about PL/SQL. I had a job interview coming up that required me to know something about PL/SQL. I skimmed the first few chapters of this book the night before the interview and I got the job.
Report as Inappropriate

"Highly recommended." - by Anonymous on 21-DEC-2010
Reviewer Rating: 1 star rating2 star rating3 star rating4 star rating5 star rating
I ought to provide a detailed review. However, given time constraints I shall keep it short. For an individual who considers PL/SQL to be his weakness, I found the book to be very well organized. Highly recommend the book to individuals who do not have experience programming with PL/SQL and are taking their first steps.
Report as Inappropriate

Table of Contents



The publisher has provided additional content related to this title.


Visit the catalog page for Oracle PL/SQL Programming, 5th Edition

  • Catalog Page

Visit the errata page for Oracle PL/SQL Programming, 5th Edition

  • Errata

Download the supplemental electronic content for Oracle PL/SQL Programming, 5th Edition

  • Supplemental Content