About this item
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 .
About the Author
Steven Feuerstein is considered to be one of the world's leading experts on the Oracle PL/SQL language, having written ten books on PL/SQL, including Oracle PL/SQL Programming and Oracle PL/SQL Best Practices (all published by O'Reilly Media) . Steven has been developing software since 1980, spent five years with Oracle (1987-1992) , and has served as PL/SQL Evangelist for Quest Software since January 2001. He is an Oracle ACE Director and writes regularly for Oracle Magazine, which named him the PL/SQL Developer of the Year in both 2002 and 2006. He is also the first recipient of ODTUG's Lifetime Achievement Award (2009) . Since 2005 he has focused his attention on improving the testing of PL/SQL programs, primarily through the creation of Quest Code Tester for Oracle, which automates PL/SQL code testing. Steven's online PL/SQL cyberhome is located at www.ToadWorld.com/SF; but you can also find out more about Steven at http://www.StevenFeuerstein.com.
