11g里面用listagg:
select listagg(name,',') within (order by id) from table
10g里面用wm_concat:select wm_concat(name) from tablewm_concat是undocument的
listagg是11g document的
原文:
本文共 223 字,大约阅读时间需要 1 分钟。
11g里面用listagg:
select listagg(name,',') within (order by id) from table
10g里面用wm_concat:select wm_concat(name) from tablewm_concat是undocument的
listagg是11g document的
原文:
转载于:https://www.cnblogs.com/smallrock/p/3716509.html