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

Loading and Unloading XML Files Using Oracle 10G XE

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

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.



 
 
>>> 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: