Using SQL/XML to obtain query results as XML

SQL/XML is a draft standard that describes a functional integration of XML into the SQL language: it describes the ways that SQL can be used in conjunction with XML. The supported functions allow you to write queries that construct XML documents from relational data.

 Invalid names and SQL/XML

Using the XMLAGG function
Using the XMLCONCAT function
Using the XMLELEMENT function
Using the XMLFOREST function
Using the XMLGEN function