oracle级联查询

  第一种：
  select *  from portal_module m   where m.moduleid like '%'
  connect by prior m.moduleid = m.parentid
  start with m.moduleid like 'ecp'
  order by m.viewOrder

---

  第二种:
  select * from portal_module t  start with t.moduleid='knowledgeManage' 
  connect by prior t.moduleid=t.parentid