查询树

查询树

select level, d.*
  from tbl_infor_dir d
    start with dir_id = '0103'
      connect by prior dir_id = super_dir_id
         order by level