Oracle PL/SQL programming [text] /
Steven Feuerstein with Bill Pribyl.
- sixth edition.
- Sebastopol, Calif. : O'Reilly, 2014.
- xxxviii, 1340 pages : illustrations.
"Covers versions through Oracle database 12c."--PDF cover. Includes index.
Programming in 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 -- Calling Java from PL/SQL -- External procedures.