15일차 # 정렬: Order siblings by

# 정렬: Order siblings by : connect by 절이 있을 때만 사용 가능

  - Do NOT specify either ORDER BY or GROUP BY, because they will destroy the hierarchical order.

==> ORDER SIBLINGS 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;

    - ORDER 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

order by sal;

    - ORDER SIBLINGS 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

order siblings by sal;