Re: q: diffrence between row_shared and row_exclusive lock ?

On 19 Jul 2002 23:17:36 -0700, tedchyn_at_yahoo.com (Ted Chyn) wrote:

>all,
>
>row shared lock lmode=2
>row exclusive lock lmode=3
>
>row shared is more restrictive than row exclusive.
>row shared can be generated with select ... for update of
>row exclusive can be generated with lock table in row exclusive mode
>or update statement.
>
>
>
>Can any one give me an working example explaining what are difference
>between these two type locks - in terms why one is more restritive
>than the other?
>
>thnx in advance
>ted chyn

row share: others can read
rows exclusive: access is completely blocked

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Sat Jul 20 2002 - 03:16:50 CDT