-- Получаем фамилию пользователя по его id

create or replace function get_name(emp_id IN NUMBER)

return VARCHAR2

IS l_name VARCHAR2(20);

BEGIN

SELECT e.last_name

INTO get_name.l_name

from employees e

where e.employee_id = get_name.emp_id;

RETURN(get_name.l_name);

END get_name;