DB
connect by prior
잘 살아보세
2009. 4. 2. 14:35
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
부모/자식관계 설정