Oracle遍历子节点_hanCSDN_20150319

select * from gis_module where id=(select id from gis_module where display_name like '%人口%') 
union 
select * from gis_module 
start with parent_id=(select id from gis_module where display_name like '%人口%') connect by prior id = parent_id 
union 
select * from gis_module where id=(select id from gis_module where display_name like '%业务%') 
union 
select * from gis_module 
start with parent_id=(select id from gis_module where display_name like '%业务%') connect by prior id = parent_id