SQL, Oracle (Database Management System), SQL (Programming Language)

Oracle9i PL/SQL Programming (Osborne Oracle Press Series)

Name: Oracle9i PL/SQL Programming (Osborne Oracle Press Series)
Author: Scott Urman
ISBN: 9780072191479

by Scott Urman

Write a review

Overview

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. You'll learn to develop, test, and debug your PL/SQL applications and work in different development environments. You'll 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

About the Author, Scott Urman

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.