All pages
Powered by GitBook
1 of 1

Loading...

DROP PACKAGE

Remove a stored package completely. This command deletes both the package specification (interface) and its body (implementation) from the database.

Syntax

DROP PACKAGE [IF EXISTS]  [ db_name . ] package_name

Description

The DROP PACKAGE statement can be used when is set.

The DROP PACKAGE statement drops a stored package entirely:

  • Drops the package specification (earlier created using the statement).

  • Drops the package implementation, if the implementation was already created using the statement.

See Also

This page is licensed: CC BY-SA / Gnu FDL

CREATE PACKAGE
CREATE PACKAGE BODY
SHOW CREATE PACKAGE
CREATE PACKAGE
CREATE PACKAGE BODY
DROP PACKAGE BODY
Oracle SQL_MODE
Oracle SQL_MODE