Product Description

Sams Teach Yourself PL/SQL in 21 Days, Second Edition, quickly empowers you to create your own Oracle solutions with PL/SQL. Completely revised to cover Oracles 8i, the book provides guidance and direction, leading you through a progression of topics that begin with the basic building blocks of PL/SQL, and ending with in-depth discussions of the more commonly used advanced features of Oracle's database programming environment. New topics include extended dynamic SQL within PL/SQL, Dynamic SQL within PL/SQL, use of invoker's rights, autonomous transactions, interfacing PL/SQL with Java, PL/SQL Bulk Binds, parameter passing by reference, and advanced Querying.

Product Details

• Amazon Sales Rank: #289974 in Books
• Published on: 2000-01-12
• Original language: English
• Number of items: 1
• Binding: Paperback
• 720 pages

From the Back Cover

Sams Teach Yourself PL/SQL in 21 Days, Second Edition, quickly empowers you to create your own Oracle solutions with PL/SQL. Completely revised to cover Oracles 8i, the book provides guidance and direction, leading you through a progression of topics that begin with the basic building blocks of PL/SQL, and ending with in-depth discussions of the more commonly used advanced features of Oracle's database programming environment. New topics include extended dynamic SQL within PL/SQL, Dynamic SQL within PL/SQL, use of invoker's rights, autonomous transactions, interfacing PL/SQL with Java, PL/SQL Bulk Binds, parameter passing by reference, and advanced Querying.

About the Author

Jonathan Gennick is a professional developer with over seven years of experience working with relational database technology. As the lead database administrator for the utilities group of KPMG, Jonathan¿s duties include assisting programmers who need to write stored procedures and database triggers using Oracle PL/SQL. A member of MENSA, Jonathan holds a degree in Information & Computer Science from Andrews University in Berrien Springs, Michigan. His writing career began in 1997, when co-authored Teach Yourself PL/SQL in 21 Days. Since then he has been involved with four other book projects, serving as technical editor for Oracle8 Server Unleashed, the development editor for Sams Teach Yourself Access 2000 in 24 Hours, a technical reviewer for Oracle Database Administration, The Essential Reference, and the author of SQL*Plus, the Definitive Guide.

Customer Reviews

A good reference for non-experts like me
This book is clearly written and certainly goes to the level of detail that I am looking for to produce my pl/sql packages. It tells me what I need to know in a well-ordered fashion.

Good in parts.
This book is credited to two authors; Jonathan Gennick and Tom Lueurs. In fact there are a couple of other contributors. The chapters written by Jonathan Gennick are good, in fact really good. There are lots of clear code examples and exercises for you to do. Unfortunately, the chapters written by Tom Lueurs are pretty poor. Loads of little code snippets with the middle missing which are only suitable for people who know what is happening in the missing code and loads of bad jokes to keep the readers mind off the subject to hand. The sequencing of the chapters is also apparently out of sync. There are several references to chapters which are not yet covered. It would appear as if the book was resequnced at some stage before publication. All in all, I wish Mr Gennick had written the book on his own.

Excellent for beginners
I started using the previous edition of this book in June 1999. It is excellent for begiiners and intermediate users. Lots of good and carefully explained examples to follow. I consider myself as an experienced PLSQL developer but I still refer to this book.