Re: Insert into with nowait?

In short NO.

But consider - if you are inserting a new record how can another user have locked it before you inserted it?

PS Anyone who has read a lot about Einstein's theories need not reply!

Nicolas Bronke wrote in message <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?
>If I use insert into the command hangs until the other user made a
>commit/rollback before I get any answer.
>
>Kind regards
>Nicolas Bronke
>
>
Received on Fri Nov 06 1998 - 10:03:51 CST