SELECT temp.* FROM
(SELECT
a.GROUP_TAG,a.PAR_ID
FROM
OA_T_SYS_DIC_TAG a START WITH a.ID = '1' CONNECT BY PRIOR a.ID = a.PAR_ID
ORDER BY
a.ID) temp LEFT JOIN OA_T_SYS_DIC_TAG oaTag ON temp.GROUP_TAG = oaTag.GROUP_TAG
WHERE temp.PAR_ID='11'
SELECT temp.* FROM
(SELECT
a.GROUP_TAG,a.PAR_ID
FROM
OA_T_SYS_DIC_TAG a START WITH a.ID = '1' CONNECT BY PRIOR a.ID = a.PAR_ID
ORDER BY
a.ID) temp LEFT JOIN OA_T_SYS_DIC_TAG oaTag ON temp.GROUP_TAG = oaTag.GROUP_TAG
WHERE temp.PAR_ID='11'
本文标题:2018-11-15从主节点找子节点
本文链接:https://www.haomeiwen.com/subject/xnsufqtx.html
网友评论