Oracle9i PL/SQL Programming - Brossura

Urman, Scott

Brossura

ISBN 10: 0072191473 ISBN 13: 9780072191479

Casa editrice: McGraw-Hill Education, 2001

Riassunto

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.

Su questo libro

Informazioni sull?autore

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.

Dalla quarta di copertina

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

Dettagli dell?edizione

• Editore: McGraw-Hill Education
• Data di pubblicazione: 2001
• Lingua: Inglese
• ISBN 10: 0072191473
• ISBN 13: 9780072191479
• Rilegatura: Copertina flessibile
• Numero edizione: 2
• Numero di pagine: 656
• Contatto del produttore: non disponibile