Explain what Is Written As Part Of The Package Specification And The Package Body?

Category: QuestionsExplain what Is Written As Part Of The Package Specification And The Package Body?
Editor">Editor Staff asked 2 years ago

Explain what Is Written As Part Of The Package Specification And The Package Body?

1 Answers
Editor">Editor Staff answered 2 years ago

The package specification consists of the declaration of all the global variables, cursors, types, procedures, and functions that are public and required to be called from within or outside the package.
The package body consists of the definition of all the public constructs that are declared within the package specification and the definition of all the private variables, cursors, types, procedures, and functions that are required only within the package. Following code snippet shows the implementation of the package specification and the package body: