求:将树形下的子集数量汇总归并求和

Question

17:17:05 SQL> select * from tr;COL1       COL2
---------- --------------------
10         2
1010       3
1011       4
101110     3
20         5
2010       6已选择6行。已用时间:  00: 00: 00.31
17:18:53 SQL> select col1,(
17:19:02   2  select sum(col2) from tr t where instr(t.col1,tr.col1)=1
17:19:06   3  )  from tr;COL1       (SELECTSUM(COL2)FROMTRTWHEREINSTR(T.COL1,TR.COL1)=1)
---------- ----------------------------------------------------
10                                                           12
1010                                                          3
1011                                                          7
101110                                                        3
20                                                           11
2010                                                          6已选择6行。已用时间:  00: 00: 00.47
17:19:10 SQL>

Answer 1

已测试:
select app_code ,(select count(1) from x_appmoudle where app_code like m.app_code||'%' ) from x_appmoudle m