Oracle8i Advanced PL/SQL Programming [Paperback]

Scott Urman (Author)

Book Description

Publication Date: April 24, 2000 | Series: Oracle Press

Develop robust, Web-enabled PL/SQL applications using the in-depth information offered in this Oracle-approved guide.

Editorial Reviews

Amazon.com 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

See all Editorial Reviews

Product Details

• Paperback: 772 pages
• Publisher: Osborne/McGraw-Hill; CD-Rom. ed. edition (April 24, 2000)
• Language: English
• ISBN-10: 0072121467
• ISBN-13: 978-0072121469
• Product Dimensions: 9.1 x 7.4 x 1.9 inches
• Shipping Weight: 3.8 pounds
• Average Customer Review: 4.0 out of 5 stars  See all reviews (6 customer reviews)
• Amazon Best Sellers Rank: #1,727,728 in Books (See Top 100 in Books)

More About the Author

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

Most Helpful Customer Reviews

23 of 23 people found the following review helpful:

3.0 out of 5 stars Not much different from the author's previous book, June 1, 2000

By 

Eric L. Ma - See all my reviews

This review is from: Oracle8i Advanced PL/SQL Programming (Paperback)

I agree with the previous reviewer. If you own a copy of the version 8 book, you can definitely skip this one. The only new info included in this book is a survey of PL/SQL IDE's and their built-in debuggers (this might be the only added value to this edition), summary of Oracle8i PL/SQL new features, and Java external procedures. Other chapters are practically identical to those in the older edition. In fact, the chapter on the DBMS_LOB package has been removed from the printed version.

If you need to learn Oracle8i's new PL/SQL capabilities, pick up Steven Feuerstein's Guide.

13 of 17 people found the following review helpful:

4.0 out of 5 stars Good Oracle 8i Pl/Sql book ...... but, May 9, 2000

By 

"mzahid" - See all my reviews

This review is from: Oracle8i Advanced PL/SQL Programming (Paperback)

Hello Oracle users. Oracle 8i pl/sql programming book is a very good reference book but if you have learned pl/sql using the Oracle 8 pl/sql programming book in the past then this book is not a good buy. Poor coverage of Java related programming and implementation in Oracle 8i database version. I would strongly recommend if you are planning on learning Java with Oracle then maybe you want to take a look at "Oracle 8i SQLJ programming book" also published by Oracle press. Most of this book is copy of Oracle 8 pl/sql programming book with few modified examples. Since I like Oracle 8 Pl/Sql programming book I will give this book also 4 stars.

2 of 2 people found the following review helpful:

4.0 out of 5 stars Great book; Questionable Examples., June 1, 2001

By A Customer

Amazon Verified Purchase

This review is from: Oracle8i Advanced PL/SQL Programming (Paperback)

This is a very good book that seems to cover most of the PL/SQL language. There are lots of great examples, but quite a number of the code examples, provided on CD, will not compile due to various errors (bad column names, datatype mismatches, etc). I was able to fix some of the errors, but not all, leaving me with lots of questions.