Regarding duplicate insert problem

[vijay jamadade]

Hi Ranchers,

I am inserting the csv data through java in oracle.I want to check the whether the data I am inserting already exists in
table or not in insert query itself. Can I do that.

Because checking through select query before inserting the data is making the application heavy.

thanks in advance.

[Jeanne Boyarsky]

Vijay,
There are two approaches:
1) Do a select first
2) Insert it anyway and fail on duplicate constraint

Which one you choose depends on the likelyhood of a duplicate occurring.

[vijay jamadade]

Insert any way does not work here because when exception occurs while inserting records one by one the code goes out of loop afterwards in java. And select first I think making the application heavy as for every insert it needs to be fire a query. How to handle that.