Join Amazon Prime and get unlimited Free One-Day Delivery. Already a member? Sign in.

 

or
Sign in to turn on 1-Click ordering.
 
   
More Buying Choices
21 used & new from £15.00
Have one to sell? Sell yours here
 
   
Oracle Database 10g PL/SQL Programming (Osborne Oracle Press Series)
 
 
Share your own customer images
Search inside this book

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: £32.99
Price: £19.79 & this item Delivered FREE in the UK with Super Saver Delivery. See details and conditions
You Save: £13.20 (40%)
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, July 21? Choose Express delivery at checkout. See Details
17 new from £18.80 4 used from £15.00

Frequently Bought Together

Oracle Database 10g PL/SQL Programming (Osborne Oracle Press Series) + Oracle Database 10g The Complete Reference (Osborne Oracle Press Series) + Oracle PL/SQL Programming
Price For All Three: £77.42

Show availability and shipping details

Customers Who Bought This Item Also Bought

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

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

by Kevin Loney
£25.14
Oracle Database 10g Performance Tuning Tips & Techniques (Osborne Oracle Press Series)

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

by Richard Niemiec
1.0 out of 5 stars (1)  £22.79
Oracle Database 10g SQL (Osborne Oracle Press Series)

Oracle Database 10g SQL (Osborne Oracle Press Series)

by Jason Price
3.0 out of 5 stars (1)  £18.00
Oracle PL/SQL Programming

Oracle PL/SQL Programming

by Steven Feuerstein
4.3 out of 5 stars (20)  £32.49
Oracle Database 10g DBA Handbook (Osborne Oracle Press Series)

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

by Kevin Loney
1.0 out of 5 stars (1)  £24.00
› 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: 233,364 in Books (See Bestsellers in Books)

    Popular in this category:

    #17 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?)
9i, 10G & DBA Training
   www.e-careers.co.uk/Oracle    Latest 9i, 10G & DBA Courses Free Training Demo Here. 
OCA/OCP Courses in 8 Days
   www.firebrandtraining.co.uk    From the Training Company of the Year, 3 years running. 
Oracle databases
   www.bull.com    3 key principles for consolidation Watch our free webcast 
  
 

Product Description

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

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


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
Browse Sample Pages
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
Search inside this book:

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)
Check a corresponding box or enter your own tags in the field below
oracle
pl-sql
oracle doorstop plsql sql programming
database

Your tags: Add your first tag
 
See most popular tags

What Do Customers Ultimately Buy After Viewing This Item?

Oracle Database 10g PL/SQL Programming (Osborne Oracle Press Series)
55% 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.79
Oracle PL/SQL Programming
19% buy
Oracle PL/SQL Programming 4.3 out of 5 stars (20)
£32.49
Oracle Database 10g The Complete Reference (Osborne Oracle Press Series)
9% buy
Oracle Database 10g The Complete Reference (Osborne Oracle Press Series)
£25.14
Oracle Database 11g PL/SQL Programming (Osborne Oracle Press Series)
9% buy
Oracle Database 11g PL/SQL Programming (Osborne Oracle Press Series) 3.0 out of 5 stars (1)
£16.49
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:
Most Helpful Customer Reviews

 
7 of 7 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)



 
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
 
 
 
Only search this product's reviews


Customer Discussions

 Beta (What's this?)
This product's forum (0 discussions)
  Discussion Replies Latest Post
  No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
Topic:
First post:
Prompts for sign-in
  [Cancel]

   

Listmania!

Create a Listmania! list

Look for similar items by category

Feedback

Oracle Advanced PL/SQL Programming

Oracle Advanced PL...

PL/SQL is a sophisticated programming language used to access an... Read more

›Find similar items

 

More From D.CS. Michael McLaughlin

Oracle Database 11g...

Oracle Database 11g PL/SQL Programming

The bestselling PL/SQL desktop reference--fully rewritten and expanded... Read more
£29.99 £16.49

 

Up to 53% off Braun Series Shavers

Braun Series 3 390cc Clean & Renew System Rechargeable Foil Electric Shaver
Get in touch with your smooth side with Braun Series shavers, now with Gillette blade technology.

›Discover Braun Series at Amazon.co.uk

  

Treat Someone

Amazon.co.uk Gift Certificates--available in any amount from £5 to £500 With an Amazon.co.uk Gift Certificate, you can get them what they want (even if you don't know what that is).

›Learn more about Gift Certificates

  
Ad

Where's My Stuff?

Delivery and Returns

Need Help?

Your Recent History

  (What's this?)
You have no recently viewed items or searches.

After viewing product detail pages or search results, look here to find an easy way to navigate back to pages you are interested in.

Look to the right column to find helpful suggestions for your shopping session.
Continue Shopping: Top Sellers

amazon.co.uk Amazon Home
International Sites:  United States  |  Germany  |  France  |  Japan  |  Canada  |  China
Business Programs: Sell on Amazon  |  Fulfilment by Amazon  |  Join Associates  |  Join Advantage
Customer Service  |  Help  |  View Basket  |  Your Account
About Amazon.co.uk  |  Careers at Amazon
Conditions of Use & Sale |  Privacy Notice  © 1996-2009, Amazon.com, Inc. and its affiliates