在Oracle 11g中，可以使用

In Oracle 11g, you can use the LISTAGG() function:

select id,
  number,
  listagg(letter, ', ') within group(order by id, number) as letter
from yourtable
group by id, number;

请参见带有演示的SQL小提琴