Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Hi how to multiple updates from different sessions on different rows on same table.

956118Jan 22 2015 — edited Jan 23 2015

Hi

I just want to understand if this is possible or not in oracle .I know that oracle will allow me to do concurrent updates on the same table .

Let us say i have a table with 100 entries. I need to split the rows into 3 sections ,   33 rows in each section , and update the each sections through  three different sessions in oracle  .

As we know that oracle will allow the multiple updates from different sessions ,as long as the rows update by session 1 are different from session 2 .

But in real time ,How can i achieve this?kindly help.

thanks ,

Srinivasa Prabhu .

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 20 2015
Added on Jan 22 2015
14 comments
4,710 views