Oracle9i PL/SQL Programming

Book Description
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.

Book Info
A complete guide to developing robust PL/SQL applications. Contains new information on development tools, datatypes, SQL commands and functions, and much more. Softcover. CD-ROM included.

From the Back Cover

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

FROM THE PUBLISHER

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.

SYNOPSIS

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