Quick Search:
 
 The Oracle XMLAGG Function      [Return To Index] Jump to:  

Term: XMLAGG

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:
 
   Home |    Search |    Code Library |    Sponsors |    Privacy |    Terms of Use |    Contact Us © 2003 - 2024 psoug.org