| Copyright © 2003, 2008, Oracle. All rights reserved. |  Previous |
 Next |
Home > Using Oracle Application Ex... > Loading and Unloading Data ... > Unloading Data
You can use the Unload page to export the contents of a table to a text file or XML document.
Topics:
Use the Unload to Text Wizard to export the contents of a table to a text file. For example, you could export an entire table to a comma-delimited file (.csv).
To unload a table to a text file:
On the Workspace home page, click the Utilities icon.
Click Data Load/Unload.
Click Unload.
Click Unload To Text.
The Unload to Text Wizard appears.
Follow the on-screen instructions.
You select the schema and choose the table and columns to be exported. You can also specify the type of separator to be used to separate column values as well as whether column text strings are identified using single or double quotation marks.
Use the Unload to XML Wizard to export the contents of a table to an XML document adhering to the Canonical XML specification.
To unload a table to an XML document:
On the Workspace home page, click the Utilities icon.
Click Data Load/Unload.
Click Unload.
Click Unload to XML.
Follow the on-screen instructions.
You select the schema and choose the table and columns to be exported.