{"id":1605,"date":"2024-05-08T15:09:23","date_gmt":"2024-05-08T07:09:23","guid":{"rendered":"http:\/\/oneai.eu.org\/?p=1605"},"modified":"2024-05-08T15:09:23","modified_gmt":"2024-05-08T07:09:23","slug":"%e5%b0%86%e4%b8%80%e5%bc%a0%e8%a1%a8%e4%b8%ad%e7%ac%a6%e5%90%88%e6%9d%a1%e4%bb%b6%e7%9a%84%e6%95%b0%e6%8d%ae%e6%8f%92%e5%85%a5%e5%8f%a6%e4%b8%80%e5%bc%a0%e8%a1%a8","status":"publish","type":"post","link":"https:\/\/oneai.eu.org\/?p=1605","title":{"rendered":"\u5c06\u4e00\u5f20\u8868\u4e2d\u7b26\u5408\u6761\u4ef6\u7684\u6570\u636e\u63d2\u5165\u53e6\u4e00\u5f20\u8868"},"content":{"rendered":"<pre><code class=\"language-sql\">exp dbuser\/paswd@dbname tables=(HSC_ROUTE_NOSECT) query=&quot;where AREACODE =&#039;ZS&#039;&quot; file=HSC_ROUTE_NOSECT_ZS.dmp log=HSC_ROUTE_NOSECT_ZS.log\n\nGDHSC_YC.HSC_ROUTE_NOSECT\n\u5b9e\u4f8b\uff1a\u5c06\u4e00\u5f20\u8868\u4e2d\u7b26\u5408\u6761\u4ef6\u7684\u6570\u636e\u63d2\u5165\u53e6\u4e00\u5f20\u8868\u3002\ncreate table HSC_ROUTE_NOSECT_ZS as select * from  GDHSC_YC.HSC_ROUTE_NOSECT where  AREACODE =&#039;ZS&#039;;\ncreate table HSC_ROUTE_NOSECT_ALL as select * from  GDHSC_YC.HSC_ROUTE_NOSECT where  AREACODE &lt;&gt;&#039;ZS&#039;;\n\ninsert into HSC_ROUTE_NOSECT_ALL select * from  GDHSC_YC.HSC_ROUTE_NOSECT_ZS where rownum&lt;598\n\u7ed3\u679c\uff0cHSC_ROUTE_NOSECT_ALL \u8868\u4e2d\n--------------\n\n dbuser\/dbpass@dbname\n\/*\ninsert into HSC_ROUTE_NOSECT select HSC_ROUTE_NOSECT_seq.nextval,BEGINNO,ENDNO,HSCNODE,ABMNODE,STATUS,AREACODE,INTIME,REGION,CBENODE from  GDHSC_YC.HSC_ROUTE_NOSECT_ZS where rownum&lt;598;\n\nalter table HSC_ROUTE_NOSECT add CBENODE  NUMBER(10);\n\n RECID   \n BEGINNO \n ENDNO   \n HSCNODE \n ABMNODE \n STATUS  \n AREACODE\n INTIME  \n REGION \n CBENODE\n<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>exp dbuser\/paswd@dbname tables=(HSC_ROUTE_NOSECT) query=&quot;where AREACODE =&#039;ZS&#039;&quot; file=HSC_ROUTE_NOSECT_ZS.dmp log=HSC_ROUTE_NOSECT_ZS.log GDHSC_YC.HSC_ROUTE_NOSECT \u5b9e\u4f8b\uff1a\u5c06\u4e00\u5f20\u8868\u4e2d\u7b26\u5408\u6761\u4ef6\u7684\u6570\u636e\u63d2\u5165\u53e6\u4e00\u5f20\u8868\u3002 create table HSC_ROUTE_NOSECT_ZS as select * from GDHSC_YC.HSC_ROUTE_NOSECT where AREACODE =&#039;ZS&#039;; create table HSC_ROUTE_NOSECT_ALL as select * from GDHSC_YC.HSC_ROUTE_NOSECT where AREACODE &lt;&gt;&#039;ZS&#039;; insert into HSC_ROUTE_NOSECT_ALL select * from GDHSC_YC.HSC_ROUTE_NOSECT_ZS where rownum&lt;598 \u7ed3\u679c\uff0cHSC_ROUTE_NOSECT_ALL \u8868\u4e2d &#8212;&#8212;&#8212;&#8212;&#8211; dbuser\/dbpass@dbname \/* insert into HSC_ROUTE_NOSECT select HSC_ROUTE_NOSECT_seq.nextval,BEGINNO,ENDNO,HSCNODE,ABMNODE,STATUS,AREACODE,INTIME,REGION,CBENODE from GDHSC_YC.HSC_ROUTE_NOSECT_ZS where rownum&lt;598; alter table HSC_ROUTE_NOSECT add CBENODE NUMBER(10); RECID BEGINNO ENDNO HSCNODE ABMNODE STATUS AREACODE INTIME REGION CBENODE<\/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],"tags":[],"class_list":["post-1605","post","type-post","status-publish","format-standard","hentry","category-oracle"],"_links":{"self":[{"href":"https:\/\/oneai.eu.org\/index.php?rest_route=\/wp\/v2\/posts\/1605","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=1605"}],"version-history":[{"count":1,"href":"https:\/\/oneai.eu.org\/index.php?rest_route=\/wp\/v2\/posts\/1605\/revisions"}],"predecessor-version":[{"id":1606,"href":"https:\/\/oneai.eu.org\/index.php?rest_route=\/wp\/v2\/posts\/1605\/revisions\/1606"}],"wp:attachment":[{"href":"https:\/\/oneai.eu.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1605"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/oneai.eu.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1605"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/oneai.eu.org\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1605"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}