If I deploy N pl / sql packages to Oracle DB, can I make them compile atomic, that is, the changes in these packages will be applied after all the packages have been compiled successfully?
Since the packages are editable, you can see the version change based on the version . This will give you the ability to automatically switch between versions of your packages.
CREATE OR REPLACE ALTER PACKAGE DDL, DDL- . COMMIT DDL; DDL .
, . , - . PL/SQL (, ) . PL/SQL ( -, deploymenet). , - , .
(, , 11gR2).
Another option is PL / SQL Developer , which can be configured to perform test compilation (compiles the package to an alternate name) before the "real" compilation.