Qracle数据库递归查询排序问题

SELECT SUBSTR(SYS_CONNECT_BY_PATH( NAME,'||'), 3) NAME_PATH
FROM mplm.classificationnode cd1
--where CONNECT_BY_ISLEAF = '1'

START WITH cd1.ida2a2 ='88398' --孙子节点
CONNECT BY PRIOR cd1.ida3b6 = cd1.ida2a2