PL/SQL packages
Packages are the database objects which behave as libraries and grounds on the principle of encapsulation and data hiding. A package is privileged to contain a variety of constructs such as subprograms, variables, cursors, exceptions, and variables. In addition, it enjoys multiple add-on features such as subprogram overloading, public and private member constructs, and so on.
Note
Standalone subprograms cannot be overloaded. Only packaged subprograms can be overloaded by virtue of their signatures.
The following diagram shows the advantages of a package:
A package has two components—package specification and package body. While package ...
Get Oracle Advanced PL/SQL Developer Professional Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
