The essential reference for PL/SQL has been revised and expanded, featuring all new examples throughout based on the new Oracle Database 10g sample schema plus a CD with all the book’s code as well as development environments. Written by a senior member of the technical staff on the Diagnostics and Defect Resolution (DDR) team in Oracle’s Server Technologies Division.

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product. Create and debug next-generation, feature-rich PL/SQL applications Push your PL/SQL programming skills to the next level with the extensive information contained in this volume. You'll learn how to write dynamic PL/SQL programs, interface with Oracle databases, execute complex calculations, and handle error conditions using advanced techniques. Plus, you'll get the latest on the PL/SQL Toolkit, Java integration, code threading, and performance optimizing. Oracle professionals Ron Hardman and Michael McLaughlin cover all the bases, providing real-world examples, undocumented tricks, syntax samples, and unique solutions for every topic. Compile high performance PL/SQL scripts using procedures, functions, packages and triggers Trap, trace, identify, and eliminate compile-time and runtime errors Manage error propagation, stacks, regular expressions, and metacharacters Exploit definer's-rights and invoker's-rights architectures Extend PL/SQL functionality using server-side and internal Java class libraries Build and run parallel PL/SQL program units using DBMS_JOB and DBMS_PIPE Exploit definer's-rights and invoker's-rights architectures Tune performance using statistics gathering, the PL/SQL optimizer, SQL Trace, DBMS_STATS, and TKPROF Use Oracle Text with PL/SQL Server Pages to perform theme/gist extraction, highlighting, stemming, fuzzy, and wildcard searching Administer server-side PL/SQL Toolkit web pages and PL/SQL Server Pages Secure, encrypt, and transmit data using DBMS_CRYPTO, UTL_COMPRESS, DBMS_DATAPUMP, and DBMS_FILE_TRANSFER