I created an XML output file with APEX_DATA_EXPORT.
It is working fine, but I don’t understand how to change, if possible, the structure and names of the attributes and elements.
Example output as csv works fine:
Reference | BIC | IBAN | Amount | PaymentDate |
---|---|---|---|---|
AB8473 | BICX 123 45 | DE 1349134913 | 999 | 2022-03-31T00:00:00 |
ZAB9574 | BICX 123 45 | DE 1349134913 | 156 | 2022-03-31T00:00:00 |
XY1245 | BICX 123 45 | DE 1349134913 | 123 | 2022-03-31T00:00:00 |
Example output as xml
<ROWSET>
<ROW>
<Reference>AB8473 </Reference>
<BIC>BICX 123 45</BIC>
<IBAN>DE 1349134913</IBAN>
<Amount>999</Amount>
<PaymentDate>2022-03-31T00:00:00</PaymentDate>
</ROW>
<ROW>
<Reference>ZAB9574 </Reference>
<BIC>BICX 123 45</BIC>
<IBAN>DE 1349134913</IBAN>
<Amount>156</Amount>
<PaymentDate>2022-03-31T00:00:00</PaymentDate>
</ROW>
</ROWSET>
...
I was not able to find anything in
Oracle Reference
How to change the names ROWSET / ROW and add some additional attributes?
Thanks in advance,
KBK
New contributor
KBK is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.