OraFAQ Forum: JDeveloper, Java & XML » Need to insert data from XML file into Oracle Table (very urgent)

Home » Developer & Programmer » JDeveloper, Java & XML » Need to insert data from XML file into Oracle Table (very urgent) (Oracle 11g)

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

Need to insert data from XML file into Oracle Table (very urgent) [message #651769]

Tue, 24 May 2016 22:09

tolupuluri
Messages: 21
Registered: May 2016

Junior Member

Hi All,

I have sample XML file as below:
Please send me the Oracle procedure to insert this data into the table

<?xml version="1.0" encoding="UTF-8" ?>
<badges>
<row UserId="3718" Name="Teacher" Date="2008-09-15T08:55:03.923"/>
<Reading TimeStamp="2016-03-01 08:30:00" RawReading="0" />
<Reading TimeStamp="2016-03-01 08:35:00" RawReading="0.1" />
<Reading TimeStamp="2016-03-01 08:40:00" RawReading="0.2" />
<row UserId="994" Name="Teacher" Date="2008-09-15T08:55:03.957"/>
<Reading TimeStamp="2016-03-01 08:30:00" RawReading="0.3" />
<Reading TimeStamp="2016-03-01 08:35:00" RawReading="0.4" />
<Reading TimeStamp="2016-03-01 08:40:00" RawReading="0.2" />
</badges>

[Updated on: Tue, 24 May 2016 22:10]

Report message to a moderator

[Message index]

		Need to insert data from XML file into Oracle Table (very urgent) By: tolupuluri on Tue, 24 May 2016 22:09
		Re: Need to insert data from XML file into Oracle Table (very urgent) By: BlackSwan on Tue, 24 May 2016 22:22
		Re: Need to insert data from XML file into Oracle Table (very urgent) By: tolupuluri on Tue, 24 May 2016 22:27
		Re: Need to insert data from XML file into Oracle Table (very urgent) By: BlackSwan on Tue, 24 May 2016 22:41
		Re: Need to insert data from XML file into Oracle Table (very urgent) By: tolupuluri on Tue, 24 May 2016 22:52
		Re: Need to insert data from XML file into Oracle Table (very urgent) By: Barbara Boehmer on Wed, 25 May 2016 01:57
		Re: Need to insert data from XML file into Oracle Table (very urgent) By: tolupuluri on Wed, 25 May 2016 10:49
		Re: Need to insert data from XML file into Oracle Table (very urgent) By: Michel Cadot on Wed, 25 May 2016 11:16
		Re: Need to insert data from XML file into Oracle Table (very urgent) By: tolupuluri on Wed, 25 May 2016 12:59
		Re: Need to insert data from XML file into Oracle Table (very urgent) By: Michel Cadot on Wed, 25 May 2016 13:35
		Re: Need to insert data from XML file into Oracle Table (very urgent) By: Barbara Boehmer on Wed, 25 May 2016 14:08
		Re: Need to insert data from XML file into Oracle Table (very urgent) By: tolupuluri on Wed, 25 May 2016 15:01
		Re: Need to insert data from XML file into Oracle Table (very urgent) By: Michel Cadot on Wed, 25 May 2016 00:08

Previous Topic:	Using XML to insert into a table with self-reference
Next Topic:	How to download Plugins for offline installation for Firefox and Internet Explorer to run Fusion Middleware Forms 11g in client pc's not having Internet Access?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 02:20:49 CDT 2024