--查询当前节点的所有父级节点
SELECT LEVEL,ID FROM NC_CONFIG_TYPE
START WITH ID = '57dc97e402c6466f9999b5689f00b3e4'
CONNECT BY NOCYCLE PRIOR PARENTID = ID
--查询当前节点的所有子节点
SELECT LEVEL,ID FROM NC_CONFIG_TYPE
START WITH ID = '47badc4c36234589a354b929f54b2364'
CONNECT BY NOCYCLE PRIOR ID = PARENTID
--多列用逗号隔开合并为一列
SELECT TO_CHAR(WMSYS.WM_CONCAT(ID)) AS ID FROM WORK_CODE