Buy Used
CDN$ 1.21
+ CDN$ 6.49 shipping
Used: Good | Details
Sold by bwbuk_ltd
Condition: Used: Good
Comment: Ships from the UK. Former Library book. Shows some signs of wear, and may have some markings on the inside. 100% Money Back Guarantee. Your purchase also supports literacy charities.
Have one to sell?
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See this image

Oracle9i PL/SQL Programming Paperback – Nov 28 2001

4.0 out of 5 stars 8 customer reviews

See all 2 formats and editions Hide other formats and editions
Amazon Price
New from Used from
"Please retry"
CDN$ 45.47 CDN$ 1.21

Harry Potter and the Cursed Child
click to open popover

No Kindle device required. Download one of the Free Kindle apps to start reading Kindle books on your smartphone, tablet, and computer.
Getting the download link through email is temporarily not available. Please check back later.

  • Apple
  • Android
  • Windows Phone
  • Android

To get the free app, enter your mobile phone number.

Product Details

  • Paperback: 664 pages
  • Publisher: McGraw-Hill Osborne Media; 2 edition (Nov. 28 2001)
  • Language: English
  • ISBN-10: 0072191473
  • ISBN-13: 978-0072191479
  • Product Dimensions: 18.8 x 4 x 23.1 cm
  • Shipping Weight: 1.3 Kg
  • Average Customer Review: 4.0 out of 5 stars 8 customer reviews
  • Amazon Bestsellers Rank: #2,482,293 in Books (See Top 100 in Books)
  •  Would you like to update product info, give feedback on images, or tell us about a lower price?

  • See Complete Table of Contents

Product Description

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

CD-ROM Contains Sample Code and Development Environments from the Book

About the Author

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.

Customer Reviews

4.0 out of 5 stars
Share your thoughts with other customers

Top Customer Reviews

Format: Paperback
I purchased this book knowing nothing about PL/SQL. I read the entire book and worked through most of the examples in a week of dedicated self-training. The material is presented in a logical order. All the examples worked. Although all scripts are provided on the CD that comes with the book, I typed in all examples which helped in learning the material. The only issue I had with some of the examples is the use of the DBMS_OUTPUT package. This package writes the output of some of the examples to the screen. However, it only does so in SQL*Plus or Server Manager. I was using a tool by Quest called TOAD. I compensated for this by sending the output to a temp table provided by the author and then queried the temp table to retrieve the results. It worked just fine. Working through the examples requires the Oracle database, which shouldn't be a problem since anyone can download Oracle for free from Oracle's website. I give the book a big thumbs up! I definitely feel I have the knowledge necessary to go out and write PL/SQL.
Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again.
Report abuse
By A Customer on Dec 30 2003
Format: Paperback
I must say it is not what I expected. Basically, if you know nothing about PL/SQL, that is, the Oracle extension of the SQL, and you need to grasp its general concept in a very short time, this is the book for you.
But the subtittle of the book is definitely misleading. When it comes to advanced topics, the book simply copies from the online documentation from Oracle, but only the brief summery. Say, function DECODE, one of the most powful feature in PL/SQL, is covered in half a page! Just the official definition. Nothing to read about. If you bought Oracle 9i The Complete Reference, you'd find a whole chapter devoted to that function.
The author didn't do much work with this book. If you're a serious programmer, don't bother with this book.
Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again.
Report abuse
Format: Paperback
I have several books by Urman. I have both 8i PL/SQL Programming books by Urman, as well as the 2001 edition of the 9i PL/SQL Programming book.
The 8i edition of this book is is 978 pages. The 2001 edition of the 9i book is 631. The 9i book has much less content than the 8i book even though more features have been added to Oracle 9i. There is also a large "Advanced" 8i PL/SQL Programming book because the basic book is just not big enough at 978 pages!
My conclusion is that while you MUST own this book, the 9i book does not adequately cover PL/SQL programming. Too much is left to the reader to puzzle-out on his own using other books and resources like Metalink or on-line documents. Why the book shrunk since 8i is a real mystery . . .
Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again.
Report abuse
Format: Paperback
This is, indeed, a great book to pass this exam(1Z0-147). Actually, there is no prescribed book(as of now!!), for this exam. This book fairly covers most of the topics that are specified in the official exam syllabus. However, topics on Large objects are not covered in this book extensively. I suggest to search on google for LOBS(This is how i got some notes on LOBS). This book is good to study functions, procedures, packages, triggers, and some DBMS packages, but it doesn't cover LOBS, managing dependencies. Overall, I can give 4 stars to this book, as it helped me to pass the exam.
Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again.
Report abuse