In a recent article we saw how to import an XML file in to an MS Access Application to create a table. Similarly another article discussed the exporting of an MS Access table to an XML file. Of the two processes, while the exporting is handled very easily by most programs, the importing appears to be not such a straightforward process. In SQL 2000 server, while the exporting of data to an XML file was handled by TSQL extensions easily, the importing of an XML file to a table was not just as easy. In Oracle 10G XE, a similar situation exists: the exporting is done quite easily, whereas importing requires a few more considerations. This article considers, both loading and unloading an XML file into the database using Oracle 10G XE.
Exporting a table to an XML file in Oracle 10G XE
From Start-->All Programs-->Oracle database 10G Express edition-->Go to database home page... you can get to the login page for the HR database as shown in the next picture.
This opens up the HOME of the HR database as shown in the next picture.
Now click on the Utilities icon to open the next window as shown.
Now click on the Data Load/Unload icon to take us to the next step as shown.
Now click on TO XML to open the following wizard as shown.