Hirarchy Query

with x as(select emp_id,emp_name,mgr_id from employee  where emp_id=7

union all

select e.emp_id,e.emp_name,e.mgr_id from x inner join employee e

on x.mgr_id=e.emp_id )

select * from x