Re: select ...for update wait

On 15 Dec 2004 09:04:05 -0800, "db2group88_at_yahoo.com" <db2group88_at_yahoo.com> wrote:

>i am using oracle 10g with patch set 1 ,
>but looks like this doesn't work, one session has the row lock, the
>other session wait forever.

which is exactly how it always have worked. The nowait option of the lock table statement and the select for update statement make the other session fail when it can't acquire a lock.

--
Sybrand Bakker, Senior Oracle DBA