FOR UPDATE in Oracle

Published on by LakshmiSaahul,Dhana Royal

What is the purpose of FOR UPDATE?

Selecting in FOR UPDATE mode locks the result set of rows in update mode, which means that row cannot be updated or deleted until a commit or rollback is issued which will release the row(s). If you plan on updating or deleting records that have been referenced by a Select For Update statement, you can use the Where Current Of statement.

Advertising
To be informed of the latest articles, subscribe:
Comment on this post