https://ittichaicham.com/wiki/index.php?action=history&feed=atom&title=Compile_All_Objects Compile All Objects - Revision history 2026-06-17T11:45:37Z Revision history for this page on the wiki MediaWiki 1.34.2 https://ittichaicham.com/wiki/index.php?title=Compile_All_Objects&diff=680&oldid=prev Ittichai: Created page with "<pre> SELECT 'alter ' || DECODE(OBJECT_TYPE, 'PACKAGE BODY', 'PACKAGE', OBJECT_TYPE) || ' ' || OWNER || '.' || OBJECT_NAME || ' compile ' || DECODE(OBJECT_TYPE, 'PACKAGE..." 2012-02-16T19:54:32Z <p>Created page with &quot;&lt;pre&gt; SELECT &#039;alter &#039; || DECODE(OBJECT_TYPE, &#039;PACKAGE BODY&#039;, &#039;PACKAGE&#039;, OBJECT_TYPE) || &#039; &#039; || OWNER || &#039;.&#039; || OBJECT_NAME || &#039; compile &#039; || DECODE(OBJECT_TYPE, &#039;PACKAGE...&quot;</p> <p><b>New page</b></p><div>&lt;pre&gt;<br /> SELECT <br /> &#039;alter &#039; ||<br /> DECODE(OBJECT_TYPE, &#039;PACKAGE BODY&#039;, &#039;PACKAGE&#039;, OBJECT_TYPE) || &#039; &#039; ||<br /> OWNER || &#039;.&#039; || OBJECT_NAME || &#039; compile &#039; ||<br /> DECODE(OBJECT_TYPE, &#039;PACKAGE BODY&#039;, &#039;BODY;&#039;, &#039;;&#039;)<br /> FROM <br /> DBA_OBJECTS<br /> WHERE <br /> OBJECT_TYPE NOT IN (&#039;TABLE&#039;, &#039;INDEX&#039;, &#039;SEQUENCE&#039;)<br /> AND OWNER IN (&#039;SCHEMA&#039;)<br /> &lt;/pre&gt;</div> Ittichai