select *
from emp e
where (sysdate - e.hiredate) / 12 / 30 > 25;

select *
from emp e
where months_between(sysdate, e.hiredate) / 12 >25;

select *
from emp e
where add_months(sysdate, -25*12) >= e.hiredate;