functio

create or replace function employer_details_func
return varchar2(20);
is
emp_name varchar2(20);
begin
select department_name into emp_name
from departments where department_id=10;
return emp_name;
end;
/