From: Vadim Tropashko <vadimtro@yahoo.com>
Newsgroups: comp.databases.theory
Subject: Re: oracle query
Date: Fri, 02 Feb 2001 17:20:37 GMT
Organization: Deja.com
Lines: 22
Message-ID: <95eq8n$8o2$1@nnrp1.deja.com>
References: <95ep49$7ih$1@nnrp1.deja.com>
NNTP-Posting-Host: 205.227.43.12
X-Article-Creation-Date: Fri Feb 02 17:20:37 2001 GMT
X-Http-User-Agent: Mozilla/4.0 (compatible; MSIE 5.0; Windows NT; DigExt)
X-Http-Proxy: 1.0 x64.deja.com:80 (Squid/1.1.22) for client 205.227.43.12
X-MyDeja-Info: XMYDJUIDvadimtro


In article <95ep49$7ih$1@nnrp1.deja.com>,
  Aloha Kakuikanu <alohakaku@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/