Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
The following SQL construct does not work in Informix 7.3
select a,b from
(select col1 a, col2 b from mytable)
This works in Oracle.
Is this part of SQL standard or an Oracle extension ?
TIA
↪ replying to vk02720
Art S. Kagel — — source: Usenet: comp.databases.informix
On Thu, 17 Jul 2003 11:40:27 -0400, vk02720 wrote:
> The following SQL construct does not work in Informix 7.3 select a,b
> from
> (select col1 a, col2 b from mytable)
>
> This works in Oracle.
> Is this part of SQL standard or an Oracle extension ?
>
> TIA
Non-standard to the level of SQL that Informix supports.
Art S. Kagel
"Art S. Kagel" <kagel@bloomberg.net> wrote in message news:<pan.2003.07.17.18.01.18.408954.15473@bloomberg.net>...
> On Thu, 17 Jul 2003 11:40:27 -0400, vk02720 wrote:
>
> > The following SQL construct does not work in Informix 7.3 select a,b
> > from
> > (select col1 a, col2 b from mytable)
> >
> > This works in Oracle.
> > Is this part of SQL standard or an Oracle extension ?
> >
> > TIA
>
> Non-standard to the level of SQL that Informix supports.
>
>
> Art S. Kagel
Thanks.
So what level of SQL standard does Informix support ? And again, is
this construct a SQL standard ( as compared to purely an Oracle
extension ) ?
Any good website for SQL standard ?
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.