select o.o_code, o.o_name, o.o_regdt, p.dept_code, p.dept_name, level, p.up_dept_code
from DEPT p, ORGAN o
where p.o_code = o.og_code connect by prior p.dept_code = p.up_dept_code
start with p.up_dept_code = 0 order by o.o_code
from DEPT p, ORGAN o
where p.o_code = o.og_code connect by prior p.dept_code = p.up_dept_code
start with p.up_dept_code = 0 order by o.o_code
부모/자식관계 설정
'DB' 카테고리의 다른 글
| ora-01552 해결 (0) | 2009.04.02 |
|---|---|
| order siblings by (9i 이상) (0) | 2009.04.02 |
| 9i 시작/종료 (0) | 2009.04.02 |
| 컬럼 삭제 방법 (0) | 2009.04.01 |
| 일반적인 권한 주기 (0) | 2009.04.01 |
