Quick Search:
 
 The Oracle PL/SQL SYS_XMLAGG Function      [Return To Index] Jump to:  

Term: SYS_XMLAGG

Definition:
In Oracle PL/SQL, SYS_XMLAGG is a built in function which generates an independent node element of an XML document by combining the values of input XML instances under it. ROWSET is the default node element name. It accepts two parameters of XMLtype Instance type and XMLformat instance type respectively.

Example Syntax:

SYS_XMLAGG (expression, format)


In the syntax above, 'format' is the optional parameter.

Example Usage:

SQL> SELECT SYS_XMLAGG(sys_xmlgen(ename)) FROM employee;

SYS_XMLAGG(SYS_XMLGEN(ENAME))
--------------------------------------
<ROWSET>
<ENAME>JOHN</ENAME>
<ENAME>KATE</ENAME>
<ENAME>MILLER</ENAME>




Related Links:
 
   Home |    Search |    Code Library |    Sponsors |    Privacy |    Terms of Use |    Contact Us © 2003 - 2024 psoug.org