Re: Insert into with nowait?

Nicolas Bronke <NBronke_at_t-online.de> wrote in article <71v0h2$hir$1_at_news00.btx.dtag.de>...
> The statement
> select * from table where id=:id for update nowait
> prevents that a update or delete my hang, because another user had
already
> locked this record.
> Does exist such a possibility also for the insert into command?

you can lock table before insert like this  lock table name in exclusive mode nowait; Received on Fri Nov 06 1998 - 08:54:22 CST