Deletes a package.

Syntax

DROP PACKAGE [ BODY ] name

Description

You can use the DROP PACKAGE command to drop an existing package. To run this command on a package, you must be a superuser or the owner of the package. If you specify BODY, only the package body is deleted, and the package specification is not dropped. If you omit BODY, both the package specification and body are deleted.

Parameters

ParameterDescription
Parameter Description
name The name of a package to be deleted. The name can be schema-qualified.

Examples

Delete the emp_admin package: 

DROP PACKAGE emp_admin;