{"id":1220,"date":"2010-01-15T05:23:43","date_gmt":"2010-01-15T09:23:43","guid":{"rendered":"http:\/\/www.killtest.hk\/?p=1220"},"modified":"2010-07-22T05:14:57","modified_gmt":"2010-07-22T09:14:57","slug":"oracle-02","status":"publish","type":"post","link":"https:\/\/www.killtest.hk\/index.php\/oracle\/oracle-02\/","title":{"rendered":"oracle\u6279\u91cf\u63d2\u5165\u6e2c\u8a66\u6578\u64da\u7684\u65b9\u6cd5"},"content":{"rendered":"<p><a href=\"http:\/\/www.killtest.net\/Oracle\/\" target=\"_blank\">oracle<\/a>\u600e\u6a23\u6279\u91cf\u63d2\u5165\u6e2c\u8a66\u6578\u64da<br \/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u58f9\u3001Test Windos\u65b9\u5f0f<\/p>\n<p>\u3000\u3000declare<\/p>\n<p>\u3000\u3000maxrecords constant int:=100000;<\/p>\n<p>\u3000\u3000i int :=1;<\/p>\n<p>\u3000\u3000begin<\/p>\n<p>\u3000\u3000for i in 1..maxrecords loop<\/p>\n<p>\u3000\u3000insert into test2<\/p>\n<p>\u3000\u3000(id, name)<\/p>\n<p>\u3000\u3000values<\/p>\n<p>\u3000\u3000(test2_seq.nextval, to_char(9999+i));<\/p>\n<p>\u3000\u3000end loop;<\/p>\n<p>\u3000\u3000dbms_output.put_line(\u2019 \u6210\u529f\u9304\u5165\u6578\u64da!\u2019);<\/p>\n<p>\u3000\u3000commit;<\/p>\n<p>\u3000\u3000end;<\/p>\n<p>\u3000\u3000\u4e8c\u3001\u5f9e\u5df2\u6709\u8868\u4e2d\u5f80\u5165\u53e6\u58f9\u5f35\u8868\u5c0e\u6578\u64da<\/p>\n<p>\u3000\u3000create or replace procedure TestProc is<\/p>\n<p>\u3000\u3000begin<\/p>\n<p>\u3000\u3000for c in(select id, name from test2) loop<\/p>\n<p>\u3000\u3000insert into test<\/p>\n<p>\u3000\u3000(id,<\/p>\n<p>\u3000\u3000name)<\/p>\n<p>\u3000\u3000values<\/p>\n<p>\u3000\u3000(test_seq.nextval, c.name);<\/p>\n<p>\u3000\u3000end loop;<\/p>\n<p>\u3000\u3000end TestProc;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>oracle\u600e\u6a23\u6279\u91cf\u63d2\u5165\u6e2c\u8a66\u6578\u64da \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u58f9\u3001Test Windos\u65b9\u5f0f \u3000\u3000declare \u3000\u3000ma [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[2748,458],"class_list":["post-1220","post","type-post","status-publish","format-standard","hentry","category-oracle","tag-oracle","tag-458"],"_links":{"self":[{"href":"https:\/\/www.killtest.hk\/index.php\/wp-json\/wp\/v2\/posts\/1220","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.killtest.hk\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.killtest.hk\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.killtest.hk\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.killtest.hk\/index.php\/wp-json\/wp\/v2\/comments?post=1220"}],"version-history":[{"count":0,"href":"https:\/\/www.killtest.hk\/index.php\/wp-json\/wp\/v2\/posts\/1220\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.killtest.hk\/index.php\/wp-json\/wp\/v2\/media?parent=1220"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.killtest.hk\/index.php\/wp-json\/wp\/v2\/categories?post=1220"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.killtest.hk\/index.php\/wp-json\/wp\/v2\/tags?post=1220"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}