自定义函数里,可以写些自带函数方法

create or replace function get_SJDS(rs in number) return number is
Result number;
v_i number;
v_j number;
v_k number;
v_g number;
begin
  Result:=0;
  v_i:=0;
  v_j:=0;
  v_k:=0;
  v_g:=0;
  if(rs > 0) then
    v_i := trunc(rs/20);
    v_g := mod(rs,20);
     dbms_output.put_line(v_g);
    if(v_g !=0) then
           v_j := trunc(v_g/10);
           v_g := mod(v_g,10);
    end if;
     if(v_g !=0) then
           v_k := trunc(v_g/5);
           v_g := mod(v_g,5);
     end if;
     if(v_g != 0)then
            v_k := v_k+1;
     end if;
     Result := v_i+v_j+v_k;
   end if;
   return (Result);
end get_SJDS;