OraFAQ Forum: JDeveloper, Java & XML » Loading XML in Oracle table

Home » Developer & Programmer » JDeveloper, Java & XML » Loading XML in Oracle table (oracle 11g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Loading XML in Oracle table [message #628535]

Wed, 26 November 2014 02:28

jaggy
Messages: 15
Registered: November 2014
Location: India

Junior Member

I have one XML file and want to load it into one oracle table. Can any body suggest how to do it? I tried using SQL Loader but it is not working.
The table is having 3 columns as below. I have attached the file and given some records also.

desc temp_trade_xml
Name Null Type
---------------- ---- ------------
CUSTOMER_WHSLRNO NUMBER(38)
ID VARCHAR2(50)
TDLINK VARCHAR2(50)

Data:

<?xml version="1.0" encoding="utf-8" ?>
- <TradePrograms Version="1.0">
- <TradeProgram Name="Heavy Trade Brew Appétit - On-Premise 2015" ID="15801">
<Customer WhslrNo="11206" ID="M0496" TDLink="A-5002905" />
<Customer WhslrNo="11206" ID="M0573" TDLink="A-5002778" />
<Customer WhslrNo="11206" ID="M1242" TDLink="A-1930648" />
</TradeProgram>
</TradePrograms>

[Updated on: Wed, 26 November 2014 02:28]

Report message to a moderator

[Message index]

		Loading XML in Oracle table By: jaggy on Wed, 26 November 2014 02:28
		Re: Loading XML in Oracle table By: Michel Cadot on Wed, 26 November 2014 02:30
		Re: Loading XML in Oracle table By: Michel Cadot on Wed, 26 November 2014 02:37
		Re: Loading XML in Oracle table By: Michel Cadot on Wed, 26 November 2014 02:59
		Re: Loading XML in Oracle table By: jaggy on Wed, 26 November 2014 03:17
		Re: Loading XML in Oracle table By: Michel Cadot on Wed, 26 November 2014 03:48
		Re: Loading XML in Oracle table By: jaggy on Wed, 26 November 2014 07:52
		Re: Loading XML in Oracle table By: Michel Cadot on Wed, 26 November 2014 08:22
		Re: Loading XML in Oracle table By: jaggy on Wed, 26 November 2014 08:49
		Re: Loading XML in Oracle table By: Barbara Boehmer on Wed, 26 November 2014 23:10
		Re: Loading XML in Oracle table By: jaggy on Fri, 06 March 2015 06:04
		Re: Loading XML in Oracle table By: Michel Cadot on Fri, 06 March 2015 10:50
		Re: Loading XML in Oracle table By: Barbara Boehmer on Fri, 06 March 2015 15:47
		Re: Loading XML in Oracle table By: Barbara Boehmer on Fri, 06 March 2015 16:15
		Re: Loading XML in Oracle table By: jaggy on Sat, 07 March 2015 02:08
		Re: Loading XML in Oracle table By: Michel Cadot on Sat, 07 March 2015 03:01
		Re: Loading XML in Oracle table By: jaggy on Sat, 07 March 2015 03:09
		Re: Loading XML in Oracle table By: Michel Cadot on Sat, 07 March 2015 03:13
		Re: Loading XML in Oracle table By: jaggy on Fri, 30 September 2016 08:42
		Re: Loading XML in Oracle table By: Barbara Boehmer on Sat, 07 March 2015 04:05
		Re: Loading XML in Oracle table By: Michel Cadot on Sat, 07 March 2015 04:14
		Re: Loading XML in Oracle table By: Barbara Boehmer on Sat, 07 March 2015 04:26
		Re: Loading XML in Oracle table By: Barbara Boehmer on Sat, 07 March 2015 04:34
		Re: Loading XML in Oracle table By: Michel Cadot on Sat, 07 March 2015 04:43
		Re: Loading XML in Oracle table By: jaggy on Thu, 27 November 2014 04:50
		Re: Loading XML in Oracle table By: Michel Cadot on Thu, 27 November 2014 05:43

Previous Topic:	List all Tag and Field Names in XML
Next Topic:	ORA-01780 string literal required error while fetching data from xml table.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 24 13:03:04 CDT 2024