how to drop package in oracle
How to drop only the body of a package in Oracle? If you want to drop only the body of the package, you need to specify the BODY keyword. If you omit the BODY keyword, then the statement drops both the body and specification of the package. Orac