function

create or replace function q_kob
(p_job_id in department_id departments.department_id%type)
return varchar2
is
d_department_name departments%type;
begin
select department_id into p_job_id from departments
where department_name=d_department_name;
return (d_department_name);
end q_kob;