Thursday, November 26, 2009

Get table data as XML

Get data in table as XML, return each column as element instead of attribute

SELECT CustomerID, CompanyName
FROM Customers
FOR XML AUTO, ELEMENTS

No comments:

Post a Comment

Oracle Query