Dumping an Oracle table in XML format

select XMLELEMENT("NAME",ENAME), XMLELEMENT("SALARY",SAL),

XMLELEMENT("Department", deptno)

From emp;

The XMLELEMENT function takes two parameters , the first is the tag name and the second is the field name

<NAME>SMITH</NAME>
<SALARY>801</SALARY>
<Department>20</Department>

<NAME>ALLEN</NAME>
<SALARY>1730</SALARY>
<Department>40</Department>

<NAME>WARD</NAME>
<SALARY>1250</SALARY>
<Department>30</Department>

<NAME>JONES</NAME>
<SALARY>2975</SALARY>
<Department>20</Department>

<NAME>MARTIN</NAME>
<SALARY>1250</SALARY>
<Department>30</Department>