Wednesday, December 15, 2010

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

No comments: