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
stockton
Messages: 10
Registered: July 2005
Location: South Africa
Junior Member
When run the following script returns an ORA-00936 missing expression error.
select MemNumber,
Turnover
from
(
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: 64151
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.

Regards
Michel

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


Current Time: Fri Dec 09 19:25:08 CST 2016

Total time taken to generate the page: 0.28795 seconds