oracle 把查询出的列转换成行并按逗号分隔

select  listagg (id, ',') WITHIN GROUP (ORDER BY id) id
from tableName
start with id = xxx
connect by prior id = fat_id;
posted @ 2022-08-31 18:17  小秦的开发梦  阅读(95)  评论(0)    收藏  举报