对于10g wm_concat返回的是字符串,11g 它的返回类型是clob,可以使用listagg
with t as(
select 1 id,'医疗费' lb,2000 je from dual
union all
select 1 id,'误工费' lb,4000 je from dual
union all
select 1 id,'交通费' lb,500 je from dual
union all
select 2 id,'营养费' lb,1000 je from dual
union all
select 2 id,'手术费' lb,20000 je from dual
union all
select 2 id,'护理费' lb,5000 je from dual
)
select id, sum(je) sum_1, replace(wm_concat(lb || ':' || je), ',', ';')
from t
group by id
with t as(
select 1 id,'医疗费' lb,2000 je from dual
union all
select 1 id,'误工费' lb,4000 je from dual
union all
select 1 id,'交通费' lb,500 je from dual
union all
select 2 id,'营养费' lb,1000 je from dual
union all
select 2 id,'手术费' lb,20000 je from dual
union all
select 2 id,'护理费' lb,5000 je from dual
)
select id, sum(je) sum_1, replace(wm_concat(lb || ':' || je), ',', ';')
from t
group by id
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货