SQL Calculo Idade

select employee_id, first_name,hire_date,trunc( (sysdate - to_date(hire_date)) /365, 0) as idade from employees;
resultado

EMPLOYEE_ID | FIRST_NAME | HIRE_DATE | IDADE
100 | Steven | 17/06/1987 | 24