469,167 Members | 1,146 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,167 developers. It's quick & easy.

Bulk Updates in Oracle from XML File

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
2 4068
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
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.

Similar topics

2 posts views Thread by Diego | last post: by
2 posts views Thread by Niraj | last post: by
16 posts views Thread by Philip Boonzaaier | last post: by
1 post views Thread by Shiju Poyilil | last post: by
OuTCasT
reply views Thread by OuTCasT | last post: by
2 posts views Thread by Kiran Dalvi | last post: by
1 post views Thread by CARIGAR | last post: by
1 post views Thread by Mortomer39 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.