Oracle PL/SQL – SELECT FOR UPDATE Statement

When you execute SELECT FOR UPDATE statement, database acquires row level lock automatically against all the rows in the CURSOR result set. Locks on the...