create or replace function get_sal
(id employees.employee_id%type) return number is
sal employees.salary%type:=0;
begin
select salary into sal
from employees
where employee_id = id;
return sal;
end get_sal;
/
create or replace function get_sal
(id employees.employee_id%type) return number is
sal employees.salary%type:=0;
begin
select salary into sal
from employees
where employee_id = id;
return sal;
end get_sal;
/