Quick Search:
CODE
Oracle PL/SQL Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
 The Oracle PL/SQL SYS_XMLAGG Function      [Return To Index] Jump to:  
  Looking for the original pages? (formerly called "Morgan's Library") You can find them here.

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      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us 84 users online    © 2009 psoug.org
PSOUG LOGIN
Username: 
Password: 
Forgot your password?