创建一个函数来计算每个雇员应纳的个人所得税.(工资<2000,工资的10%,2000-3000 15%,〉3000 20%)
函数:
create or replace function fun3(v_sal in emp.sal%type)
return number
is
v_sal1 number;
begin
if v_sal < 2000 then
v_sal1 := v_sal * 0.1;
elsif v_sal > 3000 then
v_sal1 := v_sal * 0.2;
else
v_sal1 := v_sal * 0.15;
end if;
return(v_sal1);
end fun3;
调用:
declare
cursor cur1 is select ename,sal from emp;
v_ename emp.ename%type;
v_sal emp.sal%type;
begin
open cur1;
loop
fetch cur1 into v_ename,v_sal;
exit when cur1%notfound;
dbms_output.put_line('员工'||v_ename||'工资为:'||fun3(v_sal));
end loop;
close cur1;
end;