Oracle9i Programação Pl/Sq Ldesenvolva Aplicativos Pl/Sql Poderosos

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. 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, Oracle9 i 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 Oracle9 i 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 DevelopmentEnvironments from the Book