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.
Regards, Vijay Jamadade.
( Nothing is Impossible.)
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.
Regards, Vijay Jamadade.
( Nothing is Impossible.)
Gravity is a harsh mistress. But this tiny ad is pretty easy to deal with:
a bit of art, as a gift, the permaculture playing cards