Oracle Database 10g PL/SQL Programming (Oracle Press) and over 2 million other books are available for Amazon Kindle . Learn more
FREE Delivery in the UK.
Only 1 left in stock (more on the way).
Dispatched from and sold by Amazon.
Gift-wrap available.
Trade in your item
Get a £0.29
Gift Card.
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

Oracle Database 10g PL/SQL Programming (Oracle Press) Paperback – 1 Oct 2004

See all 3 formats and editions Hide other formats and editions
Amazon Price New from Used from
Kindle Edition
"Please retry"
"Please retry"
£18.00 £0.43

Trade In this Item for up to £0.29
Trade in Oracle Database 10g PL/SQL Programming (Oracle Press) for an Amazon Gift Card of up to £0.29, which you can then spend on millions of items across the site. Trade-in values may vary (terms apply). Learn more

Product details

  • Paperback: 896 pages
  • Publisher: McGraw-Hill Osborne (1 Oct 2004)
  • Language: English
  • ISBN-10: 0072230665
  • ISBN-13: 978-0072230666
  • Product Dimensions: 18.5 x 4.4 x 23.4 cm
  • Average Customer Review: 2.3 out of 5 stars  See all reviews (3 customer reviews)
  • Amazon Bestsellers Rank: 1,530,029 in Books (See Top 100 in Books)
  • See Complete Table of Contents

More About the Authors

Discover books, learn about writers, and more.

Product Description

From the Back Cover

Write Robust PL/SQL Applications

Create dynamic client/server applications using PL/SQL and the comprehensive information contained in this authoritative volume. Expert Oracle insiders cover the features of PL/SQL, explain scripting semantics and syntax, and fully detail the PL/SQL functionality of Oracle Database 10g. You’ll learn how to write powerful PL/SQL programs, interact with Oracle databases, perform complex calculations, and handle error conditions. Plus, you’ll get insider programming tips and techniques and real-world examples from the Oracle community.

  • Develop, tune, and debug PL/SQL programs that access Oracle databases from a wide variety of environments
  • Use PL/SQL block structures, variables, datatypes, expressions, operators, and statements
  • Regulate and recover from errors using exceptions and exception handlers
  • Deploy subprograms, procedures, functions, packages, and triggers
  • Accomplish intersession communication with DBMS_PIPE and DBMS_ALERT
  • Write object-oriented PL/SQL applications
  • Manage large sets of data using PL/SQL records and objects
  • Work with Oracle Net Services, external procedures, Java libraries, and C shared libraries
  • Perform object-oriented programming using transient objects, inheritance, type evolution, and attribute chaining
  • Automate database tasks with DBMS_JOB and DBMS_SCHEDULER and add e-mail functionality with UTL_SMTP and UTL_MAIL

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.

Inside This Book (Learn More)
First Sentence
We've seen some really well-written code make some really lousy applications. Read the first page
Explore More
Browse Sample Pages
Front Cover | Copyright | Table of Contents | Excerpt | Index
Search inside this book:

Customer Reviews

2.3 out of 5 stars
Share your thoughts with other customers

Most Helpful Customer Reviews

8 of 8 people found the following review helpful By God on 8 Oct 2005
Format: Paperback
I put this on my Amazon Wish List last year as it looked as though I might learn something new from it, and I got it for Christmas. I've recently started reading it and I have been very disappointed.
Almost every time an Oracle feature is mentioned as being new in version x, the authors have got it wrong (PL/SQL stored procedures were new in 7.0 not 7.3, the term "Associative Array" is from 9i not 10g, etc). The syntax they use for querying collections using "THE(subquery)" has been deprecated since 8i, indicating that nobody has checked the manual. They briefly list the new 10g SET and MULTISET collection operators on one page (not listed in the index), wrongly claim that you can use SET with associative arrays, and then make no further mention of them. Instead they spend the next 85 pages laboriously going over basic features that have been around since 8i or earlier, often devoting a whole page to demonstrating that something is not posssible (using EXTEND with an associative array for example). They frequently confuse Varrays with Nested Tables, at one point defining a type named "VARRAY_NESTED_TABLE". They show two "alternative" syntaxes for defining an Associative Array type, that are both (a) the same, and (b) wrong.
Overall I get the impression of old material being hastily edited to give an impression of a definitive guide to 10g PL/SQL features, which it is not.
I really pity anyone new to PL/SQL reading this book and trying to make any sense of it.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
6 of 6 people found the following review helpful By A Customer on 7 Mar 2005
Format: Paperback
I bought this as a reference and rough introduction to pl/sql.
The book is thick, so it will appeal to people who feel they are getting more for their money if they buy a heavy book. However, coverage is very flaky and many important features seem to have been left out, with fairly unimportant stuff taking up the space instead.
For example: Today I had to learn two new things: If I could use "continue" in a for loop as well as a while loop, and how temporary tables worked in pl/sql (and what the difference between a pl/sql table and a temporary table was.)
The index contains none of the terms "continue statement", "temporary table" or "pl/sql table" so finding anything at all was difficult. I have yet to find any of the answers in this book - although I did find a two-page discussion of why GOTO is still included in the language where I expected to find information on something I would actually use.
If you pick this book up at a book store (as I did), it LOOKs like the kind of thing you want to get - but actual use of the book has led me to give up and just use google to find any information I need.
Waste of money.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
1 of 1 people found the following review helpful By Tomas Vondra on 22 Jun 2009
Format: Paperback
I've bought this book a few years ago along with the "Oracle PL/SQL programming" from Steven Feuerstein and Bill Pribyl. Comparing these two books, the one from O'Reilly is much more thorough and provides considerably more information about various 'gotchas' and problems related to the topic.

I don't say this book is not good - it's a well organized book and I generally do recommend it as an introductory material, but then use the book from O'Reilly for a really thorough study. So I definitely was not disappointed by this book, but if I had to buy only one of them I'd buy the one from O'Reilly.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again

Most Helpful Customer Reviews on (beta) 28 reviews
29 of 32 people found the following review helpful
Excellent PL/SQL Resource 3 Oct 2004
By ueberhund - Published on
Format: Paperback
SQL developers experienced with non-Oracle databases or Oracle developers who are looking for a good reference manual should definitely pick up a copy of this book. Inexperienced SQL developers will probably get more out of Oracle Press' other excellent book PL/SQL 101.

This book begins exactly the way experienced developers would expect-it starts out at a running pace. The book takes the next hundred-or-so pages just discussing PL/SQL basics. Where this book excels is in its examples. Each and every PL/SQL principle is clearly illustrated with many clear and relevant examples. The author then begins into a discussion of advanced PL/SQL techniques, which includes a discussion of cursors, built-in functions, and records.

The middle section of the book covers management and syntax of Oracle packages and functions. This excellent discussion covers such issues as package scope and permissions. This discussion naturally leads into advanced PL/SQL techniques including transactions, pipes, and various built-in DBMS packages. Finally, the book rounds out its PL/SQL discussions by reviewing use of Large Objects (LOB). In this section, the author discusses use and retrieval of data in this format.

I would highly recommend this book to experienced Oracle or even non-Oracle developers who want to sharpen their PL/SQL skills or who are looking for a really good PL/SQL reference. This is a must-have book for anyone serious about their PL/SQL development work.
19 of 21 people found the following review helpful
A couple of bad chapters, but good for 1Z0-147 6 Dec 2005
By George Roman - Published on
Format: Paperback Verified Purchase
I bought this book hoping it would help me pass the 1Z0-147 Oracle PL/SQL certification test, and it did. First the bad news: chapters five and six are horrible. The person that wrote these two chapters writes in the most pedantic way possible. Pages upon pages are filled with highly repetitive code, with each example followed by a detailed analysis of every statement! Compare this to the coding examples in other chapters, where statements of interest are highlighted and then followed by descriptions of their significance. If you want a laugh, check out page 225, where the author of chapter six says, "A problem with programming books is that concepts need to be illustrated with an economy of space." Wow.

I read the first ten chapters of this book sequentially in order to prepare for the exam, and (with the obvious exception of chapters five and six) really enjoyed the material. I think the book is well written: the organization is excellent and the examples are very clear and concise. I especially liked the summaries comparing and contrasting one construct or approach to another. The book is addressed to individuals that have programming and SQL experience, but I think it could be used by a database beginner as well.

If you're studying for 1Z0-147, my advice is: read this book (chapters 1 - 10, 16) then read the Oracle Application Developer's Guide - Fundamentals, Part II: PL/SQL (Procedure & Packages, Dynamic SQL, and Triggers). Getting an online study guide helps as well as you can train for the exam is an environment virtually identical to the one in which the exam is given.
16 of 18 people found the following review helpful
Poorly Written for a Book on Programming 25 Jun 2007
By Frank N. Loreti - Published on
Format: Paperback
The book is a large survey of the PL/SQL language and introduces many new things that have changed with 10g. But there is a major problem with the book, which runs throughout almost all Oracle Documentation.

The book is written more as a corporate training manual than that of a programming text book. As probably everyone who ever took a training class from their company knows, training is often done by people who not only are not educators, but may not actually understand or have even used the subject of the training. It is intentional that such people do not state the concepts abstractly - they only know concrete examples and maybe only the example in their pre-written material.

This book fits this description to a T. It does not specify the correct syntax except in examples. It does not specify the qualifications and conditions governing the language elements or the examples. As such, unless you are essentially copying an example almost verbatim, you have no real knowledge of whether your code will compile, let alone work as intended. As an example consider their discussion of SELECT statements. They speak about the Select clause, the INTO clause, etc. Nowhere do they state that the list of items in the INTO clause should separated by commas. Although most people could correctly guess that the comma is the separator, you need to find an example to show you that. The book is rampant with omissions like this. Two pages later, they use an OPEN - FOR construct in an example without introducing it. That it can be used dynamically, i.e. with the query in a character string constructed at run time, is not only not mentioned in this section, but is not even mentioned in the chapter on Dynamic SQL.

This should be looked upon as a book of (simple) examples. It should be no one's text or reference.
8 of 8 people found the following review helpful
Good book - where's my cd 9 Nov 2004
By David Chojnacki - Published on
Format: Paperback
I got the book for some of the new 10g features and have found it helpful. The examples were very great once I found them. After some digging I found the code for the examples online, but according to amazon there was supposed to be a cd...WHERE??

I recommend the book, but know that you need to download the examples (nice format for the code btw).
10 of 11 people found the following review helpful
Good PL/SQL references and great examples 12 Oct 2004
By Anne Rausch - Published on
Format: Paperback
I've only been completely through various sections that are relevant to projects that I am now working on. However, even though it isn't written for the novice, the general info has already proven to be an incredible refresher that takes the reader into great depth and with a wide variety of real world examples that make sense and work. No more old broken examples that never did work. Yipee!!!

Of particular interest to me is the information on working with different composite data types. Also, if you want solid and extensive info on handling exceptions with PL/SQL, I highly recommend the book. From a readability standpoint, it is by far the best Oracle book that I've come across, taking rather dry confusing information, organizing it, and laying it out in a logical and useable fashion.

Managers... know this book since it will be the title your new 10g PL/SQL hires will have been taught from. Particularly advantageous to those who teach will be NOT having to rewrite examples and the resulting loss of hair and sleep.

Were these reviews helpful? Let us know