Oracle×Ô¶¨Ò庯Êý

Ҫдһ¸öoracleµÄ×Ô¶¨Ò庯Êý,Íâ½ç´«ÈëÒ»¸öÈÕÆÚ,Ò»¸öÊýÖµ.·µ»ØÒ»¸öÊý×Ö

create or replace function f_test
  (pdate in char,pctmoney in number)
return number
is
  rsum number:=0;
begin
    -- ÈÕÆÚСÓÚ2009-12-01 ·µ»ØϵÊýÊÇ0.05 ·ñÔòϵÊýÊÇ0.025
    if pdate < '2009-12-01' then
       
                select pctmoney * 0.05 into rsum 
                   
    else
       
              select  pctmoney * 0.025 into rsum     
    end if

  return(rsum)
end ;

²âÊÔʱÌáʾ³ö´í,ÎÞЧµÄÃèÊö¶ÔÏó:

---

ÒýÓÃ

select Óï¾ä±ØÐë´øfromµÄ£¬ÒªÃ´´ø¾ßÌåµÄ±íÃû£¬ÒªÃ´´ødual¡£½¨ÒéÐÞ¸ÄÈçÏ£º
create or replace function f_test
  (pdate in char,pctmoney in number)
return number
is
  rsum number:=0;
begin
    -- ÈÕÆÚСÓÚ2009-12-01 ·µ»ØϵÊýÊÇ0.05 ·ñÔòϵÊýÊÇ0.025
    if pdate < '2009-12-01' then
     
                rsum := pctmoney * 0.05