2018-11-15Oracle 子节点找父节点

select temp.* from

（SELECT

a.GROUP_TAG,a.ID

FROM

OA_T_SYS_DIC_TAG a START WITH a.ID = '2' CONNECT BY PRIOR a.PAR_ID =  a.ID

ORDER BY

a.ID） temp

WHERE temp.id != '2'

从子节点，找父节点  Oracle