Rename "Column" from output when using XMLCOLATTVAL
Hi,
Can some one please help me to change the word "Column" in the output to something else when using XMLCOLATTVAL. For example, in the output for the following statement, I would like to see "Field" instead of "column".
I'm on 10g R2.
SELECT XMLELEMENT("Emp",
XMLCOLATTVAL(e.employee_id, e.last_name, e.salary)) "Emp Element"
FROM employees e
WHERE employee_id = 204;
Emp Element
--------------------------------------------------------------------
<Emp>
<column name="EMPLOYEE_ID">204</column>
<column name="LAST_NAME">Baer</column>
<column name="SALARY">10000</column>
</Emp>
Any help is greatly appreciated.
Thanks,
Suresh