函數(shù)調(diào)試，已授權(quán)給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;
2018-07-09