ykyh1w
Last Updated: February 25, 2016
·
113
· mbarinc

Concatenate many rows into a single text string

With comma separator...

SELECT
rtrim(xmlagg(xmlelement(e, column1 || ',')).extract('//text()').extract('//text()') ,',') column1
FROM table_t