{"id":2852,"date":"2018-02-03T15:03:33","date_gmt":"2018-02-03T06:03:33","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=2852"},"modified":"2018-02-03T15:38:22","modified_gmt":"2018-02-03T06:38:22","slug":"invalid-%ec%98%a4%eb%b8%8c%ec%a0%9d%ed%8a%b8%ec%9d%98-vaild-%ec%83%81%ed%83%9c-%eb%b3%80%ea%b2%bd%ec%9d%84-%ed%95%9c-%eb%b0%a9%ec%97%90-%ed%95%b4%ec%a3%bc%eb%8a%94-sql","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=2852","title":{"rendered":"Invalid \uc624\ube0c\uc81d\ud2b8\uc758 Vaild \uc0c1\ud0dc \ubcc0\uacbd\uc744  \ud55c \ubc29\uc5d0 \ud574\uc8fc\ub294 SQL"},"content":{"rendered":"<p>&nbsp;<\/p>\n<pre class=\"lang:plsql decode:true \">invalid -&gt; vaild \uc0c1\ud0dc \ubcc0\uacbd \ud55c \ubc29 SQL\r\n\r\nSELECT distinct 'ALTER '||OBJECT_TYPE||'  '||OWNER||'.'|| OBJECT_NAME || ' COMPILE ;' as comp_command\r\nFROM DBA_OBJECTS\r\nWHERE STATUS = 'INVALID' \r\n  and Object_Type not in ( 'PACKAGE BODY','SYNONYM') \r\nunion\r\nSELECT distinct 'ALTER PACKAGE ' ||OWNER||'.'|| OBJECT_NAME || ' COMPILE BODY;' as comp_command\r\nFROM DBA_OBJECTS\r\nWHERE STATUS = 'INVALID' \r\n  and Object_Type in ( 'PACKAGE BODY')  ;\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>&nbsp; invalid -&gt; vaild \uc0c1\ud0dc \ubcc0\uacbd \ud55c \ubc29 SQL SELECT distinct &#8216;ALTER &#8216;||OBJECT_TYPE||&#8217; &#8216;||OWNER||&#8217;.&#8217;|| OBJECT_NAME || &#8216; COMPILE ;&#8217; as comp_command FROM DBA_OBJECTS WHERE STATUS = &#8216;INVALID&#8217; and Object_Type not in ( &#8216;PACKAGE BODY&#8217;,&#8217;SYNONYM&#8217;) union SELECT distinct &#8216;ALTER PACKAGE &#8216; ||OWNER||&#8217;.&#8217;|| OBJECT_NAME || &#8216; COMPILE BODY;&#8217; as comp_command FROM DBA_OBJECTS WHERE STATUS = &#8216;INVALID&#8217; and [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":2857,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"spay_email":""},"categories":[3],"tags":[4,943],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/haisins.synology.me\/wordpress\/wp-content\/uploads\/2018\/02\/oracle-business-intelligence.jpg?fit=973%2C615","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/2852"}],"collection":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2852"}],"version-history":[{"count":1,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/2852\/revisions"}],"predecessor-version":[{"id":2853,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/2852\/revisions\/2853"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/media\/2857"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2852"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2852"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2852"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}