创建函数并且调用
create function fun1(v_in_ename varchar2)
return number is
v_annual_sal number;
begin
select (sal+nvl(comm,0))*13 into v_annual_sal from emp where ename=v_in_ename;
return v_annual_sal;
end;
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024