SQL> desc a;
名称 是否为空? 类型
----------------------------------------- -------- ------------------------
AID NUMBER(10)
NAME CHAR(1)
SQL> select * from a;
AID N
---------- -
1 a
1 b
1 c
2 d
2 e
2 f
select aid,wmsys.wm_concat(name) name from a group by aid;
[img]http://dl.iteye.com/upload/attachment/401746/58e61fa7-2980-3a5c-9aea-9ab991ba3211.jpg[/img]