Advanced Oracle PL/SQL Programming with Packages (Nutshell Handbook)
Steven Feuerstein's first book, Oracle PL/SQL Programming, has become the classic reference to PL/SQL, Oracle's procedural extension to its SQL language. His new book looks thoroughly at one especially advanced and powerful part of the PL/SQL language -- the package. The use of packages can dramatically improve your programming productivity and code quality, while preparing you for object-oriented development in Oracle technology. In this book, Feuerstein explains how to construct packages -- and how to build them the right way. His "best practices" for building packages will transform the way you write packages and help you get the most out of the powerful, but often poorly understood, PL/SQL language.
Much more than a book, Advanced Oracle PL/SQL Programming with Packages comes with a PC diskette containing a full-use software companion. Developed by Feuerstein, RevealNet's PL/Vision Lite is the first of its kind for PL/SQL developers: a library of thirty-plus PL/SQL packages. The packages solve a myriad of common programming problems and vastly accelerate the development of modular and maintainable applications.
The packages provided in PL/Vision Lite fall into three categories:
* Building block packages: low-level development enhancers, including string parsers, a list manager, and an interface to PL/SQL tables.
* Developer utilities: programs that improve your PL/SQL development environment, including a code generator, a powerful substitute for SHOW ERRORS, and an online help delivery mechanism.
* Plug-and-play components: pieces of code that can be used as is in your own applications, including a high-level exception handler mechanism and a generic, reusable logging mechanism.
In addition to describing the details of these packages, this book explores why and how they were built the way they were. You'll come away with an increased appreciation of the PL/SQL language and the power of packages. Most importantly, you'll be ready and eager to put that power to use immediately in your own applications.
Looks thoroughly at one especially advanced part of the PL/SQL language - the package, the use of which can dramatically improve programming productivity and code quality. Explains how to construct packages and how to build them the right way. Paper. 3 1/2 inch disk included.
Reviewer: Mike Christie (Austin, TX USA)
The book is structured around a set of packages called PL/Vision. Eighty percent of the book is devoted to describing how to use PL/Vision and what it can do. PL/Vision is a useful set of tools; the P package in particular will be useful to any developer, though most will have already written something similar (though maybe not so fancy) for themselves. P is a packaged version of the dbms_output routines, and allows formatted output, debug output and other similar facilities.
However, the book is not really a reference for Oracle packages. Most of what you need as a reference can be found in Feuerstein's "Oracle PL/SQL Programming", which I recommend. This book is more to give you an idea of what you can do with packages. I found it interesting, but I rarely refer to it--the other Feuerstein book is so comprehensive it covers almost all my questions.