Packages:

This lesson displays how to bundle associated PL/SQL programming constructs into a package. The packaged constructs might involve a collection of procedures or a pool of type definitions and variable declarations. For instance, a Human Resources package may hold firing and hiring procedures. Once written, the general-purpose package is compiled and then stored in an Oracle database where, such as a library unit, its contents can be shared through several applications.

1. Understanding Packages

2. Advantages of Packages

3. Package Specification and Body

4. Overloading

5. Understanding Some of the Packages