{"id":15647,"date":"2023-12-04T21:30:26","date_gmt":"2023-12-04T13:30:26","guid":{"rendered":"https:\/\/wx.kaifamiao.info\/?p=15647"},"modified":"2023-12-04T21:31:16","modified_gmt":"2023-12-04T13:31:16","slug":"oracle-zhong-de-you-biao-zai-cun-chu-guo-cheng-li-2","status":"publish","type":"post","link":"http:\/\/wx.kaifamiao.info\/index.php\/2023\/12\/04\/oracle-zhong-de-you-biao-zai-cun-chu-guo-cheng-li-2\/","title":{"rendered":"Oracle \u4e2d\u7684\u6e38\u6807\u5728\u5b58\u50a8\u8fc7\u7a0b\u91cc\u662f\u653e\u5728 begin \u4e0e end \u7684\u91cc\u9762\u8fd8\u662f\u5916\u9762\uff1f"},"content":{"rendered":"

\u5728Oracle\u5b58\u50a8\u8fc7\u7a0b\u4e2d\uff0c\u6e38\u6807\u901a\u5e38\u662f\u653e\u5728BEGIN<\/code>\u548cEND<\/code>\u8bed\u53e5\u5757\u5185\u90e8\u5b9a\u4e49\u548c\u4f7f\u7528\u7684\u3002\u6e38\u6807\u7684\u58f0\u660e\u548c\u4f7f\u7528\u4e00\u822c\u9075\u5faa\u4ee5\u4e0b\u6d41\u7a0b\uff1a<\/p>\n

    \n
  1. \u6e38\u6807\u58f0\u660e\uff1a<\/strong>\n
      \n
    • \u6e38\u6807\u901a\u5e38\u5728BEGIN<\/code>\u5757\u7684\u5f00\u5934\u90e8\u5206\u58f0\u660e\uff0c\u4f8b\u5982\u5728\u5b58\u50a8\u8fc7\u7a0b\u4e2d\u7684\u5f00\u59cb\u90e8\u5206\u3002<\/li>\n
    • \u6e38\u6807\u58f0\u660e\u5305\u62ec\u6307\u5b9a\u6e38\u6807\u540d\u5b57\u3001\u6e38\u6807\u7684SQL\u67e5\u8be2\u3001\u4ee5\u53ca\u53ef\u80fd\u7684\u6e38\u6807\u53c2\u6570\u548c\u8fd4\u56de\u503c\u7b49\u4fe1\u606f\u3002<\/li>\n<\/ul>\n<\/li>\n
    • \u6e38\u6807\u6253\u5f00\u548c\u4f7f\u7528\uff1a<\/strong>\n
        \n
      • \u5728\u58f0\u660e\u540e\uff0c\u4f7f\u7528OPEN<\/code>\u547d\u4ee4\u6253\u5f00\u6e38\u6807\uff0c\u5e76\u5728\u9700\u8981\u7684\u5730\u65b9\u4f7f\u7528FETCH<\/code>\u8bed\u53e5\u83b7\u53d6\u6570\u636e\u3002<\/li>\n
      • \u53ef\u4ee5\u5728BEGIN<\/code>\u5757\u7684\u903b\u8f91\u4e2d\u4f7f\u7528\u6e38\u6807\u6765\u68c0\u7d22\u6570\u636e\u5e76\u8fdb\u884c\u64cd\u4f5c\u3002<\/li>\n<\/ul>\n<\/li>\n
      • \u6e38\u6807\u5173\u95ed\uff1a<\/strong>\n
          \n
        • \u5728\u5b8c\u6210\u6570\u636e\u68c0\u7d22\u64cd\u4f5c\u540e\uff0c\u4f7f\u7528CLOSE<\/code>\u547d\u4ee4\u5173\u95ed\u6e38\u6807\uff0c\u91ca\u653e\u76f8\u5173\u8d44\u6e90\u3002<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n

          \u793a\u4f8b\uff1a<\/p>\n

          CREATE OR REPLACE PROCEDURE your_procedure_name IS\n  CURSOR your_cursor IS\n    SELECT column1, column2 FROM your_table;\nBEGIN\n  -- Cursor open\n  OPEN your_cursor;\n\n  -- Fetch data\n  LOOP\n    FETCH your_cursor INTO variable1, variable2;\n    EXIT WHEN your_cursor%NOTFOUND;\n    -- Process fetched data here\n  END LOOP;\n\n  -- Cursor close\n  CLOSE your_cursor;\nEND;\n<\/code><\/pre>\n
          \u5c06\u6e38\u6807\u653e\u5728BEGIN<\/code>\u548cEND<\/code>\u4e4b\u95f4\uff0c\u786e\u4fdd\u4e86\u6e38\u6807\u5728\u5b58\u50a8\u8fc7\u7a0b\u6267\u884c\u671f\u95f4\u7684\u6709\u6548\u6027\u8303\u56f4\u5185\u58f0\u660e\u548c\u4f7f\u7528\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"
          \u5728Oracle\u5b58\u50a8\u8fc7\u7a0b\u4e2d\uff0c\u6e38\u6807\u901a\u5e38\u662f\u653e\u5728BEGIN\u548cEND\u8bed\u53e5\u5757\u5185\u90e8\u5b9a\u4e49\u548c\u4f7f\u7528\u7684\u3002\u6e38\u6807\u7684\u58f0\u660e\u548c\u4f7f\u7528\u4e00\u822c\u9075\u5faa\u4ee5\u4e0b […]<\/p>\n","protected":false},"author":11,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[120],"tags":[],"class_list":["post-15647","post","type-post","status-publish","format-standard","hentry","category-oracel"],"_links":{"self":[{"href":"http:\/\/wx.kaifamiao.info\/index.php\/wp-json\/wp\/v2\/posts\/15647","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/wx.kaifamiao.info\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/wx.kaifamiao.info\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/wx.kaifamiao.info\/index.php\/wp-json\/wp\/v2\/users\/11"}],"replies":[{"embeddable":true,"href":"http:\/\/wx.kaifamiao.info\/index.php\/wp-json\/wp\/v2\/comments?post=15647"}],"version-history":[{"count":1,"href":"http:\/\/wx.kaifamiao.info\/index.php\/wp-json\/wp\/v2\/posts\/15647\/revisions"}],"predecessor-version":[{"id":15648,"href":"http:\/\/wx.kaifamiao.info\/index.php\/wp-json\/wp\/v2\/posts\/15647\/revisions\/15648"}],"wp:attachment":[{"href":"http:\/\/wx.kaifamiao.info\/index.php\/wp-json\/wp\/v2\/media?parent=15647"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/wx.kaifamiao.info\/index.php\/wp-json\/wp\/v2\/categories?post=15647"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/wx.kaifamiao.info\/index.php\/wp-json\/wp\/v2\/tags?post=15647"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}