col empno format a20
select level, lpad(empno, level*4, ' ') as empno, ename, job, mgr, sal
from emp e
start with empno = 7839
connect by prior empno = mgr;
select level, lpad(empno, level*4, ' ') as empno, ename, job, mgr, sal
from emp e
start with empno = 7369
connect by empno = prior mgr;
'Oracle > SQL Fundamentals II' 카테고리의 다른 글
15일차 # 정렬: Order siblings by (0) | 2012.04.24 |
---|---|
15일차 # 7-13: Eliminating Nodes or Branches (0) | 2012.04.24 |
15일차 # 7-10: Level, a Hierarchical Query Pseudocolumn (0) | 2012.04.24 |
15일차 # 7-7: Top-Down vs. Bottom-Up (0) | 2012.04.24 |
15일차 # 7-3 ~ 5: Hierarchical Query (계층 질의) (0) | 2012.04.24 |