| 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;
----------------------------------------------------------------------
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
