Package section - PL/SQL Packages
Q. A package will have which of these mandatory parts?- Published on 07 Jul 15a. Package specification
b. Package body or definition
c. Both A & B
d. None of the above
ANSWER: Both A & B
A package has two mandatory parts:
1. Package Specification - This is the interface to the package. It declares the types,variables,constants,exceptions,cursors and the subprograms. It contains all information about the content of the package.
2. Package Body - It consists of all the codes for the methods declared in the package specification.