《精通Oracle10gPLSQL编程》12、开发包

Package用于逻辑组合相关的PL/SQL类型、PL/SQL项、PL/SQL子程序。它由包规范（Package Specification）和包体（Package Body）两部分组成。建立包时，需要首先建立包规范，然后再建立包体。

建立包规范：

create or replace package package_name
is | as
public type and item declarations
subprogram specifications
end package_name;

建立包体：

create or replace package body package_name
is | as
private type and item declarations
subprogram bodies
end package_name;