DROP PACKAGE BODY [IF EXISTS] [ db_name . ] package_name
The DROP PACKAGE BODY
statement can be used when Oracle SQL_MODE is set.
The DROP PACKAGE BODY
statement drops the package body (that is, the implementation) which was created using the CREATE PACKAGE BODY statement.
Note, DROP PACKAGE BODY
drops only the package implementation, but does not drop the package specification. Use DROP PACKAGE to drop the package entirely (i.e. both implementation and specification).
This page is licensed: CC BY-SA / Gnu FDL