Home » SQL & PL/SQL » SQL & PL/SQL » ORA-00936: missing expression
ORA-00936: missing expression [message #352767] Thu, 09 October 2008 08:19 Go to next message
Messages: 10
Registered: July 2005
Location: South Africa
Junior Member
When run the following script returns an ORA-00936 missing expression error.
select MemNumber,
select mem_number MemNumber,
sum(trans_turnover) Turnover
from members
join transact
on mem_number = trans_code
where Trans_date between '&Start' and '&End'
and mem_barred = 0
group by mem_number
order by turnover desc
where rownum <=200

Please tell me how I should fix it.
Re: ORA-00936: missing expression [message #352770 is a reply to message #352767] Thu, 09 October 2008 08:38 Go to previous message
Michel Cadot
Messages: 63924
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Indent the code (See SQL Formatter).
Use the "Preview Message" button to verify.
Also always post your Oracle version (4 decimals).

Use SQL*Plus and copy and paste your session, it will tell you at which line there is the error.


Previous Topic: Query when we have a method in table definition
Next Topic: Associative Arrays and nested tables
Goto Forum:

Current Time: Wed Oct 26 08:25:27 CDT 2016

Total time taken to generate the page: 0.13968 seconds