Thursday, December 11, 2008

Package compilation commands

Which version of 'alter package' compiles just the header? the body? both?

ALTER PACKAGE package_name COMPILE - compiles the header and the body
ALTER PACKAGE package_name COMPILE PACKAGE - compiles just the header
ALTER PACKAGE package_name COMPILE BODY - compiles just the body

No comments: