Re : Row Level Share Locks

From: <nr_5000_at_my-dejanews.com>
Date: Tue, 15 Sep 1998 06:38:25 GMT
Message-ID: <6tl211$2jb$1@nnrp1.dejanews.com>

Yeah, but what if I want to place the lock only on a subset of rows, not the whole table ?

Regards,
George

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

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Tue Sep 15 1998 - 01:38:25 CDT