oracle查询出来的字段拼接成行:
select listagg(t.id , ‘,’ ) within group (order by t.id) from 用户.表名 t where rownum < 11;
oracle查询出来的字段拼接成列(使用了replace函数):
select replace(listagg(t.id , ‘,’ ) within group (order by t.id)),‘,’ ,chr(13)||chr(10)) from 用户名.表名 t where rownum < 11;
或
select listagg(t.id , chr(13)||chr(10)) within group (order by t.id) from 用户名.表名 t where rownum < 11;