Bill Pribyl Book order (chronological)

The authors have revised and updated this bestseller to include both the Oracle8i and new Oracle9i Internet-savvy database products.

This book serves as the definitive reference on PL/SQL, widely regarded as the premier Oracle programming guide. The fifth edition thoroughly updates language fundamentals, advanced coding techniques, and best practices for Oracle's procedural language, specifically tailored for Oracle Database 11g Release 2. It introduces new PL/SQL features and offers extensive code samples, from simple to complex applications, both in the book and on the companion website. This essential resource aids both novices and experienced Oracle programmers in quickly setting up PL/SQL programs, with clear instructions for executing, tracing, testing, debugging, and managing code. It includes a new chapter focused on optimizing PL/SQL performance and covers various topics such as datatypes, control statements, loops, exception handling, security, and PL/SQL architecture. Additionally, it explores new features of Oracle Database 11g, including edition-based redefinition, function result caching, the CONTINUE statement, fine-grained dependency tracking, and enhancements to native compilation, triggers, and dynamic SQL. The book also introduces new tools and techniques like PL/Scope, the PL/SQL hierarchical profiler, and SecureFiles technology for large objects, and guides readers in building modular PL/SQL applications using procedures, functions, triggers, and packages.

The latest edition of this classic reference has been updated to cover Oracle Database 10g. Among the Oracle 10g features examined include regular expression support, native compilation, and new datatypes. The book also includes discussions on language syntax, how to build real applications, and how to apply best practices. Written by the world's foremost PL/SQL authority, Steven Feuerstein.