Concatenate many rows into a single text string
With comma separator...
SELECT
rtrim(xmlagg(xmlelement(e, column1 || ',')).extract('//text()').extract('//text()') ,',') column1
FROM table_tWritten by Mauro Barincelli
Related protips
Have a fresh tip? Share with Coderwall community!
Post
Post a tip
Best
#Sql
Authors
Sponsored by #native_company# — Learn More
#native_title#
#native_desc#