XMLAGG Aggreate Sample

0
Xmlagg to combine multiple rows into single row.


select  id,replace(replace(xmlagg(xmlelement("a",sql) order by id),'<a>',' '),'</a>',' ') AA from sample group by id