Re: ORA-00920 error on simple sql query !

From: Maxim Demenko <mdemenko_at_arcor.de>
Date: Fri, 11 Aug 2006 16:53:34 +0200
Message-ID: <44dc9b91$0$5121$9b4e6d93@newsspool2.arcor-online.net>

samir.vds_at_googlemail.com schrieb:
> Hey,
>
> I just started my first job last week.
>
> Anyway, I want to run the following sql query on an Oracle database:
>
> select client , kunde , kunden_name , projekt , projekt_name ,
> angebot , auftrag , bestell_betrag ,
> bestell_datum ,
> erloese , konto , konto_name , buch_periode ,
> buch_datum
> , beleg , lstart , projekt_ende ,
> projekt_erstellt ,
> projekt_status
> from HAUFB0363
> where ( bestell_betrag - erloese ) <> 0
>
> I get the error message: ORA-00920 invalid relational operator.
> But with my SQL tool called "TOAD" the query works fine !
>
>
> I'd appreciate any help
>
> Samir
>

I don't see any syntactical errors in your query. Could you provide the output from sqlplus session where you get this error (i assume, you use sqlplus).

Best regards

Maxim
PS feel free to tell your database version Received on Fri Aug 11 2006 - 09:53:34 CDT