Package section - PL/SQL Packages

Q.  A package will have which of these mandatory parts?
- Published on 07 Jul 15

a. 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.

Post your comment / Share knowledge

Enter the code shown above:
(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)