RE: row level lock

[Grabowy, Chris]

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----- From: Ramon E. Estevez [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 07, 2002 10:58 AM To: Multiple recipients of list ORACLE-L Subject: RE: row level lock 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----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Shishir Sent: Thursday, 07 March, 2002 10:03 AM To: Multiple recipients of list ORACLE-L Subject: row level lock 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