oracle SQL

--子查父
select * from  man_menue_hg m
  start with m.mid='43'
  connect by prior m.par_mid = m.mid;
 
--父查子
select * from  man_menue_hg m
       start with m.par_mid = '0'
       connect by prior m.mid = m.par_mid