select dept_id ,dept_name,parent_id,stutas ,remark,
level as lev
from pub_depart_info
where stutas=1
start with pub_depart_info.dept_id='1001'
connect by prior pub_depart_info.dept_id = pub_depart_info.parent_id
order by pub_depart_info.dept_id
其中：level为关键字，用于显示递归的层书