Packages: Alter Package

Description:

Recompile PACKAGE
ALTER PACKAGE <package_name> COMPILE;
 
SELECT object_name
FROM user_objects
WHERE object_type = 'PACKAGE';
 
ALTER PACKAGE test_pkg COMPILE;
 
 
======================
 
DROP PACKAGE Header AND BODY
 
DROP PACKAGE test_pkg;
 
 
======================
 
DROP PACKAGE BODY Only
 
DROP PACKAGE BODY test_pkg;

Enjoyed this post? Share it!

 

Leave a comment

Your email address will not be published.