Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Insert into with nowait?
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 - 08:19:14 CST