A record is locked only once. It does make no matter which user in which
application or computer the statement select .. for update nowait has been
send.
Therefore all other receive a error message
Rajesh Bhave schrieb in Nachricht <36556A84.60FA5DE6_at_india.hp.com>...
>Hi
>
>NOWAIT returns control to user if the SELECT statement attempts to lock
>a row that is locked by another user. But, what happens if the row is
>locked by the same user through other application. Since the user is
>same, what does Oracle do with NOWAIT in this case. Let me know.
>
>Thanx
>Rajesh
>
Received on Fri Nov 20 1998 - 10:16:13 CST
