问答详情
源自:2-3 [Oracle] 如何调试存储过程

函数调试,已授权给scott

https://img3.mukewang.com/5b43548600017b6612780633.jpgcreate 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 20:27

个回答

  • qq_枫曦_0
    2018-07-09 21:55:18

    https://img1.mukewang.com/5b43693300016dc408980455.jpg亿解决