Oracle 8I Advanced Pl/SQL Programming

by Urman, Scott

• ISBN13: 9780072121469
• ISBN10: 0072121467
• Format: Paperback
• Copyright: 2000-05-01
• Publisher: McGraw-Hill Osborne Media

Summary

Experienced system administrators, database administrators and application designers will find hands-on information needed to use PL/SQL to its fullest potential. Special elements include Oracle8i coverage, explanations on how to use examples for real-world applications, and a CD-ROM containing the script samples covered as well as Oracle and third-part tools such as Oracle Procedure Builder and SQL-Station.

Table of Contents

PART I Introduction and Development Environments
Introduction	3	(26)
PL/SQL Development and Execution Environments	29	(34)
Tracing and Debugging	63	(92)
PART II Non-Object Features
Creating Subprograms and Packages	155	(44)
Using Subprograms and Packages	199	(60)
Database Triggers	259	(46)
Database Jobs and File I/O	305	(38)
Dynamic SQL	343	(122)
Intersession Communication	465	(1)
External Routines	465	(106)
Additional Oracle8i Features	571	(42)
PART III Object Features and LOBs
Introduction to Objects	613	(42)
Objects in the Database	655	(34)
Collections	689	(46)
On the CD-ROM
Large Objects
Advanced LOB Topics and DBMS_LOB
A Guide to Supplied Packages
B PL/SQL Reserved Words
C The Data Dictionary
Index	735	(42)
About the CD-ROM	777