{"id":1603,"date":"2024-05-08T15:07:36","date_gmt":"2024-05-08T07:07:36","guid":{"rendered":"http:\/\/oneai.eu.org\/?p=1603"},"modified":"2024-05-08T15:07:36","modified_gmt":"2024-05-08T07:07:36","slug":"%e7%bb%99%e4%b8%80%e4%b8%aa%e7%94%a8%e4%b8%8b%e7%9a%84%e6%89%80%e6%9c%89%e8%a1%a8%e8%b5%8b%e6%9d%83%e7%bb%99%e5%8f%a6%e4%b8%80%e4%b8%aa%e7%94%a8%e6%88%b7-sql","status":"publish","type":"post","link":"https:\/\/oneai.eu.org\/?p=1603","title":{"rendered":"\u7ed9\u4e00\u4e2a\u7528\u4e0b\u7684\u6240\u6709\u8868\u8d4b\u6743\u7ed9\u53e6\u4e00\u4e2a\u7528\u6237.sql"},"content":{"rendered":"<pre><code class=\"language-sql\">set heading off;\nset feedback off;\nspool &quot;GRNAT_TO_HSCDIFF_PRIVALE.SQL&quot;;\nselect &#039;grant select,delete,update,insert on &#039;||table_name||&#039; to  hscdiff;&#039; from user_tables;\nspool off; \nset heading on;\nset feedback on;\nspool &#039;GRNAT_TO_HSCDIFF_PRIVALE.LOG&#039;;\n@GRNAT_TO_HSCDIFF_PRIVALE.SQL;\nspool off;\nexit;<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>set heading off; set feedback off; spool &quot;GRNAT_TO_HSCDIFF_PRIVALE.SQL&quot;; select &#039;grant select,delete,update,insert on &#039;||table_name||&#039; to hscdiff;&#039; from user_tables; spool off; set heading on; set feedback on; spool &#039;GRNAT_TO_HSCDIFF_PRIVALE.LOG&#039;; @GRNAT_TO_HSCDIFF_PRIVALE.SQL; spool off; exit;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_eb_attr":"","footnotes":""},"categories":[88,82,101],"tags":[],"class_list":["post-1603","post","type-post","status-publish","format-standard","hentry","category-oracle","category-82","category-101"],"_links":{"self":[{"href":"https:\/\/oneai.eu.org\/index.php?rest_route=\/wp\/v2\/posts\/1603","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/oneai.eu.org\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/oneai.eu.org\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/oneai.eu.org\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/oneai.eu.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1603"}],"version-history":[{"count":1,"href":"https:\/\/oneai.eu.org\/index.php?rest_route=\/wp\/v2\/posts\/1603\/revisions"}],"predecessor-version":[{"id":1604,"href":"https:\/\/oneai.eu.org\/index.php?rest_route=\/wp\/v2\/posts\/1603\/revisions\/1604"}],"wp:attachment":[{"href":"https:\/\/oneai.eu.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1603"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/oneai.eu.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1603"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/oneai.eu.org\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1603"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}