{"id":1668,"date":"2016-01-27T17:12:42","date_gmt":"2016-01-27T09:12:42","guid":{"rendered":"http:\/\/www.821121.com\/?p=1668"},"modified":"2022-04-27T17:16:37","modified_gmt":"2022-04-27T09:16:37","slug":"oracle%e7%bb%91%e5%ae%9a%e5%8f%98%e9%87%8f%e7%9a%84%e4%bd%bf%e7%94%a8","status":"publish","type":"post","link":"http:\/\/www.821121.com\/?p=1668","title":{"rendered":"Oracle\u7ed1\u5b9a\u53d8\u91cf\u7684\u4f7f\u7528"},"content":{"rendered":"<h1>\u5b9a\u4e49<\/h1>\n<p>\u5728Oracle\u4e2d\uff0c\u5bf9\u4e8e\u4e00\u4e2a\u63d0\u4ea4\u7684sql\u8bed\u53e5\uff0c\u5b58\u5728\u4e24\u79cd\u53ef\u9009\u7684\u89e3\u6790\u8fc7\u7a0b\uff0c\u786c\u89e3\u6790\u548c\u8f6f\u89e3\u6790\u3002<\/p>\n<p>\u4e00\u4e2a\u786c\u89e3\u6790\u9700\u8981\u7ecf\u89e3\u6790\u3001\u5236\u5b9a\u6267\u884c\u8def\u5f84\u3001\u4f18\u5316\u8bbf\u95ee\u8ba1\u5212\u7b49\u6b65\u9aa4\u3002\u786c\u89e3\u6790\u4e0d\u4ec5\u4ec5\u4f1a\u8017\u8d39\u5927\u91cf\u7684cpu\uff0c\u66f4\u91cd\u8981\u7684\u662f\u4f1a\u5360\u636e\u91cd\u8981\u7684\u95e9(latch)\u8d44\u6e90\u3002\u552f\u4e00\u4f7f\u5f97oracle\u80fd\u591f\u91cd\u590d\u5229\u7528\u6267\u884c\u8ba1\u5212\u7684\u65b9\u6cd5\u5c31\u662f\u91c7\u7528\u7ed1\u5b9a\u53d8\u91cf\u3002\u7ed1\u5b9a\u53d8\u91cf\u7684\u5b9e\u8d28\u5c31\u662f\u4f7f\u7528\u53d8\u91cf\u6765\u4ee3\u66ffsql\u8bed\u53e5\u4e2d\u7684\u5e38\u91cf\u3002\u7ed1\u5b9a\u53d8\u91cf\u80fd\u591f\u4f7f\u5f97\u6bcf\u6b21\u63d0\u4ea4\u7684sql\u8bed\u53e5\u90fd\u5b8c\u5168\u4e00\u6837\u3002<\/p>\n<h1>\u7ed1\u5b9a\u53d8\u91cf\u4f7f\u7528\u683c\u5f0f<\/h1>\n<pre><code class=\"language-sql\">#\u5b9a\u4e49\u53d8\u91cfi\nvariable i number;\n#\u8bbe\u7f6e\u5f53\u524d\u8bed\u53e5\u7684\u53d8\u91cf\u503c\nexec :i :=1;\n#\u4f7f\u7528\u7ed1\u5b9a\u53d8\u91cf\u7684SQL\u8bed\u53e5\nselect * from t where id=:i;<\/code><\/pre>\n<h3>\u7ed1\u5b9a\u53d8\u91cf\u4f7f\u7528\u524d<\/h3>\n<pre><code class=\"language-sql\">select * from test where id=1;  \nselect * from test where id=2; <\/code><\/pre>\n<h3>\u7ed1\u5b9a\u53d8\u91cf\u4f7f\u7528\u540e<\/h3>\n<pre><code class=\"language-sql\">variable i number;  \nexec :i :=1;  \nselect * from test where id=:i;  <\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\u5b9a\u4e49 \u5728Oracle\u4e2d\uff0c\u5bf9\u4e8e\u4e00\u4e2a\u63d0\u4ea4\u7684sql\u8bed\u53e5\uff0c<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[18,48,1],"tags":[],"class_list":["post-1668","post","type-post","status-publish","format-standard","hentry","category-oracle-11g","category-sql","category-uncategorized"],"_links":{"self":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/1668","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=1668"}],"version-history":[{"count":3,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/1668\/revisions"}],"predecessor-version":[{"id":1732,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/1668\/revisions\/1732"}],"wp:attachment":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1668"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1668"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1668"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}