How to Lock a column?

From: <wy_at_fudan.edu>
Date: Fri, 05 Nov 1999 10:22:42 GMT
Message-ID: <7vub5g$d0t$1@nnrp1.deja.com>

I have a table : T1
Create Table T1

(f1 char(10),
 f2 char(20),
 f3 char(20)

);

and I Want to lock the field f2.
I use 'Select f2 from t1 for update of f2';

In another connection.
I use 'Select f1 from t1 for update of f1';

and it lock!
when I commit the first connection.
it unlock;

then how to lock the column f2 and not lock the column f1?

I use oracle 8.0.5 for linux.

Any suggestions are helpful!

Thanks in advance.

YangWang.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Nov 05 1999 - 04:22:42 CST