Quantity:

More Buying Choices

18 used & new from �13.50

Have one to sell? Sell yours here

Oracle Database 10g PL/SQL Programming (Osborne Oracle Press Series) (Paperback)

by Scott Urman (Author), Ron Hardman (Author), Michael Mclaughlin (Author) "We've seen some really well-written code make some really lousy applications ..." (more)

2.3 out of 5 stars See all reviews (3 customer reviews)

RRP:	�39.99
Price:	�19.99 & this item Delivered FREE in the UK with Super Saver Delivery. See details and conditions
You Save:	�20.00 (50%)
	o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o

In stock.
Dispatched from and sold by Amazon.co.uk. Gift-wrap available.

Want guaranteed delivery by Tuesday, November 17? Choose Express delivery at checkout. See Details

10 new from �19.99 8 used from �13.50

Special Offers and Product Promotions

This title is part of our Up to 35% Off 1000s of Textbooks offer.
See more Paperbacks at up to 50% off.

Frequently Bought Together

Oracle Database 10g The Complete Reference (Osborne Oracle Press Series)

Price For All Three: �63.95

Show availability and delivery details

This item: Oracle Database 10g PL/SQL Programming (Osborne Oracle Press Series) by Scott Urman
In stock.
Dispatched from and sold by Amazon.co.uk.
This item Delivered FREE in the UK with Super Saver Delivery. See details and conditions
Oracle Database 10g The Complete Reference (Osborne Oracle Press Series) by Kevin Loney
In stock.
Dispatched from and sold by Amazon.co.uk.
This item Delivered FREE in the UK with Super Saver Delivery. See details and conditions
Oracle Database 10g Performance Tuning Tips & Techniques (Osborne Oracle Press Series) by Richard Niemiec
In stock.
Dispatched from and sold by Amazon.co.uk.
This item Delivered FREE in the UK with Super Saver Delivery. See details and conditions

Customers Who Bought This Item Also Bought

Oracle Database 10g The Complete Reference (Osborne Oracle Press Series)

by Kevin Loney

�22.49

Oracle Database 10g Performance Tuning Tips & Techniques (Osborne Oracle Press Series)

by Richard Niemiec

1.0 out of 5 stars (1) �21.47

Oracle Database 10g SQL (Osborne Oracle Press Series)

by Jason Price

3.0 out of 5 stars (1) �15.00

Oracle Database 10g DBA Handbook (Osborne Oracle Press Series)

by Kevin Loney

1.0 out of 5 stars (1) �22.49

Oracle Database 10g RMAN Backup & Recovery (Osborne Oracle Press Series)

by Matthew Hart

�27.93

› Explore similar items

Product details

Paperback: 896 pages
Publisher: McGraw-Hill Osborne; illustrated edition edition (1 Oct 2004)
Language English
ISBN-10: 0072230665
ISBN-13: 978-0072230666
Product Dimensions: 23.1 x 18.5 x 4.8 cm

Average Customer Review: 2.3 out of 5 stars See all reviews (3 customer reviews)

Amazon.co.uk Sales Rank: 370,192 in Books (See Bestsellers in Books)
Popular in this category:
#26 in Books > Computing & Internet > Databases > Oracle > PL & SQL

Would you like to update product info or give feedback on images?

See Complete Table of Contents

Customers Viewing This Page May Be Interested in These Sponsored Links

(What is this?)

Oracle Consultant Agency opens new browser window

www.erintech.co.uk - Oracle UK Partner - specialist agency for Oracle Contractor skills

Product Description

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.

From the Back Cover

Write Robust PL/SQL Applications

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

See all Product Description

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
Concordance

Suggested Tags from Similar Products

(What's this?)

Be the first one to add a relevant tag (keyword that's strongly related to this product)

oracle

pl-sql

oracle doorstop plsql sql programming

database

What Do Customers Ultimately Buy After Viewing This Item?

	56% buy the item featured on this page: Oracle Database 10g PL/SQL Programming (Osborne Oracle Press Series) 2.3 out of 5 stars (3) �19.99
	20% buy Oracle PL/SQL Programming 4.3 out of 5 stars (20) �33.64
	10% buy Oracle Database 10g The Complete Reference (Osborne Oracle Press Series) �22.49
	7% buy Oracle PL/SQL Language Pocket Reference (Pocket Reference (O'Reilly)) 4.2 out of 5 stars (4) �6.48

Explore similar items

Customer Reviews

3 Reviews

5 star:		(0)
4 star:		(1)
3 star:		(0)
2 star:		(1)
1 star:		(1)

Average Customer Review

2.3 out of 5 stars (3 customer reviews)

Share your thoughts with other customers:

Create your own review

Most Helpful Customer Reviews

8 of 8 people found the following review helpful:

1.0 out of 5 stars Global Search & Replace, 8 Oct 2005

By	William Robertson (London, UK) - See all my reviews (REAL NAME)

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 Comment | Permalink | Was this review helpful to you? Yes No (Report this)

6 of 6 people found the following review helpful:

2.0 out of 5 stars Reasonably well written, terrible index, 7 Mar 2005

By A Customer

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 Comment | Permalink | Was this review helpful to you? Yes No (Report this)

1 of 1 people found the following review helpful:

4.0 out of 5 stars a very good introductory material, 22 Jun 2009

By	Tomas Vondra (Czech Republic, Europe) - See all my reviews (REAL NAME)

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 Comment | Permalink | Was this review helpful to you? Yes No (Report this)

Share your thoughts with other customers: Create your own review

› See all 3 customer reviews...

.jsOffDisplayBlock { display: block; } .jsOffDisplayInline { display: inline; } .jsOffVisibility { visibility: visible; } .jsOnDisplayBlock { display: none; } .jsOnDisplayNoneBlock { display: block; } .jsOnDisplayNoneInline { display: inline; } .jsOnDisplayInline { display: none; } .jsOnVisibility { visibility: hidden; } .jqOnDisplayBlock { display: none; } .jqOnDisplayInline { display: none; } .jqOnVisibility { visibility: hidden; } .jqOnDisplayNoneBlock { display: block; } .jqOnDisplayNoneInline { display: inline; }