TurkBear <jgreco1_at_mn.rr.com> wrote in message news:<t8euiuo538q9ho7mcep5qt8bdk9bje0vrt_at_4ax.com>...
> What version of SqlPlus do you have on the PC...
>
>
> rgaffuri_at_cox.net (Ryan Gaffuri) wrote:
>
> >I am using 8.1.7. I know that I need to change the compatibility
> >parameter in my init.ora to 8.1.7. I do that and I run the query that
> >Im posting below directly from the server and it works.
> >
> >I go back to my client PC and I get the same error I got before
> >changing the compatibility parameter. Do I have to make some kind of
> >setting change on my client PC?
> >
> >GAFFURIR_at_DEV> select col1, row
> > 2 from (select col1, rownum row
> > 3 from tab r
> > 4 where rownum < 31
> > 5 order by col1)
> > 6 where row > 10
> > 7 order by col1;
> >select carrier_id, row
> > *
> >ERROR at line 1:
> >ORA-00936: missing expression
>
8.1.7. Same as in on the server.
Received on Sat Jul 13 2002 - 18:27:43 CDT
