{"id":1624,"date":"2016-04-10T14:20:53","date_gmt":"2016-04-10T06:20:53","guid":{"rendered":"http:\/\/www.821121.com\/?p=1624"},"modified":"2022-04-21T14:26:05","modified_gmt":"2022-04-21T06:26:05","slug":"oracle%e4%b8%adfor%e5%be%aa%e7%8e%af%e7%94%a8%e6%b3%95","status":"publish","type":"post","link":"http:\/\/www.821121.com\/?p=1624","title":{"rendered":"Oracle\u4e2dfor\u5faa\u73af\u7528\u6cd5"},"content":{"rendered":"<h2>1.\u5728oracle\u4e2d\u4f7f\u7528for in\u5f62\u5f0f<\/h2>\n<pre><code class=\"language-sql\">declare i number;--\u58f0\u660e\u53d8\u91cf\nbegin \n  i := 1;--\u8bbe\u7f6e\u521d\u59cb\u503c\n  for i in 1 .. 5 loop --\u7531\u4f4e\u5230\u9ad8\u5faa\u73af\u8bbe\u7f6ei\u503c\n  insert into child values(i); --\u5411\u8868\u4e2d\u6dfb\u52a0\u5f53\u524di\u503c\n  end loop; \n  commit;\nend;\n\/<\/code><\/pre>\n<h2>2.REVERSE\u5173\u952e\u5b57\u5b9e\u73b0\u4ece\u9ad8\u5230\u4f4e\u8fdb\u884c\u5faa\u73af<\/h2>\n<pre><code class=\"language-sql\">declare i number;--\u58f0\u660e\u53d8\u91cf\nbegin \n  i := 1;--\u8bbe\u7f6e\u521d\u59cb\u503c\n  for i in reverse 1 .. 5 loop --\u4f7f\u7528reverse\u7531\u9ad8\u5230\u4f4e\u5faa\u73af\u8bbe\u7f6ei\u503c\n  insert into child values(i); --\u5411\u8868\u4e2d\u6dfb\u52a0\u5f53\u524di\u503c\n  end loop; \n  commit;\nend;\n\/<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>1.\u5728oracle\u4e2d\u4f7f\u7528for in\u5f62\u5f0f decl<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-1624","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/1624","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1624"}],"version-history":[{"count":4,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/1624\/revisions"}],"predecessor-version":[{"id":1708,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/1624\/revisions\/1708"}],"wp:attachment":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1624"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1624"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1624"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}