select level, d1.dept_id,d1.dept_code,sys_connect_by_path(dept_code,'/') path from zte_fbp_depts d1
start with d1.dept_id=12
connect by prior d1.dept_id= d1.parent_dept_id
文章来源:
http://stocknewbie.bokee.com/viewdiary.16533973.html
posted on 2009-05-01 10:52
huohuo 阅读(148)
评论(0) 编辑 收藏