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

 

posted @ 2015-11-12 14:36  IAMME  阅读(320)  评论(0)  编辑  收藏  举报