I need to perform simulteneouse updates on the same table. I want to do something like one application instance will update some set of rows and other application instace will update another set of rows. But i am not sure how to do that?
I think i can use row id like one instace will update first 1000 row ids and another instace will update 1001 -2000 rowids. But as i need to delete rows so row id may not be constant always.
Please suggest better way of doing this. I hope i am able to explain requirement clearly.
Can I ask why you need to do this? It sounds quite like you are trying to hand craft behaviour that Oracle will provide without you needing to know how its done. Assuming you are identifying your data to update using primary keys there won't be a clash.