Re: Row level share locks ?

<6tirgo$ger$1_at_nnrp1.dejanews.com> >>>> Is it possible to acquire a row level share lock in Oracle ? So that no one could modify a row and multiple sessions could place this kind of lock on certain rows ? <<<<

Yes, if you issue the 'lock table in share mode' command. This will cause any update against the table to wait so you may not want to do this, but if you need to freeze out updaters then this will do it.

Mark Powell -- Oracle 7 Certified DBA
- The only advice that counts is the advice that you follow so follow your own advice - Received on Mon Sep 14 1998 - 18:09:35 CDT