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
文章來(lái)源:
http://stocknewbie.bokee.com/viewdiary.16533973.html
posted on 2009-05-01 10:52
huohuo 閱讀(149)
評(píng)論(0) 編輯 收藏