Oracle8i Advanced PL/SQL Programming - Softcover

Urman, Scott

Softcover

ISBN 10: 0072121467 ISBN 13: 9780072121469

Publisher: McGraw-Hill Education, 2000

Synopsis

PL/SQL (Procedural Language/SQL) is a sophisticated programming language used to access Oracle databases from various platforms. This in-depth guide provides information which will enable the reader to develop robust, Web-enabled PL/SQL applications. It includes full coverage of packages, triggers, dynamic SQL, external routines, objects, and collections with a 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 covered. The CD includes trial versions of five PL/SQL development environments, which include debugging techniques.

About this title

About the Author

Scott Urman (Foster City, CA) is a senior member of the diagnostic and defect technical staff in the Language Group of Oracle Support Services, where he aids users of Oracle's various language products (PL/SQL, OCI, and the Oracle precompilers). 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' Oracle PL/SQL Programming and Oracle8 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 Education
• Publication date: 2000
• Language: English
• ISBN 10: 0072121467
• ISBN 13: 9780072121469
• Binding: Paperback
• Number of pages: 812