Re: oracle query

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 - 11:39:32 CDT