27 September 2018 | 1 min read

Generate XML using SQL query with Oracle database

XML (eXtensible Markup Language) = Oracle database + SQL queries

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.

  1. Generating XML Data from the Database - https://docs.oracle.com/cd/E11882_01/appdev.112/e23094/xdb13gen.htm#ADXDB1600 ↩

Robbi Nespu | Centos, Database, Fedora, Linux, Oracle, RDBMS, SQL, Ubuntu, Windows, XML

Edit

Discussion and feedback

The postings on this site are my own and don't necessarily represent my employer’s positions, strategies or opinions.

©Robbi Nespu, 2021 — built with Jekyll + Lagom theme
Home | Contact | Archive | Privacy policy