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 ->

Generating XML from Relational Database Tables

have a look at the nice article here ->

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