这个SQL 怎么处理

[tiantian2324]

B C D E
SQM711LU04 R NG 1
SQM711LU04 R NG 1
SQM711LU04 L NG 1

数据结构如上
我合并想得到
SQM711LU04 R,L NG 1

本来是这样写
SELECT wm_concat(distinct(C)) from table
group by B,D,E

查询的时候可以，结果放在package,存储过程里面就不行了，
报错不支持这个函数。
不用动态SQL，能怎么简单 处理这个问题.

[yaiger]

用listagg

[学海无涯-回头是岸]

试一下listagg within

[「已注销」]

select b,listagg(c,',') within group (order by c desc) c ,d,e
from (select distinct * from table_name) t
group by b,d,e;