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;