create or replace function(p_deptno in varchar2)
return number
as
avgsal number(10,2);
begin
select avg(sal) into avgsal from emp where deptno = p_deptno;
return avgsal;
end;
create or replace function(p_deptno in varchar2)
return number
as
avgsal number(10,2);
begin
select avg(sal) into avgsal from emp where deptno = p_deptno;
return avgsal;
end;
