Export data from Oracle table to XML file without programming

by

Want to export data from Oracle table to XML file?

Using DBToFile, a native GUI tool, you can export data from Oracle table to XML file easily and fast.

  • Step by step, just a few mouse clicks.
  • Support schedule and automate converting task.
  • Support Windows, Linux, macOS.

Download DBToFile Download DBToFile

Here’s how to.

Export data from Oracle table to XML file

Choose Oracle and logon.

export Oracle  table to XML file - Choose Oracle and logon

Click “Export From Table” at task dialog.

Export data from Oracle  Table To XML File - task window

Select XML file type.

Export data from Oracle  Table To XML File - select XML file type

1. Choose Oracle table.

Unload data from Oracle  Table To XML File - select table

2. Set XML file options.

Extract data from Oracle  Table To XML File - enter file name

3. Summary.

Convert data from Oracle  Table To XML File - summary

4. Export Oracle data to XML file.

Dump data from Oracle  Table To XML File - export

After exporting, you can view output XML files.

Export data from Oracle  Table To XML File - view XML file

Download DBToFile Download DBToFile

Save/load session of exporting Oracle to XML

You can save/load session to run “Oracle to XML” conversion repeatly.

1.Save Session.

Click “Save Session” button, then enter a session file name.

Oracle to XML - save session

click “OK” button.

2.Load Session.

Click the “Open a Saved Session” in task window, select a session file.

Oracle to XML - load session

then show the wizard form, click a few “Next” to export Oracle to XML.

Oracle to XML - start session

Download DBToFile Download DBToFile

Run in command line for exporting Oracle to XML

You can run “Oracle to XML” conversion in command line.

When you save session, you can click “Save & Make Batch File”.

Oracle to XML - save session

The “Save & Make Batch File” form shows.

Oracle to XML - create batch file

Click “OK” button, you’ll create a batch file, in Windows, like this:

C:
cd "C:\Users\pansh\AppData\Local\Programs\DBToFile"
DBToFile task="C:\Users\pansh\Documents\test.uld" logfile="C:\Users\pansh\Documents\test.log"

You can run this batch file in command line.

Download DBToFile Download DBToFile

Run as scheduled task for exporting Oracle to XML

You can run “Oracle to XML” conversion automatically at specific time.

On Linux/macOS, you can use Crontab.

For macOS, How to Fix Cron Permission Issues in macOS.

On Windows, in “Save & Make Batch File” form, you can click “Create & Schedule Task” to set a scheduled task.

Oracle to XML - create batch file

And then, with scheduled task wizard, step by step.

Oracle to XML - scheduled task application

You’ll see created task listed in scheduled task list.

Oracle to XML - scheduled task list

Download

Here you can download DBToFile, and buy DBToFile.

30-day free trial Download DBToFile