Home » Developer & Programmer » JDeveloper, Java & XML » load xml file in oracle table (Oracle9i Release 9.2.0.5.0 - Windows 2003)
load xml file in oracle table [message #416756] Tue, 04 August 2009 04:30 Go to next message
rahul_bahulekar
Messages: 18
Registered: January 2007
Junior Member
Hi,

my requirement is to load the XML file [file size around 10 mb] into table.

sample XML data is -

- <Filings xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="~\filings.xsd">
- <Entity>
<EntityID>00401890X</EntityID>
- <Filings>
<FilingDate>1998-09-16T00:00:00</FilingDate>
<FilingType>REVOK</FilingType>
<FilingID>34676636</FilingID>
</Filings>
</Entity>
- <Entity>
<EntityID>00404120X</EntityID>
- <Filings>
<FilingDate>1998-06-16T00:00:00</FilingDate>
<FilingType>REVOK</FilingType>
<FilingID>34641101</FilingID>
</Filings>
</Entity>
- <Entity>
<EntityID>00600730X</EntityID>
- <Filings>
<FilingDate>1998-09-16T00:00:00</FilingDate>
<FilingType>REVOK</FilingType>
<FilingID>34676636</FilingID>
</Filings>
</Entity>
- <Entity>

i have goolgled to load XML data to oracle table i come to know about XDLDOM, XDK.

Can some help me so that i can load this xml file into table.

Thankx,
Rahul
Re: load xml file in oracle table [message #416762 is a reply to message #416756] Tue, 04 August 2009 04:41 Go to previous messageGo to next message
ThomasG
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
SQL*Loader can load XMLTypes.

Multiple examples are in Shouvik Basu's blog..

Once you have the XMLType in the Database you can extract the relational data. (Different examples also in the blog post.)
Re: load xml file in oracle table [message #416764 is a reply to message #416762] Tue, 04 August 2009 04:45 Go to previous message
ThomasG
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
PS: Don't multi-post your question, I have deleted the other copies.
Previous Topic: Retrieve the project which belongs to logged on user
Next Topic: how to install xdk_plsql_9_2_0_5_0
Goto Forum:
  


Current Time: Thu Mar 28 20:18:46 CDT 2024