Oracle’s PL/SQL questions

Structure/Syntax of a package?

Posted by silpa on Mar 25 2007

Package has two types spec and body and its structure is as follows:

SPEC

[CREATE [OR REPLACE] PACKAGE package_name {IS | AS}
END package name;

BODY
[CREATE [OR REPLACE] PACKAGE BODY package_name {IS | AS}BEGINEND package name;