oracle中用于循环遍历树形结构中某个节点的字节点的方法,返回本节点和所有下层字节点记录
select * from table1
start with id= #{id}
connect by NOCYCLE prior id= pId
oracle中用于循环遍历树形结构中某个节点的字节点的方法,返回本节点和所有下层字节点记录
select * from table1
start with id= #{id}
connect by NOCYCLE prior id= pId
转载于:https://my.oschina.net/starforever/blog/489622