How to generate XML using SQL query in Oracle byTechdoc •Monday, April 03, 2023 How to generate XML using SQL query in Oracle 1. Selecting single column from a table SELECT SYS_XMLAGG(SYS_XMLGEN(franchisee_codes)) FROM franchisee_mapping WHERE username = '<username>'; The output will be <?xml version=&qu…