Re: How to get a lock on single row

From: Frank van Bortel <f.van.bortel_at_vnl.nl>
Date: Wed, 30 Dec 1998 14:00:01 +0100
Message-ID: <368A23D0.455E3EB@vnl.nl>

Manoj Goel wrote:

> Hi guys,
>
> We are trying to get a lock on a single row so that next query does not
> see that row.
> Is it possible to do that in Oracle 7.3.(I don't want to commit as yet or
> update the data
> so that row is excluded)
>

Oracle will do that automatically - lock the row. Don't quite understand what you're trying to archieve... Any other user will either not see the row (when it is new), or see the old data (when it is in the process of being updated), until committed.
Excluding from a select is not done via locks, you should use a where-clause.

Kr, Frank Received on Wed Dec 30 1998 - 07:00:01 CST