Re: oracle query

From: Vadim Tropashko <vadimtro_at_yahoo.com>
Date: Fri, 02 Feb 2001 17:20:37 GMT
Message-ID: <95eq8n$8o2$1@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 - 11:20:37 CST