By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,501 Members | 1,859 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,501 IT Pros & Developers. It's quick & easy.

Bulk Updates in Oracle from XML File

P: n/a
Hi,

Does anybody know how to update Bulk Data into Oracle Database,
efficiently ?
{e.g. 1000+ rows in a table need to modified / Added, with Data coming in
the form of a XML File.}

Please let me know if anyone has the solution.
--Kiran
Jul 19 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Kiran,

What you exatly mean by bulk data update.?

There are number of ways you can insert in Oracle Database.

FOr updating you can use update or select for update statement.

And 1000+ does not seems to be a very big number, unless you have very big rowsize.


Please explain in a little detail.
Faheem

ra**************@yahoo.com (Kiran Dalvi) wrote in message news:<b3************************@posting.google.co m>...
Hi,

Does anybody know how to update Bulk Data into Oracle Database,
efficiently ?
{e.g. 1000+ rows in a table need to modified / Added, with Data coming in
the form of a XML File.}

Please let me know if anyone has the solution.
--Kiran

Jul 19 '05 #2

P: n/a
Hi Faheem,

I am getting the data in XML file format. The amount of data is
huge.
I want to parse the XML (in Java) and ctreate Data Objects (DOs) out
of it.
Number of such DOs is typically around 30000+ Thus now I want to
add the information in these DOs into Database. In other words, I want
to insert 30000+ rows in Database.
Let me know how it can be done efficiently. I know the conventional
methods like INSERT or SELECT FOR UPDATE.
In short, I want to update this bulk data into Database at a shot.
I am using Java as a programming language. So I guess, options related
to scripting are not feasible. (In my Opinion)

Thanks,
Kiran
Jul 19 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.