Showing posts with label Package compilation commands. Show all posts
Showing posts with label Package compilation commands. Show all posts

Monday, 9 May 2011

Package compilation commands


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