Missing Expression in 8.0.4, but not 8.1.6
From: Eric Esterling <EEsterling_at_mediaone.net>
Date: Mon, 03 Dec 2001 16:55:47 GMT
Message-ID: <n8OO7.3609$qI.2763713_at_typhoon.ne.mediaone.net>
ERROR at line 2:
ORA-00936: missing expression
Date: Mon, 03 Dec 2001 16:55:47 GMT
Message-ID: <n8OO7.3609$qI.2763713_at_typhoon.ne.mediaone.net>
Query: return names and salaries of people who earn more than 90% of the maximum salary.
*
ERROR at line 2:
ORA-00936: missing expression
This variation works fine:
SQL> select name, salary from staff
2 where salary >= (select .9*max(salary) from staff);
However, more complex queries aren't so easily resolved.
Is this a bug in 8.0.4?
It seems very basic and surprises me.
There are other similar peculiarties in the 8.0.4 installation.
Is 8.0.4 just buggy or could there be something screwy
in our installation/configuration parameters?
Received on Mon Dec 03 2001 - 17:55:47 CET