Question: how to export data from oracle database to xml file?
Answer: Right-click the table name, EMPLOYEES, in the object tree view. Select Export. Select XML. ...  Click Format tab. Select Format as: XML. Enter File as: \temp\MyTeam. ...  Click Columns tab.