15일차 # 7-13: Eliminating Nodes or Branches

  * Node 자르기: WHERE 절

select level, lpad(empno, level*4, ' ') as empno, ename, job, mgr, sal 

from emp e

where empno <> 7698

start with empno = 7839    

connect by prior empno = mgr;

  * Branch 자르기: CONNECT BY 절

select level, lpad(empno, level*4, ' ') as empno, ename, job, mgr, sal 

from emp e

start with empno = 7839    

connect by prior empno = mgr and empno <> 7698;