Oracle Database 10g PL/SQL Programming | 
 enlarge | Authors: Scott Urman, Michael Mclaughlin
Creator: Ron Hardman
Publisher: McGraw-Hill Osborne Media
Category: Book
List Price: $54.99
Buy New: $27.77
You Save: $27.22 (49%)
New (26) Used (14) from $26.43
Avg. Customer Rating:  21 reviews
Sales Rank: 41818
Media: Paperback
Edition: 1st
Number Of Items: 1
Pages: 896
Shipping Weight (lbs): 3.2
Dimensions (in): 9.1 x 7.3 x 1.9
ISBN: 0072230665
Dewey Decimal Number: 005.7585
UPC: 783254042735
EAN: 9780072230666
ASIN: 0072230665
Publication Date: April 19, 2004
Availability: Usually ships in 1-2 business days
Shipping: International shipping available
Condition: Brand New, Perfect Condition, Please allow 4-14 business days for delivery. 100% Money Back Guarantee, Over 1,000,000 customers served.
|
| Also Available In:
|
| Similar Items:
|
| Editorial Reviews:
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.
|
| Customer Reviews: Read 16 more reviews...
Comprehensive March 25, 2008
2 out of 2 found this review helpful
I "subscribe" to this author and publisher for texts on this topic. I like the writing style and layout of the book. There enough explanation to be thorough, and enough practical examples to be useful outside of pure theoretical discussion. Plus, there are plenty of references in the appendix, so those pages are essentially a "Nutshell."
However, I think I prefer the layout of the 9i edition. The flow was nicer: a structured outline, then some examples. In the 10g edition, the flow seems to have changed: a briefer description in paragraph form, then a lot more examples.
 Not written by educators... Obviously February 6, 2008
4 out of 5 found this review helpful
Let me start by stating that I agree with Frank N. Loreti's review of this book, and one part in particular: this book was not written by educators. And I would like to add that they don't seem to be terribly good writers, either.
Some examples from the first three chapters (plus one page of chapter 4) to illustrate my point:
On page 72, it reads: "Boolean variables, when combined with an IF-THEN block, do not need to be provided with a comparison value if only comparing to TRUE." First, Boolean variables aren't "combined" with an IF-THEN, they are *used* as part of the [Boolean] condition of the IF-THEN. And second, writing that they don't need to be provided is, educationally speaking, not very wise; it suggests that it's a specific feature of the language, a short cut if you will, when in fact it's a mere consequence of how the evaluation of Boolean expressions work.
On pages 108 and 109, I think it's a glaring omission that the writers don't mention whether the PL/SQL CASE statement uses 'fall-thru' or not. For several reasons, I don't expect this to be the case, but if it's not used, how is the 'CASE with different variables' treated? In other words, in the example at the bottom of page 109, is only Steve printed, or all names? Come to think of it: in the example before it, what happens if the conditions in the CASE overlap? (E.g., change the second WHEN-condition to
v_price BETWEEN 30 AND 50
What happens then if v_price equals 35? Will only the first WHEN-statement block be executed? Will both be executed? Will an exception be thrown? Less likely, but not impossible: maybe a compile-time error is given?) It's hard for me to understand how any decent programmer can overlook the fact that these 'details' need to be discussed.
On page 110, loops are discussed: "We cover three different types here: Simple loops. The most basic kind of loop, they include LOOP, END LOOP, and some method of EXIT." Since 'different types' of loops are discussed, the plurality in 'Simple loops' suggests that there are several types of simple loops --and it seems they are called the 'LOOP', and 'END LOOP'... or something. Of course, this is not the case: there's only one type of simple loop. It starts with the keyword LOOP which is followed by a statement block that may/should contain an EXIT statement, and it ends with the keywords END LOOP.
You don't have to be a professional writer to sense that you can't end a section with a couple of bullet points (just like, apparently and unfortunately, you can't end a chapter without a useless summary) so you'll need at least an extra line of text, but unfortunately the writers of this book don't have the finesse to cross that bridge unnoticed. For example, at the beginning of chapter 4 a list of topics for that chapter is given in bullet points, followed by the following recommendation:
"As these features are demonstrated, think about how they can be used to improve the functionality, performance and design of your applications."
It's suggestions like these that simply make my toes curl.
Add to all this the absence of a decent structure (the books keeps jumping from simple features to advanced features and back, fragmenting the explanation of both), and the authors should consider themselves lucky I'm still giving this book 3 stars...
 Best Choice January 9, 2008
1 out of 1 found this review helpful
When I started studing PL/SQL...
I got recommanded this book.
Now I satisfied my choice because of contents of this book.
I recommand this book.
This is THE PL/SQL BOOK August 24, 2007
2 out of 2 found this review helpful
This is the best pl/sql book ever!! It's a complete reference for PL/SQL programation lenguaje, that covers from the basics topics like data types to advanced fueatures like inter-session comunication. Its includes hundreds of examples, online code and a complete reference for Oracle 10g packages and utilitys. This is the ultimate PL/SQL book.
Good, but could be much better July 6, 2007
5 out of 5 found this review helpful
This is book did help me learn PL/SQL; however, it did it in a very painful manner. The book could have easily been condensed to half the size and still convey the same information, only clearly and to the point. Many of the chapters have long coding examples that are followed by a line-by-obvious-line description about what is going on. It's tempting to skip the code explanations; however, there is the occasional hidden piece of useful information in them that forces you to sift through the junk. To make matters worse, much of the code is needlessly commented. You know what type of comments I'm talking about; there will be a comment that reads '-- declare a variable of type varchar' and then a declaration immediately afterward. Wow, thanks for doubling the code size and killing some more trees. Topping that off, in some of the examples, the comments don't actually match what the code is doing. Grrr.
I invested a lot of time in reading this book and after it was all said and done my feeling on it was, meh, I guess I learned something. The book is pretty good, it's just needlessly big, too big and time consuming for the value that it brings to your skill set.
|
|
|
