SELECT FOR UPDATE - Oracle - Oracle - Toad World

When you issue a SELECT...FOR UPDATE statement, the RDBMS automatically obtains exclusive row-level locks on all the rows identified by the SELECT statement, holding the records “for your changes only” as you move through the rows retrieved by the No ...

www.toadworld.com