Home arrow Oracle arrow Page 2 - Loading and Unloading XML Files Using Oracle 10G XE

From Table to XML - Oracle

In many cases, exporting a table to create an XML file is easy, but importing an XML file to create a table is much more difficult. This is true for Oracle 10G XE, as you will see in this article.

TABLE OF CONTENTS:
  1. Loading and Unloading XML Files Using Oracle 10G XE
  2. From Table to XML
  3. Importing an XML File into Oracle 10G XE
  4. Importing a simplified, contrived XML file
By: Jayaram Krishnaswamy
Rating: starstarstarstarstar / 6
December 20, 2006

print this article
SEARCH DEV SHED

TOOLS YOU CAN USE

advertisement

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.



 
 
>>> More Oracle Articles          >>> More By Jayaram Krishnaswamy
 

blog comments powered by Disqus
escort Bursa Bursa escort Antalya eskort
   

ORACLE ARTICLES

- Oracle Java Security Woes Continue
- Oracle's New IaaS Cloud Option: There's a Ca...
- Oracle Acquires Eloqua to Boost Cloud Presen...
- Choosing Innovation: Oracle Survey Insights
- Oracle Fixes Privilege Escalation Bug
- Oracle`s Communications Service Availability...
- Oracle Releases Exalytics, Taleo Plans
- Oracle Releases Communications Network Integ...
- Oracle Releases Communications Data Model 11...
- Oracle Releases PeopleSoft PeopleTools 8.52
- Oracle Integrates Cloudera Apache Distro, My...
- Oracle Releases MySQL 5.5.18
- Oracle Announces NoSQL Database Availability
- Sorting Database Columns With the SELECT Sta...
- Retrieving Table Data with the LIKE Operator

Developer Shed Affiliates

 


Dev Shed Tutorial Topics: