Home » SQL & PL/SQL » SQL & PL/SQL » how to lock a particupar column?
how to lock a particupar column? [message #35892] Mon, 22 October 2001 13:55 Go to next message
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 Go to previous message
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;

----------------------------------------------------------------------
Previous Topic: Easy PL/SQL question... I'm new to this.
Next Topic: Re: converting a pl/sql rocedure into an exe file or any OS file
Goto Forum:
  


Current Time: Thu Apr 02 05:46:47 CDT 2020