Programming Books C Java PHP Python Learn more Browse Programming Books
Other Sellers on Amazon
19 used & new from $2.54
Have one to sell? Sell on Amazon
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 PL/SQL by Example (3rd Edition) Paperback – September 20, 2003

4.4 out of 5 stars 10 customer ratings 10 ratings | 9 customer reviews 9 reviews
ISBN-13: 007-6092025610 ISBN-10: 0131172611 Edition: 3rd

5 New from $19.94 14 Used from $2.54
Amazon Price New from Used from
Paperback
"Please retry"
$19.94 $2.54

There is a newer edition of this item:

Free%20Two-Day%20Shipping%20for%20College%20Students%20with%20Amazon%20Student


Customers viewing this page may be interested in these sponsored links

  (What's this?)
  -  
FICO named a Major Player in 2014 Vendor Assessment- IDC MarketScape
  -  
Instructor led training for professionals by professionals
  -  
Navigate Through Code Easily Get dbForge Studio For Oracle !
See a problem with these advertisements? Let us know

NO_CONTENT_IN_FEATURE

Shop the new tech.book(store)
New! Introducing the tech.book(store), a hub for Software Developers and Architects, Networking Administrators, TPMs, and other technology professionals to find highly-rated and highly-relevant career resources. Shop books on programming and big data, or read this week's blog posts by authors and thought-leaders in the tech industry. > Shop now

Product Details

  • Paperback: 768 pages
  • Publisher: Prentice Hall; 3 edition (September 20, 2003)
  • Language: English
  • ISBN-10: 0131172611
  • ISBN-13: 978-0131172616
  • Product Dimensions: 9.2 x 7 x 1.5 inches
  • Shipping Weight: 2.3 pounds
  • Average Customer Review: 4.3 out of 5 stars  See all reviews (9 customer reviews)
  • Amazon Best Sellers Rank: #525,607 in Books (See Top 100 in Books)

Customer Reviews

4.3 out of 5 stars
Share your thoughts with other customers

Most Helpful Customer Reviews

12 of 12 people found the following review helpful By W Boudville HALL OF FAMETOP 1000 REVIEWERVINE VOICE on September 29, 2003
Format: Paperback
Very much a task oriented book, suitable for a classroom or self paced study. It is aimed at someone who wants or needs explicit lessons and exercises. Thoughtfully, the authors also furnished answers to the exercises. Sometimes with other computing books, I have wondered why their authors omit questions. Perhaps the nature of the topic makes it awkward to provide problem sets. But not for Oracle's PL/SQL language. So this book is chock-a-block with them.
To students, retention is greatly enhanced by doing, and the book will take you a long way into facility with PL/SQL if you can discipline yourself to go through it methodically and not peek at the answers till you have given the problems a fair go.
As far as the language itself, the book's presentation reminds me of a text on fortran or C, and unlike a text on java or C#. Firstly, the latter two are object-oriented, while PL/SQL, fortran and C are procedural. So if you have already learnt fortran or C and you read this book, step back and defocus a little from the specific syntax. Stylistically, the book has the flavour of many texts in those languages. Reinforced by PL/SQL not having a GUI. The I/O is character based. A slight retro feel. [Though PL/SQL should NOT have a GUI. It is optimised as a query language.]
One thing to note is that the book explains using examples and exercises that are at the subroutine or procedural level, as mentioned above. Bite sized. What it lacks are higher level examples that necessitate decomposing a problem into several procedures. But this may be unfair. Those are harder, more abstract issues, whereas this book is meant for someone who still needs to learn the syntax in the first place. It does suggest the utility of such a book, as a logical successor to this.
Read more ›
1 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
8 of 8 people found the following review helpful By John on March 4, 2005
Format: Paperback Verified Purchase
I'm a developer and DBA who had not written PL/SQL in over a year. I used this book as a refresher.

This is the "Learning Perl" of PL/SQL, meaning: a beginner can learn from it, and an experienced hack can use it as a reference.

I consider lots of good sample code to be important when learning a programming language. Here it is, as a series of labs, with intelligent discussion. It's like having a friend who's an expert act as a personal tutor. It has complete, well-rounded coverage of PL/SQL fundamentals: control structures, stored procedures, packages, and a good chapter on triggers. In rare cases where some keyword is introduced with no explanation, it's usually covered in the following section.

It is nearly the quality of Oracle course materials, but with (a tolerable amount of) typos. Annoyingly, some of the typos are incorrect answers in the appendix; the rest are obvious typos and therefore not too confusing.

Chapter 1 is deceptively basic, explaining what a program is, what a programming language is, etc., but chapter 2 jumps right into PL/SQL with no further ado. The book progresses in baby steps as far as PL/SQL is concerned. Although knowledge of SQL is assumed, some concepts like commit & rollback, savepoints, and sequences are introduced and explained for beginners. It is also assumed that the reader:

- knows what DML, DDL, and the DUAL table are;
- has an account that can create objects (the "Scott" demo account will do); and
- knows how to connect to the database with SQL*Plus or a development tool (IDE).

With an IDE I was able to work through it in about thirty hours.
Read more ›
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
10 of 11 people found the following review helpful By V. Chkliar on October 17, 2004
Format: Paperback
It is not as good as Alice Rischert's "Oracle SQL by example". Looks like it is written for people who never programed before. So it teaches how to program using examples of pl/sql. Might be good for beginners.
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
5 of 5 people found the following review helpful By A. Gendle on June 23, 2004
Format: Paperback Verified Purchase
I'm a really big fan of the Oracle Series books and often wonder why other book authors do not take the same approach. I purchased the 1st editions of Oracle SQL and Oracle PL/SQL back in the day and read both of them. I really loved the format of these books and so I purchased the 3rd edition. They have helped me in passing the SQL and PL/SQL test for the Oracle certification. I just purchased the 3rd edition and really appreciate the fact that they expand on details and have fixed most of the typos from the previous editions. The format of the book is that you read a little and do hands-on activities afterward. This book is probably the best book you could ever buy for yourself because you truly learn PL/SQL. The hands-on labs reinforce the information very well and it's also a great reference tool. This book is definately a must buy for any person wishing to become an Oracle Developer or Oracle DBA. This book will provide you the foundations for your career. THis is the same book they use for the students at Columbia University in New York City.
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
8 of 9 people found the following review helpful By Michael Milligan on May 27, 2004
Format: Paperback
Wes' review was excellent, with one major mistake. Oracle offers all the free software you care to download. Just go to [...] and you can have it all free to learn on, etc. The full versions.
I think the book is very good as well.
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

What Other Items Do Customers Buy After Viewing This Item?

 

Feedback

If you have a question or problem, visit our Help pages.
 Would you like to update product info or give feedback on images?
If you are a seller for this product and want to change product data, click here (you may have to sign in with your seller id).


Your Recently Viewed Items and Featured Recommendations 
 

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