What is the syntax for creating a package body?

What is the syntax for creating a package body?

Rating:

Following is the syntax for creating a package body:

CREATE [OR REPLACE] PACKAGE BODY package_name
IS | AS
private type and item declarations
subprogram bodies
END package_name;

where,

OR REPLACE option specifies that if the package body already exists, it will be dropped and replaced with the new version created by the statement.

private type and item declarations represent variables, constants, cursors, exceptions, or types. Variables defined solely in the package body are private constructs. These are not visible outside the package body. All private constructs must be declared before they can be used in public constructs.

subprogram bodies define the public and private PL/SQL subprograms.

Note: The order in which subprograms are defined within the package body is important. A variable must be declared before it can be referred by another variable or subprogram. Private subprograms must be declared or defined before they can be called from other subprograms. It is a common practice to define all private variables and subprograms first and define public subprograms last in a package body.

Rating: