I need to get data from a table in Oracle DB into an XML file of specific format.
This XML file has more elements than the data fields picked from the table i.e. for e.g. the table contains 5 fields and the XML format contains 10 elements/tags in which there are 5 tags that match the table fields and the rest of the 5 tags do not have corresponding fields and they do not have to be populated with data.
My DB does not have XSU capability.
I'm trying to use OraXML class of Java to query the table and get the data in a simple XML format. This method will return an XML with only 5 elements which correspond to the table fields.
I need to get the XML in the format specified which has 10 elements.
Could anyone suggest a way to do this using any Java API or any other means?