Re: SELECT - NOWAIT ...

From: K POON <kspoon_at_netvigator.com>
Date: Fri, 20 Nov 1998 21:30:46 +0800
Message-ID: <36556F06.27F3BAA9@netvigator.com>

Rajesh,

In Oracle, same user can open multiple sessions, and each session can lock the same row using different mode, shared read, exclusive lock, etc. Oracle respects sessions rather than users.

K POON. Rajesh Bhave wrote:

> 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 - 07:30:46 CST