The following statement shows the syntax to drop the entire package or only drop the body of the package.

DROP PACKAGE [ BODY ] package_name;

If you omit the BODY keyword, both the package specification and the package body are dropped. In this case, the entire package is dropped. If you specify the BODY keyword, only the package body is dropped. The package specification remains intact. The package_name parameter specifies the identifier of the package to be dropped.

You can use the following statement to drop only the package body of emp_admin.

DROP PACKAGE BODY emp_admin;

You can use the following statement to drop the entire emp_admin package.

DROP PACKAGE emp_admin;