Where Current OF

• 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.
• When the session opens a cursor with the FOR UPDATE clause, all rowsin the return set will hold row-level exculsive locks. Other sessions can only query the rows, but they cannot update, delete, or select withFOR UPDATE.
• Allows the developer to lock a set of Oracle rows for the duration of a transaction
• Subqueries cannot have this clause