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?
Also, 10g is a marketing label and not a database version. I'm pretty sure there are 10 versions that fall between 10.1.0.1 and 10.2.0.5. The version can make a difference on the answer you get too.