Customer Reviews

Oracle Database 11g PL/SQL Programming Workbook (Oracle Press)

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

 

 

This book has the same issues for programming newbies as other books of this type (yes, even in the 'for Dummies' books).

The issues are as follows.
1. New terminology/functions is introduced without being fully explained in the text nor is there a reference to where this information can be found.
2. Code samples contain code that has not been covered yet or contains exceptions to the rules being taught.
3. As new information is taught, the sample code for that particular section contains too many differneces from the code used in the sample code from the immediately preceeding section.

The first one is frustrating but a quick search on-line can usually give a more thorough definition of a term or the syntax for a funtion (c.f. try to find "guard-on-entry loop").

The last two are the more trying because the sample code is not really searchable. Samples code should build on previous examples and only introduce the new coding currently being covered. Too many new and unexplained functions, clauses, or statements confuse the newbie.

This book is essential for Oracle veteran and beginner alike. It wraps all the best practices and new features into an easy to read, example laden, treasure of insight into PL/SQL on 11g. A must for all. It is like having a friend who is ready when you need him to point out the new, give you an example, and teach you the pit falls and best practices that you may not think of otherwise.

Product is perfect for folks who have used PL/SQL for years as a refresher and way to catch up on/practice the art of PL/SQL as well as see whats new!

The book is very thorough and the examples and exercises are extremely helpful. I liked the approach of having two examples span the whole book, plus lots of exercises at the end of chapters to reinforce what was learned in each chapter.