Home » Developer & Programmer » JDeveloper, Java & XML » Loading XML data into a table
Loading XML data into a table [message #401363] Mon, 04 May 2009 04:50 Go to next message
vamsikrishnag
Messages: 16
Registered: October 2008
Junior Member
Hi,

I have the following XML file

- <employeeinfo>
- <empdata>
<empno>100</empno>
<ename>abc</ename>
<sal>1522</sal>
</empdata>
- <empdata>
<empno>200</empno>
<ename>def</ename>
<sal>1000</sal>
</empdata>
- <empdata>
<empno>300</empno>
<ename>xyz</ename>
<sal>1220</sal>
</empdata>
</employeeinfo>

I would like to load this data into a table in oracle.

Table Structure:

empno number,
ename varchar2(50),
sal NUMBER

I came to know that it can be done using SQL LOADER.

Can anyone tell how this can be done, or there are other ways to do this
Re: Loading XML data into a table [message #401364 is a reply to message #401363] Mon, 04 May 2009 05:17 Go to previous messageGo to next message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
There are plenty of examples in the JDeveloper, Java & XML forum to which I move your topic, and in documentation and on Web.

Regards
Michel

[Updated on: Mon, 04 May 2009 05:19]

Report message to a moderator

Re: Loading XML data into a table [message #401368 is a reply to message #401363] Mon, 04 May 2009 05:42 Go to previous message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
received by PM
Hi Michel,

I am trying to load data using SQLLOADER.

Can you let me know the ctl file code fro processing XML file.

Precise the exact format of your file.
Is each line you posted a line of your file?
Does - at the beginning of the line really exist?
...

Is SQL*Loader really the tool you want to use? Isn't any solution that fit the requirement (loading the file) valid?

Regards
Michel

[Updated on: Mon, 04 May 2009 05:46]

Report message to a moderator

Previous Topic: query to fetch an xmls's absolute xpath and value
Next Topic: Install, Create and work XML DB Oracle 11g
Goto Forum:
  


Current Time: Fri Dec 02 16:18:38 CST 2016

Total time taken to generate the page: 0.25919 seconds