ykyh1w
Last Updated: February 25, 2016
·
87
· mbarinc
Barry avatar

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
Say Thanks
Respond