CREATE OR REPLACE FUNCTION tax_per_depart(dno integer) RETURN number
AUTHID CURRENT_USER|DEFINER
AS
result number:=0;
begin
select sum(sal)*0.03 into result from emp
where deptno=dno
group by deptno;
return result;
end;
/
警告: 创建的函数带有编译错误这是神马问题,小弟第一次写存储函数。。
AUTHID CURRENT_USER|DEFINER
AS
result number:=0;
begin
select sum(sal)*0.03 into result from emp
where deptno=dno
group by deptno;
return result;
end;
/
警告: 创建的函数带有编译错误这是神马问题,小弟第一次写存储函数。。
AUTHID CURRENT_USER
要么
AUTHID DEFINER