Re: oracle query
From: Erwin Dzienis <edzienis_at_eragsm.com.pl>
Date: Tue, 10 Apr 2001 18:39:32 +0200
Message-ID: <3AD33744.619E6CA2_at_eragsm.com.pl>
Date: Tue, 10 Apr 2001 18:39:32 +0200
Message-ID: <3AD33744.619E6CA2_at_eragsm.com.pl>
I assume that you want sqrt(4), that's right? So use just sqrt (like this: select sqrt(4) from dual;).
I see no chance for any usefull select from dual when you would try to use column name (any symbolic name after select is column name).
Erwin
Aloha Kakuikanu wrote:
> I queried oracle
>
> select x from dual where x*x=4
>
> but got "invalid column name".
>
> Thank you for your suggestions.
> Aloha
>
> Sent via Deja.com
> http://www.deja.com/
Received on Tue Apr 10 2001 - 18:39:32 CEST