Define the Cursor lock types?

 Updated on October 28, 2014     VIKRAM     648

Three types of locks:

READ ONLY:

This prevents any updates on the table. 

SCROLL LOCK:

This allows you to make changes to the table.

OPTIMISTIC:

  • This checks if any change in the table record since the row fetched before updating. 
  • If there is no change, the cursor can update.

If you enjoyed this post, please like (or) share this article.


Comments