April 1999
Intermediate to advanced
584 pages
23h 17m
English
DROP PACKAGE
DROP PACKAGE [BODY][schema.]package_name
Removes a package ( package_name) from the database.
Specifies that only the package body is to be dropped. If this keyword is omitted, both the package body and specification will be removed.
The package to be dropped must be in your schema, or you must have the DROP ANY PROCEDURE privilege to remove a package from another schema.
The following example removes the package salcalc from the database:
DROP PACKAGE salcalc
Read now
Unlock full access