当前位置：网站首页>Oracle database combines the query result sets of multiple columns into one row

Oracle database combines the query result sets of multiple columns into one row

2022-04-23 13:40:00 【Wangcai 2】

Method 1 ：

select field1,listagg(field3,',') within GROUP (order by field3) from test group by field1;

Method 2 （ When method 1 reports that the length of the spliced string is too long , Use method 2 ）：

select field1,xmlagg(xmlparse(content field3||',' wellformed) order by field3).getclobval() from test1 group by field1

版权声明
本文为[Wangcai 2]所创，转载请带上原文链接，感谢
https://yzsam.com/2022/04/202204230604300721.html