Use DROP PACKAGE to delete a package body, or both the package specification and body together.
Syntax
DROP PACKAGE [ BODY ] package_name;| Parameter | Description |
|---|---|
BODY | Optional. If specified, only the package body is deleted; the package specification remains. If omitted, both the package specification and body are deleted. |
package_name | The identifier of the package to delete. |
Drop a package body
To delete only the package body while keeping the package specification intact:
DROP PACKAGE BODY emp_admin;Drop an entire package
To delete both the package specification and body:
DROP PACKAGE emp_admin;