Oracle8i Advanced PL/SQL Programming - Softcover

Urman, Scott

Softcover

ISBN 10: 0072121467 ISBN 13: 9780072121469

Publisher: McGraw-Hill Osborne Media, 2000

Synopsis

Develop robust, Web-enabled PL/SQL applications using the in-depth information offered in this Oracle-approved guide.

About this title

About the Author

Scott Urman (Foster City, CA) is a Senior Member of the Technical Staff in the Diagnostic and Defect Resolution team in Oracle's Server Technologies Division. He is primarily responsible for fixing defects in Oracle's JDBC drivers, as well as in PL/SQL. Through his support experience, he is familiar with all of Oracle's language products (PL/SQL, OCI, the Oracle Precompilers, and JDBC). In addition, he reviews Oracle technical documentation, writes white papers on Oracle languages, and makes technical presentations both inside Oracle and at meetings of Oracle User's Groups. Scott is the best-selling author of Oracle Press' "Oracle8 PL/SQL Programming," "Oracle PL/SQL Programming," and "Oracle8i Advanced PL/SQL Programming."

From the Back Cover

Take Full Advantage of Oracle8i Built-In PL/SQL Features

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 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 increased package body size

• Schedule PL/SL 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

Edition details

• Publisher: McGraw-Hill Osborne Media
• Publication date: 2000
• Language: English
• ISBN 10: 0072121467
• ISBN 13: 9780072121469
• Binding: Paperback
• Number of pages: 772