Oracle PL/SQL: PACKAGES: alter package -

Quick Search:

Oracle PL/SQL: PACKAGES: alter package

Jump to:

Category: >> Oracle PL/SQL >> PACKAGES: alter package

<< last

next >>

Snippet Name: PACKAGES: alter package

Description:

Also see:
» PACKAGES: initialization
» PACKAGES: related queries
» PACKAGES: overloading
» PACKAGES: one function
» PACKAGES: one procedure
» UTL_FILE file write to file example
» Create Package
» UTL_FILE import data

Comment: (none)

Language: PL/SQL
Highlight Mode: PLSQL
Last Modified: March 10th, 2009

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;