oracle11g开始支持的listagg函数替代了wmconcat来实现行列转换的功能。

listagg函数的用法：

oracle行列转换例子：

—建表https://www.cndba.cn/foucus/article/3929https://www.cndba.cn/foucus/article/3929

SQL> create table b (id number,name varchar2(20));

Table created.

insert into b values(1,'zhang');

insert into b values(1,'wang');

insert into b values(2,'li');

insert into b values(2,'zhao');

SQL> select id,LISTAGG(name,',') within group(order by name desc) as bb from b group by id;

ID

----------

BB

--------------------------------------------------------------------------------

1

zhang,wang

2

zhao,li

pg中是没有listag