Definition:
In Oracle PL/SQL, XMLAGG is a built in aggregate function which combines multiple XML elements together. The main use of XMLAGG function is concatenating multiple row values of a column into single row.
Example Syntax:
XMLAGG(XML Type instance (ORDER BY clause))
Example Usage:
SELECT XMLAGG(XMLELEMENT(E,ename||',')).EXTRACT('//text()') "Result"
FROM employee_names
/
Result
-------------------------------------------------------------------
SMITH,ALLEN,WARD,JONES,MARTIN,BLAKE,CLARK,SCOTT,KING,TURNER,ADAMS
Related Links:
