Re: help with select for update

From: hpuxrac <johnbhurley_at_sbcglobal.net>
Date: Thu, 15 Jan 2009 06:04:19 -0800 (PST)
Message-ID: <deeaf4ce-e107-448d-a8a9-2359aebd09af_at_w1g2000prm.googlegroups.com>

On Jan 14, 11:47 am, emdproduct..._at_hotmail.com wrote:

snip

> I can get the row without problem
>
> But when i do
> SQL>select count(*) from tableA where col=1 for update nowait;
> no rows selected
>
> I do not see any errors, and i can not get the lock neither.
>
> What could be wrong?
>
> Thanks for your help

select count(*) for update?

This has got to be a nomination for Oracle WTF ...

What exactly do you think Oracle might be able to lock on a count(*)? Received on Thu Jan 15 2009 - 08:04:19 CST