SELECT XMLElement("Tax", XMLAttributes('http://www.w3.org/2001/XMLSchema' AS "xmlns:xsi", 'http://www.kayshav.com/Tax.xsd' AS "xsi:nonamespaceSchemaLocation"), XMLForest(loc_id, city, tax) ) AS XML_out FROM (SELECT 101 loc_id, 'New York' city, 5600 tax FROM DUAL UNION SELECT 102 loc_id, 'San Jose' city, 5900 tax FROM DUAL UNION SELECT 103 loc_id, 'Houston' city, 3750 tax FROM DUAL) WHERE loc_id <= 102;
-- Note: CAST function to be used to get XML content in -- SQL Developer
69968