Generate XML documents from SQL database

Generate XML documents respecting specific DTDs from data stored in relationnal tables using SQL3 (also PL/SQL to bulk collect the data) and the abstract type XMLType implanted in Oracle.

Description of the Mondial database : Mondial Database

Website : Mondial website

XMLType's documentation in Oracle 11: XMLType

example of XML result producted from SQL data & validated by a specific DTD

DTD to validate :

XML result :