oracle 遍历显示遍历路径

表数据

 

 SQL

SELECT
    sys_connect_by_path ( id, '-' ),    -- 路径函数
    MONEY 
FROM
    DEMO START WITH ID = 1 CONNECT BY PRIOR ID = PID   -- 通过指定父节点递归遍历

结果