随笔-77  评论-5  文章-2  trackbacks-0

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)  编辑  收藏

只有注册用户登录后才能发表评论。


网站导航: