使用伪列LEVEL来显示结点在树中的层次

select level, employee_id,manager_id,first_name,last_name from employees
start with employee_id=1
connect by prior employee_id=manager_id order by level;

 

"   ","LEVEL","EMPLOYEE_ID","MANAGER_ID","FIRST_NAME","LAST_NAME"
"1","1","1","","James","Smith"
"2","2","10","1","kevin","Black"
"3","2","2","1","Ron","Johnson"
"4","2","4","1","Susan","Jones"
"5","3","13","10","Doreen","Penn"
"6","3","7","4","John","Grey"
"7","3","11","10","Keith","Long"
"8","3","5","2","Rob","Green"
"9","3","3","2","Fred","Hobbs"