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?