查找节点下的所有子节点:
select id from address_type c start with c.id ='xxxx'connect by prior c.id = c.PARENT_ID
查找节点的所有父节点:
select * from address_type c start with c.id ='XXX' connect by c.id= prior c.PARENT_ID
查找节点下的所有子节点:
select id from address_type c start with c.id ='xxxx'connect by prior c.id = c.PARENT_ID
查找节点的所有父节点:
select * from address_type c start with c.id ='XXX' connect by c.id= prior c.PARENT_ID