11g里面用listagg，10g里面用wm_concat
select listagg(name,',') within (order by id) from table
select wm_concat(name) from table
oracle将查询结果拼装成字符串
11g里面用listagg，10g里面用wm_concat
select listagg(name,',') within (order by id) from table
select wm_concat(name) from table
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
扫一扫
