Oracle PL/SQL Programming

by Steven Feuerstein, Bill Pribyl

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.

Genres: Reference, Programming, Technology, Nonfiction, Software, Science, Technical

1171 pages, Paperback

First published September 8, 1993

Reviews

[Kaushik Nayak · Rating 5 out of 5]

Excellent book for PL/SQL programmers. Each section has abundant examples which cover all the scenarios. Steven feuerstein is a world renowned expert in PL/SQL language and there is no dearth of tips and tools of using the language from the master himself. This book is definitely Steven's greatest.
Along with explaining the features available in the language, it also includes advice on best practices on testing,debugging and improving the code quality. Almost all the essential tools available for a developer in PL/SQL has been clearly explained and demonstrated with examples.

Steven also created a website PL/SQL challenge which is a great platform to practice your coding skills. So, once you complete reading this book my suggestion would be to complete the PL/SQL practice tests in this site : https://plsqlchallenge.oracle.com/

[Phil Branigan · Rating 5 out of 5]

In the days when you needed to read a manual to get something done, these O'Reilly books were essential. They were clearly written with great examples of how coding should be designed, built and tested.

[Nat · Rating 5 out of 5]

If you’re a PL/SQL developer, you need this book.

[Dayton Outar · Rating 4 out of 5]

Pretty good reference material for using with Oracle when creating database solution.

[Krystal · Rating 5 out of 5]

this book is a need

[Geir · Rating 4 out of 5]

I used this to study for the Oracle PL/SQL OCP exam (1Z0-146). Having just passed it, I feel I must recommend it for this purpose. It covers all the exam topics, and goes into further detail on several topics, which I found to be useful for filling out the gaps. It also covers topics from the previous exam (1Z0-144) which I mostly skipped over, having completed that exam earlier. It lacks any control questions after each chapter, which might have been useful.

While somewhat dry in places (unavoidable given the subject material) I found it to be thorough. A good supplement to Oracle's student guide.

[Steve lockwood]

A better question is how much I understood. Enough is the answer. About 30% is actual. I'll come back to this when I need it. I'm praying that SQL becomes all drag and drop which I suppose it moving in this direction anyways, so it's a matter of time.

[Tresuiri · Rating 1 out of 5]

dry, technical, a reference book.

[Clay · Rating 4 out of 5]

Excellent book, if you want to learn PL/SQL.

[عماد المنيف · Rating 5 out of 5]

This a the plsql reference book. It's a must for any plsql programmer, I keep using it for every plsql development.

[Iqbal · Rating 1 out of 5]

sdsada

[Chris · Rating 2 out of 5]

I might call it a reference book but then again I am more likely to google the topic than open this book.

[Delhi Irc]

Location: ND5 IRC
Accession no: DL026831

[Victor Tsvetkov · Rating 5 out of 5]

The best PL/SQL reference

[Mark Wheeler · Rating 3 out of 5]

I'd done PL/SQL before but some time ago, so got this book as a reference for reviewing and understanding PL/SQL code I was working with on a new software system.

[Adderek · Rating 5 out of 5]

Great book - although there is a newer edition.
A must-read for every PL/SQL programmer.

[Sravan · Rating 5 out of 5]

good