Order from a Major Online Bookstore
Ultimate Book Price Comparison Engine
Save Your Time And Money
| AnyBook4Less.com | Order from a Major Online Bookstore |
|
| Home | Store List | FAQ | Contact Us | | ||
| Ultimate Book Price Comparison Engine Save Your Time And Money |
||
 |
Title: Oracle PL/SQL Programming, Third Edition by Steven Feuerstein ISBN: 0-596-00381-1 Publisher: O'Reilly Pub. Date: 23 September, 2002 Format: Paperback Volumes: 1 List Price(USD): $54.95 |
Average Customer Rating: 4.06 (63 reviews)
Rating: 5
Summary: ODTUG Review
Comment: Most of us have had to learn PL/SQL at some point in our Oracle careers, and I am sure many of you have become quite expert. On the other hand, some of you may be new to this world of PL/SQL and are looking for a basic text that will educate you in the use of this language.
The "Bible" for PL/SQL programming has long been the earlier editions of this book, and Steven Feuerstein has been considered the guru of PL/SQL programming for as many years as I can remember. Steven has completely revised his best-known work into a new, third edition. I thought that it was time to take a look at this new edition and see what it has to offer both groups. Here is what I found.
Steven now provides complete coverage of PL/SQL from Oracle RDBMS version 7.3.4 through Oracle9i Release 2. He has incorporated all the information from his book PL/SQL Guide to Oracle8i New Features into this book. He has added a new chapter on database triggers and included especially useful information on DDL triggers and database event triggers. He has added new content on the PL/SQL runtime architecture, creating and running PL/SQL programs, and calling Java methods from within PL/SQL. He has integrated all the new Oracle9i features throughout the text, instead of placing them in a separate chapter.
In order to make the book fit into 1,000 pages, some of the example code was removed and can be found on O'Reilly's Web site at www.oreilly.com/catalog/oraclep3 as a zipped file. About 300 files are available. Approximately 200 pages that were pruned from the second edition that still have some utility are also available there.
The book is organized much the same way as previous editions, with a few changes. There are 23 chapters divided into six parts:
Part I: Programming in PL/SQL. These three chapters orient you to PL/SQL, its history, utility, and basic programming constructs.
Part II: PL/SQL Program Structure. Conditional, sequential, iterative control structures, and exceptions are covered in these three chapters.
Part III: PL/SQL Program Data. Six chapters cover how to manipulate data within PL/SQL procedures and functions. Strings, numbers, datatypes, including the new Oracle9i datatypes, and records and collections are also discussed.
Part IV: SQL in PL/SQL. There are three chapters that cover transactions, data retrieval, and the use of dynamic SQL.
Part V: PL/SQL Application Construction. The four chapters in this part discuss procedures and functions, packages, triggers, and managing PL/SQL applications.
Part VI: Advanced PL/SQL Topics. There are four final chapters that cover the runtime architecture, object-orientation in PL/SQL, PL/SQL and Java, and external procedure calls.
Steven states in his preface that the three objectives of this book are to
1.take full advantage of the features of PL/SQL,
2.use PL/SQL to solve your problems, and
3.write efficient, maintainable code.
Each chapter has been crafted to address these three objectives. His writing style is clear, succinct, and reads like he is sitting next to you chatting about the new things he's learned. The book is absolutely full of code examples. Most of the examples are posed as practical programming problems. He carefully walks you through the lines of example code, clearly explaining the logic used for each step of the program, and points out version-based differences. Steve is also not afraid to express an opinion and will tell you exactly why he chooses a particular method for solving a problem. Notes explaining tips and traps proliferate the book.
So, what do I think about this new edition? His book has the most comprehensive coverage of PL/SQL that I have ever seen. The code examples achieve a level of sophistication that is truly elegant. For a PL/SQL beginner, this book can be the source of all PL/SQL wisdom. Even if you have been programming with PL/SQL for a time, I think you will find the information on Oracle9i new features useful and will find many nuggets of information that can be used immediately to improve your code.
Rating: 5
Summary: Surprisingly easy to read
Comment: This is one of the best written and easiest to read of any technical book I've ever read. We've often provided this book to students in the Oracle classes that we teach. Furthermore, when I was on an Oracle consulting project a couple of years ago, working alongside consultants from Oracle Corporation, I noticed that the Oracle Corp consultants weren't using the Oracle Corp documentation on PL/SQL for reference - they all had this book.
Steve Feuerstein presents a tremendous overview and in-depth analysis of the PL/SQL language with practical examples. He includes several design recommendations and practical real world examples and recommendations that make this a solid book for PL/SQL professionals who are serious about writing production code.
Rating: 3
Summary: Great Learning Tool; Not Really a Reference
Comment: This is an excellent book to learn the language of PL/SQL; but not really a good reference material.
 |
Title: Oracle PL/SQL Developer's Workbook by Steven Feuerstein ISBN: 1565926749 Publisher: O'Reilly Pub. Date: 15 May, 2000 List Price(USD): $36.95 |
 |
Title: Oracle PL/SQL Best Practices by Steven Feuerstein ISBN: 0596001215 Publisher: O'Reilly Pub. Date: 15 April, 2001 List Price(USD): $19.95 |
 |
Title: Mastering Oracle SQL by Sanjay Mishra, Alan Beaulieu ISBN: 0596001290 Publisher: O'Reilly Pub. Date: April, 2002 List Price(USD): $34.95 |
 |
Title: Expert One-on-One Oracle by Thomas Kyte ISBN: 1590592433 Publisher: APress Pub. Date: 01 August, 2003 List Price(USD): $59.99 |
 |
Title: Learning Oracle PL/SQL by Bill Pribyl ISBN: 0596001800 Publisher: O'Reilly Pub. Date: 15 December, 2001 List Price(USD): $39.95 |
Thank you for visiting www.AnyBook4Less.com and enjoy your savings!
Copyright� 2001-2021 Send your comments
