Re: SQL Select question

"Rob Panosh" <rob_panosh_at_asdsoftware.com> wrote in message news:<3e0728c2$1_at_nntp01.splitrock.net>...
> Hello,
>
> The following select statement will select all rows from myTable for UPDATE
> and all other users will be blocked until I close the select statement.
>
> Select * from myTable FOR UPDATE WHERE rowstate = 'Posted'
>
> Now if any new rows are added with rowstate of 'Posted' no other users will
> be able to select them for update. Does anybody know how to get around
> this?
>
> I essentally want the user to be able to lock a set of rows do some
> processing then update them, change rowstate to 'Processed' or is there
> anyway I can detect which rows are locked?
>
>
> Thanks,
> Rob Panosh

i had a similar question which tom kyte provided a suggestion for, have a look here.......

http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:6908966507947

steve Received on Mon Dec 30 2002 - 05:48:57 CET