REVIEW - Oracle PL/SQL Programming


Title:

Oracle PL/SQL Programming

Author:

Steven Feuerstein, Bill Pribyl

Publisher:

O'Reilly (1997)

Pages:

989pp

Reviewer:

Michael Minihane

Reviewed:

April 2000

Rating:

★★★☆☆


It's my first choice for answering PL/SQL questions and certainly much more useful than the Oracle supplied documentation.

PL/SQL is Oracle's procedural language extension to SQL, for use in those cases where SQL functionality on its own isn't sufficient. Ubiquitous across the various Oracle products, PLSQL has seen many different versions and supports development both server-side in the database and client-side in application code.

The book starts with an overview of the different versions available and then throughout, when features are introduced, it's made clear if there are restrictions for use across versions. This works well, as the progression is from fundamentals to advanced features and as you would expect the Oracle 8 features are dealt with towards the end.

The author takes the trouble early on to discuss coding style in general and the reasoning behind his personal style, before the detailed discussion of language features. The examples used in the book are useful and the comments on approach show real experience. This evidence of living in the real world is added to in the later stages of the book with sections on design, debugging and tuning.

The book is suitable for use both as a learning aid and as a reference. It's my first choice for answering PL/SQL questions and certainly much more useful than the Oracle supplied documentation.


Book cover image courtesy of Open Library.





Your Privacy

By clicking "Accept All Cookies" you agree ACCU can store cookies on your device and disclose information in accordance with our Privacy Policy and Cookie Policy.

By clicking "Share IP Address" you agree ACCU can forward your IP address to third-party sites to enhance the information presented on the site, and that these sites may store cookies on your device.