Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Can I lock a Row in a Oracle Table ?
Thomas Kyte <tkyte_at_us.oracle.com> schrieb in im Newsbeitrag:
372aff43.2399249_at_192.86.155.100...
> >Can I lock a Row in a Oracle Table ? Or how can I handle one record
> >being change by two users ?
>
> select * from T where pk = value FOR UPDATE;
>
> will lock the row(s) selected.
>
and with the option nowait it will be returned a error-code immediatly
whether the record is already locked. Otherwise this command wait until the
record is unlocked.
Regards
Nicolas Bronke
Received on Fri Apr 30 1999 - 02:55:05 CDT