{"id":536,"date":"2015-06-05T17:28:56","date_gmt":"2015-06-05T09:28:56","guid":{"rendered":"http:\/\/www.royalwzy.com\/?p=536"},"modified":"2015-09-09T21:48:07","modified_gmt":"2015-09-09T13:48:07","slug":"%e5%af%bc%e5%85%a5%e5%af%bc%e5%87%ba%e5%b7%a5%e5%85%b704-oralce%e6%95%b0%e6%8d%ae%e5%ba%93%e4%b8%ad%e8%a1%a8%e6%95%b0%e6%8d%ae%e5%af%bc%e5%87%ba%e4%b8%batxt%e6%a0%bc%e5%bc%8f","status":"publish","type":"post","link":"http:\/\/www.royalwzy.com\/?p=536","title":{"rendered":"\u5bfc\u5165\u5bfc\u51fa\u5de5\u517704–Oralce\u6570\u636e\u5e93\u4e2d\u8868\u6570\u636e\u5bfc\u51fa\u4e3aTXT\u683c\u5f0f"},"content":{"rendered":"

Oracle\u6570\u636e\u5e93\u4e2d\u8868\u6570\u636e\u5bfc\u51fa\u4e3aTXT\u683c\u5f0f<\/p>\n

\n
    \n
  1. \u4f7f\u7528SPOOL\u547d\u4ee4\u628a\u7ed3\u679c\u8f93\u51fa\u5230\u6587\u672c\u4e2d;<\/li>\n
  2. \u4f7f\u7528\u7f16\u5199\u7684C\u8bed\u8a00\u7684\u811a\u672c;<\/li>\n<\/ol>\n
    ——————————-\u00a0\u4f7f\u7528SPOOL\u547d\u4ee4\u628a\u7ed3\u679c\u8f93\u51fa\u5230\u6587\u672c\u4e2d\u00a0——————————-<\/div>\n<\/div>\n
    — 1.\u7f16\u5199\u811a\u672c\u4e3a\/tmp\/orauldr.sql;<\/div>\n
    set echo on\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 — \u662f\u5426\u663e\u793a\u6267\u884c\u7684\u547d\u4ee4\u5185\u5bb9
    \nset feedback off\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 — \u662f\u5426\u663e\u793a\u63d0\u793a\u7b26,\u5373\u591a\u5c11\u6761\u8bb0\u5f55\u6253\u4e00\u4e2a\u70b9
    \nset heading off\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 — \u662f\u5426\u663e\u793a\u5b57\u6bb5\u7684\u540d\u79f0
    \nset verify off\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 — \u662f\u5426\u663e\u793a\u66ff\u4ee3\u53d8\u91cf\u88ab\u66ff\u4ee3\u524d\u540e\u7684\u8bed\u53e5
    \nset trimspool off\u00a0\u00a0\u00a0\u00a0\u00a0 — \u53bb\u5b57\u6bb5\u7a7a\u683c
    \nset pagesize 1000\u00a0\u00a0\u00a0\u00a0\u00a0 — \u9875\u9762\u5927\u5c0f
    \nset linesize 50 \u00a0 \u00a0 \u00a0 \u00a0— linesize\u8bbe\u5b9a\u5c3d\u91cf\u6839\u636e\u9700\u8981\u6765\u8bbe\u5b9a\uff0c\u5927\u4e86\u751f\u6210\u7684\u6587\u4ef6\u4e5f\u5927
    \ndefine fil= ‘\/tmp\/exp.txt’
    \nprompt *** Spooling to &fil
    \nspool &fil
    \nselect col1 || ‘,’ || username || ‘,’ || ‘,’|| password from tbtest; — \u683c\u5f0f\u81ea\u5df1\u62fc\u63a5\u51fa\u6765,\u6bd4\u8f83\u7075\u6d3b,\u5bfc\u5165\u4e5f\u4e0d\u5bb9\u6613\u51fa\u9519
    \nspool off;<\/div>\n
    <\/div>\n
    — 2.\u5728SQL*PLUS\u4e2d\u6267\u884c;<\/div>\n
    SQL>@ \/tmp\/orauldr.sql;<\/div>\n
    ——————————-\u00a0\u4f7f\u7528SPOOL\u547d\u4ee4\u628a\u7ed3\u679c\u8f93\u51fa\u5230\u6587\u672c\u4e2d\u00a0——————————-<\/div>\n
    <\/div>\n
    ——————————-\u00a0\u4f7f\u7528\u7f16\u5199\u7684C\u8bed\u8a00\u7684\u811a\u672c\u00a0——————————-<\/div>\n
    \u7b2c\u4e09\u65b9\u4f7f\u7528C\u8bed\u8a00\u5199\u7684\u5de5\u5177\u86ee\u591a\u7684\uff0c\u53ef\u4ee5\u8054\u7cfbsonne.k.wang@gmailcom\u4ea4\u6d41;<\/div>\n
    ——————————-\u00a0\u4f7f\u7528\u7f16\u5199\u7684C\u8bed\u8a00\u7684\u811a\u672c\u00a0——————————-<\/div>\n","protected":false},"excerpt":{"rendered":"

    Oracle\u6570\u636e\u5e93\u4e2d\u8868\u6570\u636e\u5bfc\u51fa\u4e3aTXT\u683c\u5f0f \u4f7f\u7528SPOOL\u547d\u4ee4\u628a\u7ed3\u679c\u8f93\u51fa\u5230\u6587\u672c\u4e2d; \u4f7f\u7528\u7f16\u5199\u7684C\u8bed\u8a00\u7684\u811a\u672c; […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6],"tags":[7,34],"class_list":["post-536","post","type-post","status-publish","format-standard","hentry","category-oracle","tag-dw","tag-oracle"],"_links":{"self":[{"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/posts\/536","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=536"}],"version-history":[{"count":1,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/posts\/536\/revisions"}],"predecessor-version":[{"id":898,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/posts\/536\/revisions\/898"}],"wp:attachment":[{"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=536"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=536"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=536"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}