Oracle PL/SQL Programming

Introduction to PL/SQL -- Creating and running PL/SQL code -- Language fundamentals -- Conditional and sequential control -- Iterative processing with loops -- Exception handlers -- Working with program data -- Strings -- Numbers -- Dates and timestamps -- Records -- Collections -- Miscellaneous datatypes -- DML and transaction management -- Data retrieval -- Dynamic SQL and dynamic PL/SQL -- Procedures, functions, and parameters -- Packages -- Triggers -- Managing PL/SQL code -- Optimizing PL/SQL performance -- I/O and PL/SQL -- Application security and PL/SQL -- PL/SQL architecture -- Globalization and localization in PL/SQL -- Object-oriented aspects of PL/SQL.;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 indispensab.