Oracle Database 10g: The Complete Reference (Osborne ORACLE Press Series)

Databases

Oracle PL/SQL Programming, 4th Edition

Format: Paperback
Author: Steven Feuerstein
ReleaseDate: 22 August, 2005
Publisher: O'Reilly Media
Rating:

Very good
Feuerstein presents a good overview and in-depth analysis of the PL/SQL language with practical examples. This is an easy to read book. He includes several examples and recommendations that make this a solid book for PL/SQL programmers. Some print errors are commons in books of this type, they are obviously a problem for a newbie, but there is no perfect book at this world. For this reason I give only 4 stars.

.

A major programmer's reference
This isn't just an A-Z coverage: it provides questions, application issue analysis, details on whether usage is appropriate or worth the effort, and how to avoid common coding problems such as hardcoding literals. Steven Feuerstein and Bill Pribyl's ORACLE PL/SQL is a major reference for any already programming: it provides references to syntax, codes, and forms for developers and database administrators, adds new content to extend coverage for the latest Oracle Database 10g Release 2, and adds new chapters covering security encryption, email, and globalization.

THE ULTIMATE PL/SQL PROGRAMMING BOOK!!


Feuerstein and Pribyl, begin with an introduction to the PL/SQL language. Are you an application developer or database administrator? Well, you're in luck! Authors Steven Feuerstein and Bill Pribyl, have done an outstanding job of writing a 4th edition of a book that provides comprehensive useful coverage of the PL/SQL language. Then, they show you how to get PL/SQL programs up and running as quickly as possible. The authors continue by reviewing the fundamentals of the PL/SQL language: what makes a PL/SQL statement, an introduction to the block structure, and how to write comments in PL/SQL. They also explore conditional and sequential control statements, loops, and exception handling in the PL/SQL language. They continue by looking at various types of program data you can define in PL/SQL, such as numbers, strings, records, and collections. In addition, the authors next address one of the most central elements of PL/SQL code construction: the connection to the underlying database, which takes place through the SQL language. They also show you the building blocks of applications, which include procedures, functions, triggers, and packages, and how to move information into and out of PL/SQL programs. Then, the authors explore the security-related challenges you face as you build PL/SQL programs. They continue by exploring the inside of PL/SQL, including PL/SQL's use of memory. In addition, the authors provide guidance for PL/SQL developers who need to address issues of globalization and localization. They also provide an in-depth guide to the object-oriented features of Oracle. Finally, they show you how to invoke Java and C code from your PL/SQL applications.

If you are new to PL/SQL, reading this excellent book from beginning to end should improve your PL/SQL skills and deepen your understanding of the language. Needless to say, if you're already a proficient PL/SQL programmer, you'll probably want to dip into the appropriate sections of this book to extract particular techniques for immediate application.
.