{"id":1609,"date":"2024-05-08T15:12:52","date_gmt":"2024-05-08T07:12:52","guid":{"rendered":"http:\/\/oneai.eu.org\/?p=1609"},"modified":"2024-05-08T15:12:52","modified_gmt":"2024-05-08T07:12:52","slug":"%e6%af%8f%e5%88%86%e9%92%9f%e5%a4%84%e7%90%86%e4%b8%9a%e5%8a%a1%e7%ac%94%e6%95%b0","status":"publish","type":"post","link":"https:\/\/oneai.eu.org\/?p=1609","title":{"rendered":"\u6bcf\u5206\u949f\u5904\u7406\u4e1a\u52a1\u7b14\u6570"},"content":{"rendered":"<pre><code class=\"language-sql\">alter session Enable parallel dml; --\u6253\u5f00\u5e76\u53d1\n\nSelect \/*+ parallel(a,12) *\/\n To_Char(Createtime, &#039;yyyymmddhh24mi&#039;), Count(*)\nFrom Hsc_Au_Compdetal a\nWhere a.Difftype = &#039;ROW_DIFF&#039; And a.Createtime &gt; To_Date(&#039;2012-09-19 00:00:00&#039;, &#039;yyyy-mm-dd hh24:mi:ss&#039;) And\n                        a.Createtime &lt; To_Date(&#039;2012-09-20 00:00:00&#039;, &#039;yyyy-mm-dd hh24:mi:ss&#039;)\nGroup By To_Char(a.Createtime, &#039;yyyymmddhh24mi&#039;)\nOrder By To_Char(a.Createtime, &#039;yyyymmddhh24mi&#039;);<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>alter session Enable parallel dml; &#8211;\u6253\u5f00\u5e76\u53d1 Select \/*+ parallel(a,12) *\/ To_Char(Createtime, &#039;yyyymmddhh24mi&#039;), Count(*) From Hsc_Au_Compdetal a Where a.Difftype = &#039;ROW_DIFF&#039; And a.Createtime &gt; To_Date(&#039;2012-09-19 00:00:00&#039;, &#039;yyyy-mm-dd hh24:mi:ss&#039;) And a.Createtime &lt; To_Date(&#039;2012-09-20 00:00:00&#039;, &#039;yyyy-mm-dd hh24:mi:ss&#039;) Group By To_Char(a.Createtime, &#039;yyyymmddhh24mi&#039;) Order By To_Char(a.Createtime, &#039;yyyymmddhh24mi&#039;);<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_eb_attr":"","footnotes":""},"categories":[88,82,101],"tags":[],"class_list":["post-1609","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\/1609","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=1609"}],"version-history":[{"count":1,"href":"https:\/\/oneai.eu.org\/index.php?rest_route=\/wp\/v2\/posts\/1609\/revisions"}],"predecessor-version":[{"id":1610,"href":"https:\/\/oneai.eu.org\/index.php?rest_route=\/wp\/v2\/posts\/1609\/revisions\/1610"}],"wp:attachment":[{"href":"https:\/\/oneai.eu.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1609"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/oneai.eu.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1609"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/oneai.eu.org\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1609"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}