Oracle8i Advanced PL/SQL Programming

3.67 avg rating
( 3 ratings by Goodreads )
 
9780072121469: Oracle8i Advanced PL/SQL Programming

PL/SQL is a sophisticated programming language used to access an Oracle database from various environments. This text is a user's guide to the advanced features of PL/SQL, covering the full range of functionality. The CD-ROM contains script samples, as well as Oracle and third party tools.

"synopsis" may belong to another edition of this title.

Review:

This latest edition of Scott Urman's definitive guide to PL/SQL programming under Oracle databases, Oracle8i Advanced PL/SQL Programming, takes into account the new features of the language under Oracle 8i. Urman cut out some of the introductory PL/SQL material that appears in his earlier Oracle works, letting him focus more fully on higher-level aspects of the language and advanced techniques for putting them to use. Still, quite a bit of introductory material--including information on PL/SQL development environments--appears here, so don't be afraid to dive into Oracle 8i PL/SQL with this book if you can afford to buy only one guide.

Urman follows the classic didactic strategy of explaining a concept in general terms, introducing code that implements that concept, and then commenting on the code and presenting variations on it. The result is an effective tutorial and a moderately complete reference to approximate solutions for on-the-job problems. You'll also find a fair bit of straight-language reference material in these pages, typically in the form of an operator or clause followed by a bit of commentary on its appropriate use. The index includes all mentions of clauses and other language elements, so it's the best place to look for references to specific elements of the language. Stick with a straight-through read if you're out to learn PL/SQL for the first time. --David Wall

Topics covered: The PL/SQL programming language, particularly as implemented under Oracle 8i. The book touches on the non-object aspects of PL/SQL and its object model, and explains how to implement database triggers, file I/O operations, and communications among database sessions. Large Objects (LOBs) are also discussed.

From the Back Cover:

Take Full Advantage of Oracle8i Built-In PL/SQL Features

Develop robust, Web-enabled PL/SQL applications using the in-depth information offered in this Oracle-approved guide. You'll get full coverage of packages, triggers, dynamic SQL, external routines, objects, and collections--with specific focus on all of the new Oracle8i features and commonly used built-in packages. Strategies for tuning, tracing, and debugging PL/SQL programs are also presented. The CD includes trial versions of five PL/SQL development environments, which include debugging techniques.

  • Work effectively in Oracle8i PL/SQL development and execution environments

  • Trace and debug PL/SQL applications using DBMS_DEBUG and DBMS_TRACE, as well as third-party tools

  • Take advantage of Oracle8i increased package body size

  • Schedule PL/SL jobs to run automatically at specified times with DBMS_JOB

  • Use the UTE_FILE package to allow PL/SQL to read from and write to operating system files

  • Use native dynamic SQL to create and execute SQL and PL/SQL statements at runtime

  • Enable intersession communication with database pipes and database alerts

  • Write external routines with Pro C and embedded SQL

  • Use object types and methods effectively, including Oracle8i enhancements to them
  • Manipulate large objects (LOBs) with the DBMS-LOB package

"About this title" may belong to another edition of this title.

Top Search Results from the AbeBooks Marketplace

1.

Scott Urman
Published by Osborne/McGraw-Hill (2000)
ISBN 10: 0072121467 ISBN 13: 9780072121469
New Paperback Quantity Available: 1
Seller
Ergodebooks
(RICHMOND, TX, U.S.A.)
Rating
[?]

Book Description Osborne/McGraw-Hill, 2000. Paperback. Book Condition: New. CD-Rom. ed.. Bookseller Inventory # DADAX0072121467

More Information About This Seller | Ask Bookseller a Question

Buy New
12.87
Convert Currency

Add to Basket

Shipping: 3.08
Within U.S.A.
Destination, Rates & Speeds

2.

Scott Urman
Published by Osborne/McGraw-Hill (2000)
ISBN 10: 0072121467 ISBN 13: 9780072121469
New Paperback Quantity Available: 1
Seller
Irish Booksellers
(Rumford, ME, U.S.A.)
Rating
[?]

Book Description Osborne/McGraw-Hill, 2000. Paperback. Book Condition: New. book. Bookseller Inventory # 0072121467

More Information About This Seller | Ask Bookseller a Question

Buy New
26.86
Convert Currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, Rates & Speeds

3.

Urman, Scott
Published by Osborne/McGraw-Hill (2000)
ISBN 10: 0072121467 ISBN 13: 9780072121469
New Paperback Quantity Available: 2
Seller
Murray Media
(North Miami Beach, FL, U.S.A.)
Rating
[?]

Book Description Osborne/McGraw-Hill, 2000. Paperback. Book Condition: New. Bookseller Inventory # P110072121467

More Information About This Seller | Ask Bookseller a Question

Buy New
29.35
Convert Currency

Add to Basket

Shipping: 2.31
Within U.S.A.
Destination, Rates & Speeds

4.

Scott Urman
ISBN 10: 0072121467 ISBN 13: 9780072121469
New Quantity Available: 1
Seller
Castle Rock
(Pittsford, NY, U.S.A.)
Rating
[?]

Book Description Book Condition: Brand New. Book Condition: Brand New. Bookseller Inventory # 97800721214691.0

More Information About This Seller | Ask Bookseller a Question

Buy New
30.90
Convert Currency

Add to Basket

Shipping: 3.08
Within U.S.A.
Destination, Rates & Speeds