Oracle9i PL/SQL Programming, 2/e

Maximize Built-In PL/SQL Features

Create robust PL/SQL programs to access an Oracle database from a variety of environments. Officially authorized by Oracle Corporation, Oracle9i PL/SQL Programming explains the major features of the language and the variances in PL/SQL between different database versions. Youll learn to develop, test, and debug your PL/SQL applications and work in different development environments. Youll also get specifics on SQL and PL/SQL usage, error handling, collections, subprograms and packages, and advanced features.

• Work in various PL/SQL development and execution environments, demo versions of which are included on the CD-ROM
  
• Get details on PL/SQL syntax, variables, datatypes, expressions, operators, and control structures
  
• Ensure data consistency using SQL transaction-control statements
  
• Use cursors for multirow queries and explicit control of SQL statement processing
  
• Write PL/SQL programs that detect and react intelligently to runtime errors
  
• Take advantage of the multi level collection capabilities of Oracle9i
  
• Create and use procedures, functions, and packages
  
• Develop DML, instead-of, and system triggers to enforce complex data constraints
  
• Exploit advanced PL/SQL features, including external routines, native dynamic SQL, bulk binds, and object types
  

CD-ROM Contains Sample Code and Development Environments from the Book

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