with t as (
   select  1  id, null parent_id, 'Top' description,  0  amount from dual union all
   select  2  id,  1  parent_id, 'Top-One' description,  0  amount from dual union all
   select  3  id,  2  parent_id, 'One-one' description,  2000  amount from dual union all
   select  4  id,  2  parent_id, 'One-two' description,  3000  amount from dual union all
   select  5  id,  1  parent_id, 'Top-Two' description,  1000  amount from dual 
)
select *
from t
start with parent_id is null
connect by prior id = parent_id
model 
dimension by (id, parent_id, rownum r)
measures(amount)
rules (
   amount[any, any, any] order by r desc = nvl(amount[cv(), cv(), cv()], 0 ) + nvl(sum(amount)[any, cv(id), any], 0 )
)

with t as ( --id - уникальны
   select  1  id, null parent_id, 'Top' description,  10  amount from dual union all
   select  2  id,  1  parent_id, 'Top-One' description,  100  amount from dual union all
   select  3  id,  2  parent_id, 'One-one' description,  2000  amount from dual union all
   select  4  id,  2  parent_id, 'One-two' description,  3000  amount from dual union all
   select  5  id,  1  parent_id, 'Top-Two' description,  1000  amount from dual union all
   select  4  id,  2  parent_id, 'One-three' description,  300  amount from dual 
)
select id, description, amount, 
   case l 
      when  1  then sum(amount) over(partition by p1)
      when  2  then sum(amount) over(partition by p2)
      when  3  then sum(amount) over(partition by p3)
      when  4  then sum(amount) over(partition by p4)
      when  5  then sum(amount) over(partition by p5)
   end ha
from (
select level l, id, parent_id, description, amount, 
sys_connect_by_path(id,'/') p,
substR(sys_connect_by_path(id,'/'),  1 ,  1 * 2 ) p1,
substR(sys_connect_by_path(id,'/'),  1 ,  2 * 2 ) p2,
substR(sys_connect_by_path(id,'/'),  1 ,  3 * 2 ) p3,
substR(sys_connect_by_path(id,'/'),  1 ,  4 * 2 ) p4,
substR(sys_connect_by_path(id,'/'),  1 ,  5 * 2 ) p5
from t
start with parent_id is null
connect by prior id = parent_id
) tt;

with t as ( 
   select  1  id, null parent_id, 'Top' description,  10  amount from dual union all
   select  2  id,  1  parent_id, 'Top-One' description,  100  amount from dual union all
   select  3  id,  2  parent_id, 'One-one' description,  2000  amount from dual union all
   select  4  id,  2  parent_id, 'One-two' description,  3000  amount from dual union all
   select  5  id,  1  parent_id, 'Top-Two' description,  1000  amount from dual union all
   select  6  id,  2  parent_id, 'One-three' description,  300  amount from dual 
)
select 
   min(id) keep(dense_rank first order by l) id,
   min(description) keep(dense_rank first order by l) description,
   sum(amount)
from (
     select level l, id, parent_id, description, amount, 
     sys_connect_by_path(id,'/') p,
     std.subword(sys_connect_by_path(id,'/'),  1 ) p1,
     std.subword(sys_connect_by_path(id,'/'),  2 ) p2,
     std.subword(sys_connect_by_path(id,'/'),  3 ) p3,
     std.subword(sys_connect_by_path(id,'/'),  4 ) p4,
     std.subword(sys_connect_by_path(id,'/'),  5 ) p5 --максимальная глубина хиерархии
   from t
   start with parent_id is null
   connect by prior id = parent_id
) tt
group by p1, rollup(p2,p3,p4,p5)
having grouping_id(p2, p3, p4, p5) = power( 2 ,  5 -min(l))- 1 
;

SQL> with t as (
   select  1  id, null parent_id, 'Top' description,  10  amount from dual union all
   3      select  2  id,  1  parent_id, 'Top-One' description,  100  amount from dual union all
   select  33  id,  2  parent_id, 'One-one' description,  2000  amount from dual union all
   5      select  4  id,  2  parent_id, 'One-two' description,  3000  amount from dual union all
   select  5  id,  1  parent_id, 'Top-Two' description,  1000  amount from dual union all
   select  6  id,  2  parent_id, 'One-three' description,  300  amount from dual
   union all select  66  id,  6  parent_id, 'Tree-three' description,  3  amount from dual
   union all select  666  id,  66  parent_id, 'Tree-three' description,  0 . 3  amount from dual
)
  11   select 
  12      min(id) keep(dense_rank first order by l) id,
   min(description) keep(dense_rank first order by l) description,
   sum(amount),
  15      p1, p2, p3, p4, p5, grouping_id(p2, p3, p4, p5) grp, power( 2 ,  5 -min(l))- 1  pwr
  16   from (
  17        select level l, id, parent_id, description, amount,
     sys_connect_by_path(id,'/') p,
     std.subword(sys_connect_by_path(id,'/'),  1 ) p1,
  20        std.subword(sys_connect_by_path(id,'/'),  2 ) p2,
  21        std.subword(sys_connect_by_path(id,'/'),  3 ) p3,
  22        std.subword(sys_connect_by_path(id,'/'),  4 ) p4,
     std.subword(sys_connect_by_path(id,'/'),  5 ) p5 --максимальная глубина хиерархии
  24      from t
  25      start with parent_id is null
   connect by prior id = parent_id
  27   ) tt
  28   group by p1, rollup(p2,p3,p4,p5)
having grouping_id(p2, p3, p4, p5) = power( 2 ,  5 -min(l))- 1 
order by p1 nulls first, p2 nulls first, p3 nulls first, p4 nulls first, p5 nulls first
  31   ;

        ID DESCRIPTION                    SUM(AMOUNT) P1    P2    P3    P4    P5           GRP        PWR
---------- ------------------------------ ----------- ----- ----- ----- ----- ----- ---------- ----------
          1  Top                                  6413 , 3   1                                       15           15 
          2  Top-One                              5403 , 3   1       2                                  7            7 
         33  One-one                                2000   1       2       33                           3            3 
          4  One-two                                3000   1       2       4                            3            3 
          6  One-three                             303 , 3   1       2       6                            3            3 
         66  Tree-three                              3 , 3   1       2       6       66                     1            1 
        666  Tree-three                              , 3   1       2       6       66      666              0            0 
          5  Top-Two                                1000   1       5                                  7            7 

with t as (
   select '/12/3/456' s from dual
),
w as (
   select level n from dual connect by level <=  5 
)
select n, 
   substr(s, instr(s, '/',  1 , n)+ 1 , instr(s||'/', '/',  1 , n+ 1 )-instr(s, '/',  1 , n)- 1 ) 
from t cross join w;