top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

Oracle: "for update clause" and then using using "update?

0 votes

What are the advantage and disadvantages of using a select for update in a cursor Using the "for update clause" and then using useing "update... for current cursor" is a good way to make sure that no one else is changing the rows you are working with.

posted Feb 2, 2015 by Archana

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

If you use this then you cannot issue a commit within the loop. A commit will release all locks and invalidate your cursor.

answer Feb 3, 2015 by Arun Gowda