下面语句查询根节点下所有子孙节点
select * from tbname start with id = 0 connect by prior id = parentid
要查询某节点下的所有子孙节点,只要改start with 条件就可以了
select * from tbname start with id = 0 connect by prior id = parentid
要查询某节点下的所有子孙节点,只要改start with 条件就可以了
select * from tbname start with nodetype = 0 connect by prior id = parentid