Row is reserved word.
rgaffuri_at_cox.net (Ryan Gaffuri) wrote in message news:<1efdad5b.0207121150.70b0457b_at_posting.google.com>...
> 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
Received on Sun Jul 14 2002 - 19:57:47 CDT
