Re: oracle query
From: Vadim Tropashko <vadimtro_at_yahoo.com>
Date: Fri, 02 Feb 2001 17:20:37 GMT
Message-ID: <95eq8n$8o2$1_at_nnrp1.deja.com>
Date: Fri, 02 Feb 2001 17:20:37 GMT
Message-ID: <95eq8n$8o2$1_at_nnrp1.deja.com>
In article <95ep49$7ih$1_at_nnrp1.deja.com>,
Aloha Kakuikanu <alohakaku_at_yahoo.com> wrote:
> I queried oracle
>
> select x from dual where x*x=4
>
> but got "invalid column name".
>
Well, the correct answer you might find on oracle forum. But if you
still want to do it that way:
select x from (
select 1 as x from dummy
union
select 2 as x from dummy
union
select 3 as x from dummy)
where x*x=4
Sent via Deja.com
http://www.deja.com/
Received on Fri Feb 02 2001 - 18:20:37 CET