创建层次查询

select level, lpad(' ', 2 * level - 1, '--') || t.deptname, t.deptid
  from lbi_department t
 start with t.deptid = 1
connect by prior t.deptid = t.parentid

posted on 2006-08-17 13:39  老狐狸  阅读(172)  评论(0)    收藏  举报