DROP PACKAGE v16
Name
DROP PACKAGE — Remove a package.
Synopsis
DROP PACKAGE [ BODY ] <name>
Description
DROP PACKAGE drops an existing package. To execute this command, you must be a superuser or the owner of the package. Specify BODY to remove only the package body without dropping the package specification. Omit BODY to remove both the package specification and body.
Parameters
name
The name (optionally schema-qualified) of a package to remove.
Examples
This example removes the emp_admin package:
DROP PACKAGE emp_admin;