Showing posts from April, 2023

How to generate XML using SQL query in Oracle

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…

Load More
That is All