Re: ora-936: version differences

"Antti Järvinen" <costello_at_iki.fi> wrote in message news:m3sncfkjfu.fsf_at_muikku.baana.suomi.net...
> Dear Sirs,
>
> any ideas why
> select hiredate from emp where hiredate =
> (
> select min(hiredate) from emp where hiredate in
> (
> ( to_date('18.10.2001 15:11:58','dd.mm.yyyy hh24:mi:ss') -
> (select min(abs(hiredate-
> to_date('18.10.2001 15:11:58','dd.mm.yyyy hh24:mi:ss'))) from emp)
> )
> ,
> ( to_date('18.10.2001 15:11:58','dd.mm.yyyy hh24:mi:ss') +
> (select min(abs(hiredate-
> to_date('18.10.2001 15:11:58','dd.mm.yyyy hh24:mi:ss'))) from emp)
> )
> )
> ) ;
>
> returns a time with server version 816 and ora-936 on 734 and 804 I also
> tried? there is nothing very special about the query, isn't there?
>
> --
> Antti Järvinen, costello_at_iki.fi
> "concerto for two faggots and orchestra"

You are using inline views in your in statement in a fashion which definitely isn't available in 7.3.4. I've never used 8.0.4, but I know 8i has been greatly enhanced with respect to inline views Basically you can use inline views in 7.3.4 in your from clause only, NOT in a select clause and NOT in a subquery.

Hth,

Sybrand Bakker
Senior Oracle DBA Received on Fri Oct 19 2001 - 12:11:17 CDT