| Introduction |
Guaranteed best-seller--previous editions of this book have sold over 140,000 copies New information on development tools, datatypes, SQL commands and functions, and much more Icons throughout indicate material for Oracle8i and Oracle9i CD-ROM contains sample code plus a sampling of PL/SQL development environments covered in the book |
| About the book |
From the authorized Oracle Press comes a complete guide to developing robust PL/SQL applications. The book contains new information on development tools, datatypes, SQL commands and functions, and much more. The CD-ROM contains sample code plus a sampling of development environments covered in the book. |
| About the authors |
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. |
| Table of contents |
Introduction and Development Environments Introduction PL/SQL Development and Execution Environments Basic PL/SQL Features PL/SQL Basics SQL within PL/SQL Built in SQL Functions Cursors Error Handling Collections More PL/SQL Features Creating Subprograms and Packages Using Subprograms and Packages Database Triggers New 9i and Advanced Features Appendixes Guide to Supplied Packages PL/SQL Reserved Words The Data Dictionary |



