How to export table data to xml file?

Shell Programming and Scripting
1

Hi ,
I would like to get some suggestion from the experts.
My requirement is to export oracle table data as an xml file.

Any unix/linux tools, scripts available?

Regards,

2

u can make normal flat files in unix easily. i mean u can export the oracle table data in a flat file.
then u can try converting it to xml (but not sure how that will be done)

3

Take a look at the DMBS_XMLGEN package, available in a Database near you.