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.
Working With Packages
Chapter 1 PL/SQL Packages
What Is a PL/SQL Package?
What Are the Types and Layers of Packages?
What Are the Benefits of Packages?
Types of Packages
Chapter 2 Best Practices for Packages
Starting With Packages
Using Effective Coding Style for Packages
Selecting Package Names
Organizing Package Source Code
Constructing the Optimal Interface to Your Package
Our look is the result of reader comments, our own experimentation, and feedback from distribution channels. Distinctive covers complement our distinctive approach to technical topics, breathing personality and life into potentially dry subjects. A moth is featured on the cover of Advanced Oracle PL /SQL: Programming with Packages. Moths, along with butterflies, make up the insect order Lepidoptera, the second largest order of insects. Their wings are largely or entirely covered in tiny, overlapping scales. Moths, unlike butterflies, are mostly nocturnal, yet they tend to fly toward light. An old superstition holds that white moths fluttering around lights in the evening are actually the souls of the recently dead.
The long coil seen on the head of the moth on this cover is the proboscis, a hollow tube through which it sucks up food. The proboscis is actually formed of two rounded tubes joined together by a third tube. When the moth is feeding blood flows through the two outer tubes, forcing the proboscis to straighten. When feeding is done the blood stops flowing to these tubes, allowing the proboscis to coil up and out of the way. All moths and butterflies have such a feeding "tube." Most moths feed exclusively on nectar, preferring flowers that are white or green and that can be seen at night. Their feeding activities make moths and butterflies extremely efficient pollenizers. Some moths, however, have developed proboscises that are strong enough to penetrate fruits. UNIX and its attendant programs can be unruly beasts. Nutshell Handbooks help you tame them.
Edie Freedman designed this cover and the entire UNIX bestiary that appears on the Nutshell Handbooks. The beasts themselves are adapted from 19th-century engravings from the Dover Pictorial Archive. The cover layout was produced with Quark XPress 3.3 using the ITC Garamond font.
The inside layout was designed by Nancy Priest and implemented in FrameMaker 5.0 by Mike Sierra. The text and heading fonts are ITC Garamond Light and Gara mond Book. The illustrations that appear in the book were created in Macromedia Freehand 5.0 by Chris Reilley. This colophon was written by Clairemarie Fisher O'Leary.
Advanced Oracle PL/SQL Programming with Packages Review
By Tim Reddy
Comments about O'Reilly Media Advanced Oracle PL/SQL Programming with Packages:
This book is mistitled, and in no way accomplishes its titled purpose.
Steven Feuerstein's Advanced Oracle PL/SQL Programming with Packages book is a complete waste of time for anybody trying to learn how to write PL/SQL packages. If you want an at length tutorial on how to use some of Steven's own packages go ahead. However, if you are interested in developing your own packages, put your well earned money elsewhere. In short, this book is more of an advertisement for Steven's PL/Vision package than anything.