Oracle

XMLELEMENT

XMLELEMENT is the function used in SELECT statement as

SELECT XMLELEMENT('xmlelement-name', <column>) from <tableName>

whereas the output comes as <xmlelement>columnvalue</xmlelement>.

For a quick and nice introduction and example, see here -> http://www.java2s.com/Tutorial/Oracle/0640__XML/UseXMLELEMENTtoconvertcolumndatatoxmlformat.htm

Generating XML from Relational Database Tables

have a look at the nice article here -> http://xml.sys-con.com/node/46178

Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-Share Alike 2.5 License.