包是一组 PL/SQL 过程和函数, 便于统一管理和维护。
包头中含有包中包含的过程/函数的定义部分。
CREATE [OR REPLACE] PACKAGE [schema.]package_name [AUTHID { CURRENT_USER | DEFINER } { IS | AS } plsql_package_spec |
包体中包含所有信息,并且与包头部分重复的内容必须保持一致。
CREATE [OR REPLACE] PACKAGE BODY [schema.]package_name { IS | AS } plsql_declaration ... [BEGIN pl/sql_initialization_code] END [package_name]; |
ALTER PACKAGE [schema.]package_name COMPILE [DEBUG] [ PACKAGE | SPECIFICATION | BODY ] |
DROP PACKAGE [BODY] [schema.]package_name |