Regular marked price: $54.99Discount Price: $34.64
Cost Savings: $20.35 (37%)Price fluctuation possible.
How soon does it ship: Normal ship time within one day
Shipping? Absolutely FREE if you qualify for Super Saver Shipping.
Type of bind: Paperback
Dewey Decimal Number: 005.7585
EAN num: 9780072230666
ISBN number: 0072230665
Label: McGraw-Hill Osborne Media
Manufacturer: McGraw-Hill Osborne Media
Quantity: 1
Page Count: 896
Printing Date: April 19, 2004
Publishing house: McGraw-Hill Osborne Media
Sale Popularity Level: 61064
Studio: McGraw-Hill Osborne Media
Other books you might be interested in perusing:
Editor's Notes and Comments:
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.
User popularity level:
Rated by buyers -
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.
Rated by buyers 
-
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 very 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 very 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...
Rated by buyers 
-
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.
Rated by buyers -
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.
Rated by buyers -
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.
Find other books like this one:
