Oracle PL/SQL Programming

Oracle PL/SQL Programming

<DIV><p>This book is the definitive reference on PL/SQL, considered throughout the database community to be the best Oracle programming book available. Like its predecessors, this fifth edition of <I>Oracle PL/SQL Programming</I> covers language fundamentals, advanced coding techniques, and best practices for using Oracle's powerful procedural language. Thoroughly updated for Oracle Database 11g Release 2, this edition reveals new PL/SQL features and provides extensive code samples, ranging from simple examples to complex and complete applications, in the book and on the companion website.<br><br> This indispensable reference for both novices and experienced Oracle programmers will help you:</p><p></p><ul><li>Get PL/SQL programs up and running quickly, with clear instructions for executing, tracing, testing, debugging, and managing PL/SQL code </li><li>Optimize PL/SQL performance with the aid of a brand-new chapter in the fifth edition</li> <li>Explore datatypes, conditional and sequential control statements, loops, exception handling, security features, globalization and localization issues, and the PL/SQL architecture</li> <li>Understand and use new Oracle Database 11g features, including the edition-based redefinition capability, the function result cache, the new CONTINUE statement, fine-grained dependency tracking, sequences in PL/SQL expressions, supertype invocation from subtypes, and enhancements to native compilation, triggers, and dynamic SQL</li> <li>Use new Oracle Database 11g tools and techniques such as PL/Scope, the PL/SQL hierarchical profiler, and the SecureFiles technology for large objects</li> <li>Build modular PL/SQL applications using procedures, functions, triggers, and packages</li></ul></div>