Loading and Unloading XML Files Using Oracle 10G XE - From Table to XML
(Page 2 of 4 )
Here you choose a Schema HR and from the HR database choose a table, and then export it. You can save it to an XML file. It is as simple as that. There is no need to script any SQL statement. If you need to export a smaller number of columns in the table, the wizard allows you to do this as well. Now click on the Next button to open the next window. Click on the drop-down related to Table and from the drop-down list choose the Departments table as shown.
Click on the Next button to open the next window where you may choose the columns. We choose all the columns and also click on the Export as file check box.
Now click on Unload Data. This opens up the following message.
If you choose to save the file, it gives you the file name by which it is saved. The Desktop directory was chosen to save the file; it gets saved there.
Voila, you have an XML file which may be opened from the browser as shown. Nothing can be simpler than this.
If you did not choose to export and left the check box unchecked, it will unload the XML file to the browser right away as shown. The returned XML is a well formed XML document with a root element of ROWSET enclosing the ROW Elements. Each ROW element corresponds to a row in the table. The table name is not displayed except for its structure as found on the table.
At this point you may be interested in looking at the table structure to verify the XML against it as shown in the next picture.
Next: Importing an XML File into Oracle 10G XE >>
More Oracle Articles
More By Jayaram Krishnaswamy
