ORACLE 中wm_concat函数

创建表TESTA

1 create table TESTA
2 (
3 id VARCHAR2(40) not null,
4 name VARCHAR2(40),
5 age VARCHAR2(40)
6 )

插入数据：

1 insert into testa values (1,'小王',21）;
2 insert into testa values (1,'小李',21）;
3 insert into testa values (1,'小赵',21）;
4 insert into testa values (1,'小钱',22）;
5 insert into testa values (1,'小孙',22）;
6 insert into testa values (1,'小周',22）;
7 insert into testa values (1,'小吴',23）;
8 insert into testa values (1,'小王',23）;