oracle拼接字段表名:test表结构:IDvalue1A1B1C...... 1N2A2B2C......2N查询语句select ID, WMSYS.WM_CONCA
oracle拼接字段
表名:test
表结构:
ID value
1 A
1 B
1 C
... ...
1 N
2 A
2 B
2 C
... ...
2 N
查询语句
select ID, WMSYS.WM_CONCAT(value) from test group by ID;
查询结果:
1 A,B,C,.....N
2 A,B,C......N
