| Loading XML data into a table [message #401363] |
Mon, 04 May 2009 04:50  |
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 #401368 is a reply to message #401363] |
Mon, 04 May 2009 05:42  |
 |
Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
|
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 |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
