插子节点的所有父节点和父节点所有子节点sql

根据子节点查找所有父节点:

SELECT ID,PARENT_ID,NAME,LEVEL FROM 表名 (where语句) START WITH ID=1392785160633630722(表ID)CONNECT BY PRIOR PARENT_ID=ID ORDER BY LEVEL;

根据父节点查找所有子节点:

SELECT ID,PARENT_ID,NAME,LEVEL FROM 表名(where语句) START WITH ID=1392785160633630722(表ID) CONNECT BY PRIOR PARENT_ID=ID ORDER BY LEVEL;