Title: Create packages (e.g., related variables, cursors, constants, exceptions, procedures, and functions).
Course: Database Design and Management with PL/SQL (Oracle) (10053) > Section: Designing Packages

Creation of packages should include

- writing a program for the package specification:
  - programming the CREATE or REPLACE PACKAGE code naming the package
  - defining the variables and constructs to be used in the package

- writing a program for the package body:
  - programming the CREATE or REPLACE BODY code naming the package body to include the subprograms that were defined in the package specification within a BEGIN – END block.