Oracle/SQL Fundamentals II
15일차 # 7-13: Eliminating Nodes or Branches
Bohemian life
2012. 4. 24. 20:29
* 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;