{"id":99,"date":"2013-02-22T17:21:27","date_gmt":"2013-02-22T09:21:27","guid":{"rendered":"http:\/\/weitaoc.com\/?p=99"},"modified":"2013-02-22T17:29:03","modified_gmt":"2013-02-22T09:29:03","slug":"oracle%e5%be%aa%e7%8e%af%e6%8f%92%e5%85%a5%e6%b5%8b%e8%af%95%e6%95%b0%e6%8d%ae","status":"publish","type":"post","link":"http:\/\/weitaoc.com\/?p=99","title":{"rendered":"oracle\u5faa\u73af\u63d2\u5165\u6d4b\u8bd5\u6570\u636e"},"content":{"rendered":"

\u4eca\u5929\u516c\u53f8\u4e00\u6d4b\u8bd5\u7ed9\u4e86\u4e00\u6bb5oracle\u4ee3\u7801\uff0c\u770b\u7684\u5934\u5927\uff1a<\/p>\n

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
<\/div><\/td>
DECLARE<\/span> @TERM_NO INT<\/span>
\n
\nSET<\/span> @TERM_NO =<\/span> 1<\/span> \/*\u8bbe\u7f6e\u53d8\u91cf*\/<\/span>
\n
\nWHILE (<\/span>@TERM_NO <<\/span> 1000<\/span>)<\/span> \/*\u8bbe\u7f6e\u5faa\u73af\u6b21\u6570*\/<\/span>
\n
\nBEGIN<\/span>
\n
\nWAITFOR DELAY '000:00:10'<\/span> \/*\u5ef6\u8fdf\u65f6\u95f410\u79d2*\/<\/span>
\n
\nINSERT<\/span> INTO<\/span> cd_terminal
\n
\n(<\/span>TERM_NO,<\/span> EQUIP_TYPE,<\/span> EQUIP_USE,<\/span> EQUIP_NO,<\/span> EQUIP_NAME,<\/span> ACCEPT_TP,<\/span> BRANCH_NO,<\/span> TERM_STATUS,<\/span> TERM_SIGN_STATUS,<\/span> LAST_LOGIN_DATE,<\/span> BATCH_NO,<\/span> EQUIP_INVESTOR,<\/span> SETUP_DATE,<\/span> SETUP_PERSON,<\/span> MANAGE_PERSON,<\/span> TERM_DESCRIBE,<\/span> BIND_SAM_NUM,<\/span> LAST_KEY_UPDATE,<\/span> LAST_AUTH_DATE,<\/span> USE_WAY,<\/span> CUR_TERM_SEQ,<\/span> MAX_TERM_SEQ,<\/span> TRANSFER_FREQ,<\/span> TRANSFER_SUM,<\/span> CONSUM_SUM,<\/span> CONSUM_FREQ,<\/span> CHARGE_SUM,<\/span> CHARGE_FREQ,<\/span> REMARK,<\/span> TEST_FLAG,<\/span> CRT_SYS_OPR,<\/span> CRT_SYS_DT,<\/span> LST_MOD_SYS_OPR,<\/span> LST_MOD_SYS_DT)<\/span>
\n
\nVALUES<\/span> (<\/span>@TERM_NO,<\/span> '3'<\/span>,<\/span> '3'<\/span>,<\/span> '1'<\/span>,<\/span> '1'<\/span>,<\/span> '01'<\/span>,<\/span> '650202'<\/span>,<\/span> '1'<\/span>,<\/span> ''<\/span>,<\/span> NULL<\/span>,<\/span> ''<\/span>,<\/span> ''<\/span>,<\/span> NULL<\/span>,<\/span> ''<\/span>,<\/span> ''<\/span>,<\/span> ''<\/span>,<\/span> 1<\/span>,<\/span> NULL<\/span>,<\/span> NULL<\/span>,<\/span> ''<\/span>,<\/span> ''<\/span>,<\/span> ''<\/span>,<\/span> NULL<\/span>,<\/span> NULL<\/span>,<\/span> NULL<\/span>,<\/span> NULL<\/span>,<\/span> NULL<\/span>,<\/span> NULL<\/span>,<\/span> ''<\/span>,<\/span> ''<\/span>,<\/span> 'admin '<\/span>,<\/span> to_date(<\/span>'22-02-2013 14:11:15'<\/span>,<\/span> 'dd-mm-yyyy hh24:mi:ss'<\/span>)<\/span>,<\/span> 'admin '<\/span>,<\/span> to_date(<\/span>'22-02-2013 14:11:15'<\/span>,<\/span> 'dd-mm-yyyy hh24:mi:ss'<\/span>)<\/span>)<\/span>
\n
\nSET<\/span> @TERM_NO =<\/span> @TERM_NO +<\/span> 1<\/span>
\n
\nEND<\/span><\/div><\/td><\/tr><\/tbody><\/table><\/div>\n

\u597d\u597d\u6c9f\u901a\u4e00\u4e0b\uff0c\u5176\u5b9e\u4eba\u5bb6\u6d4b\u8bd5\u4e5f\u662f\u6709\u9700\u6c42\u7684\uff0c\u4f5c\u4e3a\u6280\u672f\u4eba\u5458<\u54c8\u54c8\uff0c\u4eca\u5929\u4e0d\u662f\u7f8e\u5de5\u5566>\u600e\u4e48\u4e5f\u5f97\u534f\u8c03\u89e3\u51b3\u4e00\u4e0b\u3002
\n\u9700\u6c42\u662f\u8fd9\u6837\u7684\uff0c\u4eba\u5bb6\u9700\u8981\u505a\u4e00\u5343\u6761\u7684\u6d4b\u8bd5\u6570\u636e\uff0c\u4f46\u662f\u624b\u5de5\u592a\u6162\u4e86<\u7a0b\u5e8f\u733f\u7684\u4ef7\u503c\u4e0d\u5c31\u662f\u8fd9\u4e2a\u4e48>\u5c31\u60f3\u81ea\u52a8\u5316\u5904\u7406\u3002
\n\u597d\u5427\uff0c\u6211\u4eec\u5206\u6790\u4e00\u4e0b\u8fd9\u6bb5\u4ee3\u7801\uff0c\u9996\u5148@\u662f\u600e\u4e48\u56de\u4e8b\uff1f\u663e\u7136\u4eba\u5bb6\u7684\u60f3\u6cd5\u662f\u5b9a\u4e49\u4e00\u4e2a\u53d8\u91cf\uff0c\u597d\u5427\uff0c\u770b\u770b&\u7684\u7528\u6cd5\u5427\u3002<\/p>\n

\n

&\u7b26\u53f7\uff1a\u5728Oracle\u4e2d,&\u7b26\u53f7\u5e38\u7528\u6765\u6307\u51fa\u4e00\u4e2a\u53d8\u91cf\u3002\u4f8b\u5982\uff0c&fox\u662f\u4e00\u4e2a\u53d8\u91cf\uff0c\u7a0d\u5fae\u6709\u70b9\u4e0d\u540c\u7684\u4e00\u79cd&& fox\u3002\u6bcf\u5f53&fox\u51fa\u73b0\u5728Oracle\u811a\u672c\u4e2d\u65f6\uff0c\u90fd\u4f1a\u8981\u6c42\u60a8\u4e3a\u5b83\u63d0\u4f9b\u4e00\u4e2a\u503c\u3002\u800c\u4f7f\u7528&&fox\uff0c\u60a8\u53ea\u9700\u8981\u5728& &fox\u7b2c\u4e00\u6b21\u51fa\u73b0\u65f6\u4e3a\u5b83\u63d0\u4f9b\u53d8\u91cf\u503c\u3002\u5982\u679c\u60f3\u5c06&\u7b26\u53f7\u4f5c\u4e3a\u666e\u901a\u7684\u7b26\u53f7\u4f7f\u7528\uff0c\u5219\u5e94\u8be5\u5173\u95ed\u8fd9\u4e2a\u7279\u6027\u3002\u8981\u60f3\u5173\u95ed\u8fd9\u4e2a\u7279\u6027\uff0c\u53ef\u4ee5\u8fd0\u884c\u4ee5\u4e0b\u7684\u547d\u4ee4\uff1a set define off \uff0c\u8fd9\u662f\u4e00\u4e2aSQLplus\u547d\u4ee4\uff0c\u4e0d\u662f\u4e00\u4e2aSQL\u547d\u4ee4\u3002SQLplus\u8bbe\u7f6e\u4e86SQL\u5728Oracle\u4e2d\u8fd0\u884c\u7684\u73af\u5883\u3002<\/p>\n

\n

\u518d\u8bf4WHILE (@TERM_NO < 1000) \/*\u8bbe\u7f6e\u5faa\u73af\u6b21\u6570*\/\uff0c\u8fd9\u4e2a\uff0c\u6211\u8fd8\u771f\u6ca1\u89c1\u8fc7while\u53ef\u4ee5\u8fd9\u6837\u7528\u3002\u597d\u5427\uff0c\u8bed\u6cd5\u4e5f\u9519\u4e86\u3002<\/p>\n

\u518d\u8bf4\u8fd9\u4e2a\u7f16\u7801\u683c\u5f0f\u7684\u95ee\u9898\uff0c\u4eb2\uff0c\u4f60\u8981\u6211\u600e\u4e48\u7ed9\u4f60\u89e3\u91ca\u201c;\u201d\u7684\u7528\u6cd5\u5462\uff0c\u597d\u5427\uff0c\u4e0d\u89e3\u91ca\u4e86\u3002<\/p>\n

\u5c31\u76f4\u63a5\u4e0a\u81ea\u5df1\u7684\u6d4b\u8bd5\u4ee3\u7801\u5427\u3002<\/p>\n

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
<\/div><\/td>
DECLARE<\/span> TERM_NO INT<\/span> ;
\n
\nBEGIN<\/span>
\n
\nTERM_NO:=<\/span> 1<\/span> ; \/*\u8bbe\u7f6e\u53d8\u91cf*\/<\/span>
\n
\nWHILE TERM_NO\u00a0<<\/span> 1001<\/span> loop \/*\u8bbe\u7f6e\u5faa\u73af\u6b21\u6570*\/<\/span>
\n
\nDBMS_LOCK.<\/span>SLEEP(<\/span>10<\/span>)<\/span>; \/*\u5ef6\u8fdf\u65f6\u95f410\u79d2*\/<\/span>
\n
\nINSERT<\/span> INTO<\/span> ACCT_DICTCODE
\n
\n(<\/span>ID,<\/span> NAME,<\/span> DICTDESC,<\/span> DICTVALUE)<\/span>
\n
\nVALUES<\/span> (<\/span>TERM_NO,<\/span> '3'<\/span>,<\/span> '3'<\/span>,<\/span> '1'<\/span>)<\/span>;
\n
\nTERM_NO :=<\/span> TERM_NO +<\/span> 1<\/span> ;
\n
\nEND<\/span> loop;
\n
\nEND<\/span>;<\/div><\/td><\/tr><\/tbody><\/table><\/div>\n

\u6ca1\u4ec0\u4e48\u6280\u672f\u6027\uff0c\u81ea\u5df1mark\u4e00\u4e0b\u5427\u3002<\/p>\n

\"oracle\"<\/a>

oracle<\/p><\/div>\n

 <\/p>\n

\u8f6c\u8f7d\u8bf7\u6ce8\u660e\uff1a\u8ff7\u8def\u7684\u8001\u9f20<\/a> » oracle\u5faa\u73af\u63d2\u5165\u6d4b\u8bd5\u6570\u636e<\/a><\/p>","protected":false},"excerpt":{"rendered":"

\u4eca\u5929\u516c\u53f8\u4e00\u6d4b\u8bd5\u7ed9\u4e86\u4e00\u6bb5oracle\u4ee3\u7801\uff0c\u770b\u7684\u5934\u5927\uff1a 12345678910111213141516171819DECLARE @TERM_NO INT SET @TERM_NO = 1 \/*\u8bbe\u7f6e\u53d8\u91cf*\/ WHILE (@TERM_NO &lt […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[27],"tags":[29,28],"class_list":["post-99","post","type-post","status-publish","format-standard","hentry","category-database","tag-oracle","tag-sql"],"views":3156,"_links":{"self":[{"href":"http:\/\/weitaoc.com\/index.php?rest_route=\/wp\/v2\/posts\/99","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/weitaoc.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/weitaoc.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/weitaoc.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/weitaoc.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=99"}],"version-history":[{"count":0,"href":"http:\/\/weitaoc.com\/index.php?rest_route=\/wp\/v2\/posts\/99\/revisions"}],"wp:attachment":[{"href":"http:\/\/weitaoc.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=99"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/weitaoc.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=99"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/weitaoc.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=99"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}