得到父节点
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'