select lpad(' ', 2*(LEVEL - 1))||dpt_name,
dpt_id,
dpt_manager
from department
start with dpt_name = :a
connect by prior dpt_manager = dpt_id and
dpt_manager = :a

---------------------------------------------------------------
SELECT emp1.EMP_DEPT,
emp1.EMP_ID,
emp1.EMP_NAME,
emp1.EMP_ADDRESS,
emp1.EMP_TELEPHONE,
emp1.EMP_GRADE
FROM EMPLOYEE emp1
WHERE NOT ( emp1.EMP_SALARY - 40000 < 10000 )
AND EXISTS
(SELECT 'X' FROM GRADE grd1
WHERE EMP1.EMP_GRADE = grd1.GRD_ID + 1)
AND EMP1.EMP_ID BETWEEN '' AND '9999999'
AND EMP1.EMP_GRADE = 23
AND EMP1.EMP_DEPT IN
(SELECT DEPT2.DPT_ID
FROM DEPARTMENT DEPT2
WHERE DEPT2.DPT_ID IN
(SELECT DEPT1.DPT_ID
FROM DEPARTMENT DEPT1
)
)
AND (EMP1.EMP_DEPT, EMP1.EMP_ID) IN
(SELECT DEPT3.DPT_ID, '73737'
FROM DEPARTMENT DEPT3)
ORDER BY 1,
2