ORA-00920 error on simple sql query !

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

.

Relevant Pages

  • Re: Stop SQL execution by disconnecting Database Connection ???
    ... I have a ASP/C# application that connect to Oracle database. ... issuing my SQL query if I close the browser or move into another page (ie ... execution (by disconnecting the present database connection ???). ...
    (microsoft.public.dotnet.languages.csharp)
  • Sample code request (C#)
    ... code to connect to an oracle database and do a sql query and load the ... re-write a VB6 app I did in the past to C# as a learning tool:) ...
    (microsoft.public.dotnet.framework.windowsforms.databinding)
  • DB Sample Code Request
    ... code to connect to an oracle database and do a sql query and load the ... re-write a VB6 app I did in the past to C# as a learning tool:) ...
    (microsoft.public.dotnet.languages.csharp)
  • Need sample to read from db
    ... I need a sample code in order to read/write from oracle database 9i, ... by using the ADO engine. ... (Visual Studio 6.0 - Visual C++). ... make sql query. ...
    (microsoft.public.vc.language)
  • Need sample to read from db
    ... I need a sample code in order to read/write from oracle database 9i, ... by using the ADO engine. ... (Visual Studio 6.0 - Visual C++). ... make sql query. ...
    (microsoft.public.vc.language)