1 Reply Latest reply on Aug 28, 2013 3:19 PM by Jason_(A_Non)

    XML out of Oracle 10g tables


      Hi Guys,


      I'm very new to this work. I would like to convert data from multiple oracle tables into XML file. I have 350000 subscribers in my database. Each subscribers data is split across multiple tables. I have to create around 70 XML files (5K each) by querying multiple tables. My XML should looks like:














      Can i do this using Oracle XML libraries? Which works better? using oracle xml db apis or custom java multi-threaded application to create xml files of above format?