select employee_id,last_name,manager_id,
level,lpad(' ',level*5)||last_name AS name
from employees
where rownum<30
start with manager_id=100
connect by prior employee_id=manager_id;
