aula_2b.sql

create or replace
    function func_retdept(p_id in number)
return varchar2
is
    retorno departments.department_name%type;
          
begin
    if p_id > 0 and p_id <999999 then
        select department_name into retorno
         from departments dept
         right join employees emp
         on dept.department_id = emp.department_id
         where employee_id = p_id;
     else
        retorno := 'id do funcionario fora da faixa valida';
    end if;
    return retorno;
end;