1 Reply Latest reply: Aug 28, 2013 10:19 AM by Jason_(A_Non) RSS

    XML out of Oracle 10g tables

    user11478174

      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:

       

      <subscriber>

      <account_subscriber>

      <contact>

      </contact>

      <services>

      </services>

      .

      .

      .

      </account_subscriber>

      </subscriber>

       

      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?

       

      Thanks,

      Karthik