how to lock a particupar column? [message #35892] |
Mon, 22 October 2001 13:55 |
lily
Messages: 44 Registered: September 2000
|
Member |
|
|
Is there any way to lock a particular column in a table?
thanks in advance.
lily
----------------------------------------------------------------------
|
|
|
Re: how to lock a particupar column? [message #35895 is a reply to message #35892] |
Mon, 22 October 2001 15:18 |
Todd Barry
Messages: 4819 Registered: August 2001
|
Senior Member |
|
|
-- lock column c3 for all rows
select c1, c2, c3 from t for update of c3 nowait;
-- lock column c3 for a particular row
select c1, c2, c3 from t where pk = :1 for update of c3 nowait;
----------------------------------------------------------------------
|
|
|