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

page_revision: 1, last_edited: 1220611633|%e %b %Y, %H:%M %Z (%O ago)
EditTags History Files Print Site tools+ Options
Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-Share Alike 2.5 License.