oracle的递归函数,Oracle数据库 递归

建一张表

create table t1(id number,par_id number,fy number);

insert into t1 values(1,null,null);

insert into t1 values(2,1,null);

insert into t1 values(3,2,15.2);

insert into t1 values(4,2,16.5);

insert into t1 values(5,1,null);

insert into t1 values(6,5,null);

insert into t1 values(7,6,30.9);

insert into t1 values(8,6,20.4);

insert into t1 values(9,6,null);

insert into t1 values(10,9,20.1);

insert into t1 values(11,9,30.5);

insert into t1 values(12,5,29.6);

commit;

结果是：

ID        PAR_ID        FY

1

2        1

3        2        15.2

4        2        16.5

5        1

6        5

7        6        30.9

8        6        20.4

9        6

10        9        20.1

11        9        30.5

12        5        29.6

我想要的结果是，所有有子节点的父节点的fy字段值，等于其直接子节点的和，结果应该是这样：

ID PAR_ID FY

1 163.2

2 1 31.7

3 2 15.2

4 2 16.5

5 1 131.5

6 5 101.9

7 6 30.9

8 6 20.4

9 6 50.6

10 9 20.1

11 9 30.5

12 5 29.6

请问怎么办