得到父节点
SELECT * FROM tsys_module
CONNECT BY MODULEID= PRIOR parentid
START WITH MODULEID = '1000061'
得到子节点
SELECT * FROM tsys_module
CONNECT BY PRIOR MODULEID= parentid
START WITH MODULEID= '1000061'
得到父节点
SELECT * FROM tsys_module
CONNECT BY MODULEID= PRIOR parentid
START WITH MODULEID = '1000061'
得到子节点
SELECT * FROM tsys_module
CONNECT BY PRIOR MODULEID= parentid
START WITH MODULEID= '1000061'
转载于:https://www.cnblogs.com/flyrain/archive/2009/12/29/oracel_parent_child.html