Just a quick blog post. I learn something new by exporing Oracle database documentation1, which is you actually can generate XML from SQL query using XMLELEMENT, XMLAGG and XMLATTRIBUTES or XMLFOREST function. Here an example:
You will get something nice like this:
Thanks to Oracle for providing very extensive and easy features to generate XML.
Generating XML Data from the Database - https://docs.oracle.com/cd/E11882_01/appdev.112/e23094/xdb13gen.htm#ADXDB1600 ↩