Then try a "select rows ..... for update"
nr_5000_at_my-dejanews.com wrote in message
<6tl211$2jb$1_at_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 - 07:36:54 CDT
