This content has been marked as final. Show 2 replies
More elaboration from another Oracle person....
If the subset of rows that need to be updated is known, he could use a SELECT...FOR UPDATE WHERE <conditions> followed by an UPDATE statement. The
SELECT FOR UPDATE places locks on the rows in question. The row locks will be released, when the UPDATE is COMMITted. The window
between the SELECT FOR UPDATE and the commit will determine the concurrency.