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

DROP PACKAGE [ BODY ] package_name;

If you do not use the BODY keyword, both the package definition and the package body are deleted. For example, the entire package is deleted. If you use the BODY keyword, only the body is deleted. The package definition remains intact. package_name is the identifier of the package to be deleted.

The following statement deletes only the body of the emp_admin package:
DROP PACKAGE BODY emp_admin;
The following statement deletes the definition and the body of the entire emp_Admin package:
DROP PACKAGE emp_admin;