Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Rename "Column" from output when using XMLCOLATTVAL

user11970861Jun 2 2010 — edited Jun 2 2010
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
This post has been answered by odie_63 on Jun 2 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 30 2010
Added on Jun 2 2010
1 comment
1,985 views