This topic describes how to delete an entire package or only the package body.

The following statement provides the syntax to delete the entire package or only the package body:

DROP PACKAGE [ BODY ] package_name;

If you omit the BODY keyword, both the package specification and the package body are deleted. This indicates that the entire package is deleted. If you specify the BODY keyword, only the package body is deleted. The package specification remains intact. The package_name parameter specifies the identifier of the package to be deleted.

The following statement deletes only the body of the emp_admin package:


The following statement deletes the entire emp_admin package:

DROP PACKAGE emp_admin;