LEVEL 함수

select ename, connect_by_isleaf isleaf,
       level, sys_connect_by_path(ename,'/') path
from emp
start with ename = 'KING'
CONNECT BY PRIOR EMPNO = MGR;

select ename, connect_by_ISCYCLE ISCYCLE,
       level, sys_connect_by_path(ename,'/') path
from emp
start with ename = 'KING'
CONNECT BY NOCYCLE PRIOR EMPNO = MGR;

 

select ename, connect_by_ROOT ENAME,
       level, sys_connect_by_path(ename,'/') path
from emp
start with ename = 'KING'
CONNECT BY NOCYCLE PRIOR EMPNO = MGR;