Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
exclusive locks
- Thread starter teakandme
- Start date
Yes and yes.
SELECT * FROM my_table FOR UPDATE;
will throw a lock on each row it selects.
However, Oracle's mantra is "Readers don't block writers, and writers don't block readers". Another select statement can run since it looks but doesn't actually touch anything.
SELECT * FROM my_table FOR UPDATE;
will throw a lock on each row it selects.
However, Oracle's mantra is "Readers don't block writers, and writers don't block readers". Another select statement can run since it looks but doesn't actually touch anything.
- Status
Similar threads
