{"id":1645,"date":"2015-12-03T15:53:43","date_gmt":"2015-12-03T07:53:43","guid":{"rendered":"http:\/\/www.821121.com\/?p=1645"},"modified":"2022-04-22T17:58:05","modified_gmt":"2022-04-22T09:58:05","slug":"oracle%e8%87%aa%e5%ae%9a%e4%b9%89%e5%87%bd%e6%95%b0","status":"publish","type":"post","link":"http:\/\/www.821121.com\/?p=1645","title":{"rendered":"Oracle\u81ea\u5b9a\u4e49\u51fd\u6570"},"content":{"rendered":"<h2>\u5b9a\u4e49<\/h2>\n<p>\u51fd\u6570\u548c\u5b58\u50a8\u8fc7\u7a0b\u7c7b\u4f3c\uff0c\u53ef\u4ee5\u7b80\u5355\u7684\u7406\u89e3\u4e3a\u4e00\u6bb5\u53ef\u4ee5\u6267\u884c\u67d0\u4e2a\u6d3b\u52a8\/\u52a8\u4f5c\u7684\u5b50\u7a0b\u5e8f\uff0c\u53ef\u4ee5\u4f5c\u4e3a\u4e00\u4e2a\u7cfb\u7edf\u5bf9\u8c61\u88ab\u5b58\u50a8\u5728\u6570\u636e\u5e93\u4e2d\uff0c\u53ef\u4ee5\u91cd\u590d\u8c03\u7528\u3002\u4e0e\u5b58\u50a8\u8fc7\u7a0b\u4e0d\u540c\u7684\u662f\uff0c\u51fd\u6570\u603b\u662f\u5411\u8c03\u7528\u8005\u8fd4\u56de\u4e00\u4e2a\u503c\uff0c\u800c\u5b58\u50a8\u8fc7\u7a0b\u4e0d\u80fd\u6709\u8fd4\u56de\u503c\u3002<\/p>\n<h2>\u8bed\u6cd5\u7ed3\u6784<\/h2>\n<pre><code class=\"language-sql\">create or replace function \u51fd\u6570\u540d(\u53c2\u65701 \u6a21\u5f0f \u53c2\u6570\u7c7b\u578b)  \nreturn \u8fd4\u56de\u503c\u7c7b\u578b  \nas \/is \n\u53d8\u91cf1 \u53d8\u91cf\u7c7b\u578b;  \n\u53d8\u91cf2 \u53d8\u91cf\u7c7b\u578b;  \nbegin  \n    \u51fd\u6570\u4f53;  \nend \u51fd\u6570\u540d; <\/code><\/pre>\n<h4>1.\u6709\u53c2\u6570<\/h4>\n<p>\u521b\u5efa\u51fd\u6570<\/p>\n<pre><code class=\"language-sql\">create or replace function function1(para1 in number, para2 in number)   \nreturn number   \nas   \nbegin  \n  if para1 &gt; para2 then  \n      return para1;  \n  else  \n      return para2;   \n  end if;  \nend function1;  <\/code><\/pre>\n<p>\u8c03\u7528\u51fd\u6570<\/p>\n<pre><code class=\"language-sql\">select function1(666, 333) from dual;  <\/code><\/pre>\n<h4>2.\u65e0\u53c2\u6570<\/h4>\n<p>\u521b\u5efa\u51fd\u6570<\/p>\n<pre><code class=\"language-sql\">create or replace function get_user\n\nreturn varchar2 is  \n\n  v_user varchar2(50);  \n\nbegin  \n\n  select username into v_user from user_users;  \n\n  return v_user;  \n\nend get_user;<\/code><\/pre>\n<p>\u8c03\u7528\u51fd\u6570<\/p>\n<pre><code class=\"language-sql\">select get_user from dual;  <\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\u5b9a\u4e49 \u51fd\u6570\u548c\u5b58\u50a8\u8fc7\u7a0b\u7c7b\u4f3c\uff0c\u53ef\u4ee5\u7b80\u5355\u7684\u7406\u89e3\u4e3a\u4e00\u6bb5\u53ef\u4ee5<\/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-1645","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/1645","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=1645"}],"version-history":[{"count":3,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/1645\/revisions"}],"predecessor-version":[{"id":1730,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/1645\/revisions\/1730"}],"wp:attachment":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1645"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1645"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1645"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}