https://blog.csdn.net/wang_yunj/article/details/51040029/

从根节点查找叶子节点

SELECT 
	LEVEL,
	CONNECT_BY_ROOT(WW_XH),
	*
FROM 
	ZFW_WW_2.T_XTSZ_CD t
WHERE
	WW_SFSC = 0
START WITH T.WW_XH = '860f9793fc3dbc00009cb975ae6eb553'
CONNECT BY PRIOR t.WW_XH = t.WW_SJCDBM