oracle 在sql把字段多个值变成一个值，以英文逗号隔开！(参考)

huayal

已于 2022-06-08 13:51:30 修改

阅读量665

点赞数

文章标签： sql 数据库 database

于 2022-06-06 17:45:30 首次发布

本文链接：https://blog.csdn.net/hylshyshm/article/details/125151333

版权

> (select LISTAGG(to_char(b.depot_id),',') WITHIN GROUP(ORDER BY
> b.depot_id) from wms_owner_depot b where b.owner_id=o.OWNER_ID)

例子：

SELECT DISTINCT
o.owner_id,
(select region_name from SYS_region where region_id=o.city) city,
o.source,(select LISTAGG(to_char(b.depot_id),‘,’) WITHIN GROUP(ORDER BY b.depot_id) from wms_owner_depot b where
b.owner_id=o.OWNER_ID)as idss
FROM
wms_owner o
JOIN WMS_OWNER_DEPOT od ON od.OWNER_ID = o.OWNER_ID
${params.dataScope}