oracle树形数据汇总

1：原始数据

2：执行sql语句

UPDATE test_t T1
   SET T1.VAL = (SELECT DECODE(SUM(VAL), NULL, T1.val, SUM(VAL))
                   FROM test_t T2
                  WHERE T2.ID <> T1.ID
                    AND CONNECT_BY_ISLEAF = 1
                  START WITH T2.ID = T1.ID
                 CONNECT BY PRIOR T2.ID = T2.PARENTID);

3：执行完之后的数据