Re: Row level locking: how to do it?
From: Morten Kristiansen <morten.kristiansen_at_tele3.no>
Date: 1996/08/05
Message-ID: <3206C8B8.66A5_at_tele3.no>#1/1
Date: 1996/08/05
Message-ID: <3206C8B8.66A5_at_tele3.no>#1/1
Thomas J. Kyte wrote:
>
> select .... from Table where rowid = :block.rowid and c1 = :block.c1 ......
> for update nowait
> ^^^^^^^^^^^^^^^^^
OK, now you have locked the row.
How long will it stay locked ? Until you manually unlock it (if so, how), or until you commit the update ? Received on Mon Aug 05 1996 - 00:00:00 CEST