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;
自定义函数里,可以写些自带函数方法
最新推荐文章于 2024-06-09 18:24:15 发布