Bulk Updates in Oracle from XML File

[Kiran Dalvi]

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

[FaheemRao]

Re: Bulk Updates in Oracle from XML File

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



rayoflight_kira n@yahoo.com (Kiran Dalvi) wrote in message news:<b33f94a.0 312112034.8499f 4a@posting.goog le.com>...

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

[Kiran Dalvi]

Re: Bulk Updates in Oracle from XML File

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