表tb为树型结构表,id字段为主键,pid为父节点字段,查询某一节点的子孙节点:
SELECT * FROM tb WHERE START WITH id='id1' CONNECT BY PRIOR id=pid;
或者查询一些节点的子孙节点:
SELECT * FROM tb WHERE START WITH id in ('id1','id2','id3') CONNECT BY PRIOR id=pid;
SELECT * FROM tb WHERE START WITH id='id1' CONNECT BY PRIOR id=pid;
或者查询一些节点的子孙节点:
SELECT * FROM tb WHERE START WITH id in ('id1','id2','id3') CONNECT BY PRIOR id=pid;