DROP PACKAGE [IF EXISTS] [ db_name . ] package_name
DROP PACKAGE statement can be used when Oracle SQL_MODE is set.
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.