Oracle function??è??ùμ??°(2)
来源:未知 责任编辑:责任编辑 发表时间:2014-01-20 07:55 点击:次
elsif v_temp > 9000 and v_temp <= 35000 then
v_temp := v_temp * 0.25;
v_quick_deduction := 9000*(0.25-0.2) + 4500*(0.2-0.1) ;
elsif v_temp > 35000 and v_temp <= 55000 then
v_temp := v_temp * 0.3;
v_quick_deduction := 35000*(0.3-0.25) + 9000*(0.25-0.2);
elsif v_temp > 55000 and v_temp <= 80000 then
v_temp := v_temp * 0.35;
v_quick_deduction := 55000*(0.35-0.3) + 35000*(0.3-0.25);
elsif v_temp > 80000 then
v_temp := v_temp * 0.45;
v_quick_deduction := 80000*(0.45-0.35) + 55000*(0.35-0.3);
else
dbms_output.put_line(??à′?í2?ê?????!);
v_temp := 0;
end if;
v_expense := v_temp - v_quick_deduction;
return(v_expense);
end tax;2aê?£o select tax(5000) from dual;
?á1?£o125
相关新闻>>
最新推荐更多>>>
- 发表评论
-
- 最新评论 更多>>