oracle 下用sql生成树结构

 select * from  表明 where 1=1 start with  父id=0  connect by 父id=prior 子id  order by 要排序字段

select * from PUB_SUB_MENU where 1=1 start with parent_id=0 connect by parent_id=prior sub_menu_id   order by seunum