Part I: Working With Packages

This part of the tutorial introduces packages, the most important construct in PL/SQL for building reusable code and employing object-oriented design techniques. PL/SQL Packages describes how and when you should create packages and explains why PL/SQL developers should learn to center their entire development process around packages. Best Practices for Packages presents my tried-and-true "best practices" for building packages. The PL/SQL Development Spiral puts packages in the context of overall PL/SQL development by providing a tutorial on solving a typical problem in PL/SQL.