Oracle8i Advanced PL/SQL Programming

Develop robust, Web-enabled PL/SQL applications using the in-depth information offered in this Oracle-approved guide. You’ll get full coverage of packages, triggers, dynamic SQL, external routines, objects, and collections—with specific focus on all of the new Oracle8i features and commonly used built-in packages. Strategies for tuning, tracing, and debugging PL/SQL programs are also presented. The CD includes trial versions of five PL/SQL development environments, which include debugging techniques.
*Work effectively in Oracle8i’s PL/SQL development and execution environments.
*Trace and debug PL/SQL applications using DBMS_DEBUG and DBMS_TRACE, as well as third-party tools.
*Take advantage of Oracle8i’s increased package body size.
*Schedule PL/SQL jobs to run automatically at specified times with DBMS_JOB.
*Use the UTE_FILE package to allow PL/SQL to read from and write to operating system files.
*Use native dynamic SQL to create and execute SQL and PL/SQL statements at runtime.
*Enable intersession communication with database pipes and database alerts.
*Write external routines with Pro*C and embedded SQL.
*Use object types and methods effectively, including Oracle8i enhancements to them.
Manipulate large objects (LOBs) with the DBMS-LOB package.