Summary: in this tutorial, you’ll learn about the PL/SQL package and the advantages of using the packages in application development.
What is a PL/SQL package #
In PL/SQL, a package is a schema object that contains definitions for a group of related functionalities. A package includes variables, constants, cursors, exceptions, procedures, functions, and subprograms. It is compiled and stored in the Oracle Database.
Typically, a package has a specification and a body. A package specification is mandatory while the package body can be required or optional, depending on the package specification.
The following picture illustrates PL/SQL packages: