Chinese
French
German
Italian
Japanese
Korean
Russian
Spanish
Product Details
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
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.
- Paperback: 664 pages
- Publisher: McGraw-Hill Osborne Media; 2 edition (November 28, 2001)
- Language: English
- ISBN-10: 0072191473
- ISBN-13: 978-0072191479
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
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.
For more free books download visit this blog daily
If you enjoyed this post, make sure you 