函数调试，已授权给scott
create or replace function queryempincome(eno in number)return number
as
psal emp.sal%type;
pcomm emp.comm%type;
begin
--员工月薪
select sal,comm into psal,pcomm from emp where empno=eno;
--年薪
return psal*12+nvl(pcomm,0);
end;
create or replace function queryempincome(eno in number)return number
as
psal emp.sal%type;
pcomm emp.comm%type;
begin
--员工月薪
select sal,comm into psal,pcomm from emp where empno=eno;
--年薪
return psal*12+nvl(pcomm,0);
end;
qq_枫曦_0
2018-07-09
1 回答
亿解决举报
0/150
提交
取消
