wm_concat函数:

create table t_test11(id int, goods varchar2(10), num int);
insert into t_test11 values (1, ‘苹果’, 2);
insert into t_test11 values (2, ‘梨子’, 5);
insert into t_test11 values (1, ‘西瓜’, 4);
insert into t_test11 values (3, ‘葡萄’, 1);
insert into t_test11 values (3, ‘香蕉’, 1);
insert into t_test11 values (1, ‘橘子’, 3);
commit;
select id, wm_concat(goods) goods_sum from t_test11 group by id;
结果集
1 苹果,西瓜,橘子
2 梨子
3 葡萄,香蕉
select id, wm_concat(goods || ‘(’ || num || ‘斤)’ ) goods_sum from t_test11 group by id;
结果集
1 苹果(2斤),西瓜(4斤),橘子(3斤)
2 梨子(5斤)
3 葡萄(1斤),香蕉(1斤)