Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Standard SQL?
johnnie_ng_at_hongkong.com <johnnie_at_hongkong.com.hk> wrote in article
<Pine.BSF.3.96.981119181810.12224C-100000_at_prima.netfront.net>...
>
> I want to know if the following SQL is standard:
>
> select 123, (select x from dummy)
> from dummy
>
>
>
>
not and its dont work (on 7.2)
but you can paly this
select 123, y.x
from dummy,(select x from dummy) y
Received on Thu Nov 19 1998 - 00:00:00 CST