Oracle PL/SQL Programming

More about the book

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.