11g里面用listagg,10g里面用wm_concat
select listagg(name,',') within (order by id) from table
select wm_concat(name) from table
oracle将查询结果拼装成字符串
最新推荐文章于 2021-12-27 18:54:12 发布
11g里面用listagg,10g里面用wm_concat
select listagg(name,',') within (order by id) from table
select wm_concat(name) from table