Re: Insert into with nowait?

Sure that could be a way but in a multi-user environment (several users) working with the data (updates, inserts etc.) you cannot insert any record if another user updates one record which he has locked before (select * from table where-condition for update nowait).

Regards
Nicolas Bronke

victor schrieb in Nachricht <01be0995$49a77180$6b14abcc_at_victor>...
>you can lock table before insert like this
> lock table name in exclusive mode nowait;
Received on Sun Nov 08 1998 - 05:58:39 CST