Oracle PL/SQL Programming (Animal Guide)
Books / Paperback
Books › Computers › Programming Languages › SQL
ISBN: 0596514468 / Publisher: O'Reilly Media, October 2009
The definitive reference on PL/SQL rolls into its fifth edition, updated to include versions through Oracle Database 11g release 2. Material in the book ranges from the fundamentals of the Oracle language to advanced coding techniques and best practices. The book also discusses new PL/SQL features and provides extensive code samples (some of which are on the book's companion website). This is an ideal reference for both novice users and experienced programmers. Annotation ©2010 Book News, Inc., Portland, OR (booknews.com)
Read More
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 Oracle PL/SQL Programming 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.This indispensable reference for both novices and experienced Oracle programmers will help you:Get PL/SQL programs up and running quickly, with clear instructions for executing, tracing, testing, debugging, and managing PL/SQL codeOptimize PL/SQL performance with the aid of a brand-new chapter in the fifth editionExplore datatypes, conditional and sequential control statements, loops, exception handling, security features, globalization and localization issues, and the PL/SQL architectureUnderstand 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 SQLUse new Oracle Database 11g tools and techniques such as PL/Scope, the PL/SQL hierarchical profiler, and the SecureFiles technology for large objectsBuild modular PL/SQL applications using procedures, functions, triggers, and packages
Read Less