Expert Oracle PL/SQL

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. youll learn how to write dynamic pl/sql programs, interface with oracle databases, execute complex calculations, and handle error conditions using advanced techniques. plus, youll 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 definers-rights and invokers-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 definers-rights and invokers-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