RE: row level lock

From: Grabowy, Chris <cgrabowy_at_fcg.com>
Date: Thu, 07 Mar 2002 09:18:33 -0800
Message-ID: <F001.00422185.20020307091833@fatcity.com>

Please correct me if I am wrong, but wouldn't you want to use the following...  

FOR UPDATE NOWAIT   if the row is being updated/locked, you can report that to the user, and re-query the data to ensure they still want to update it. Otherwise, with just FOR UPDATE, the first update gets overwritten by the second (waiting) update without either user's knowledge.  

IMHO   Chris

-----Original Message-----
Sent: Thursday, March 07, 2002 10:58 AM
To: Multiple recipients of list ORACLE-L

Shishir,  

When you make the select statement at the end add the clause FOR UPDATE  

SELECT FIELD1, FIELD2 FROM TABLE
     WHERE
FIELD1 = 40
    FOR UPDATE   Luck,    

-----Original Message-----
Sent: Thursday, 07 March, 2002 10:03 AM
To: Multiple recipients of list ORACLE-L

HI list!
  I want to lock a table on row level ( not table level) . how do we pass the pass that value in syntax which will lock only those rows. plz make me understand by giving an example.  

thanx in advance..
Shishir Kumar Mishra
Agni Software (P) Ltd.,
Bangalore-560055, India
www.agnisoft.com <http://www.agnisoft.com>

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Grabowy, Chris
  INET: cgrabowy_at_fcg.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu Mar 07 2002 - 11:18:33 CST