Syntax

DROP PACKAGE [IF EXISTS]  [ db_name . ] package_name

Description

The DROP PACKAGE statement can be used when Oracle SQL_MODE is set.

The DROP PACKAGE statement drops a stored package entirely:

• Drops the package specification (earlier created using the CREATE PACKAGE statement).
• Drops the package implementation, if the implementation was already created using the CREATE PACKAGE BODY statement.

See Also

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