Missing Expression in 8.0.4, but not 8.1.6
Date: Mon, 03 Dec 2001 16:55:47 GMT
Message-ID: <n8OO7.3609$qI.2763713_at_typhoon.ne.mediaone.net>
The following simple query doesn't work in SQL*Plus
8.0.4.0.0 but works fine in 8.1.6.0.0 (8i personal edition).
Query: return names and salaries of people who earn
more than 90% of the maximum salary.
SQL> select name, salary from staff
This variation works fine:
SQL> select name, salary from staff
However, more complex queries aren't so easily resolved.
Is this a bug in 8.0.4?
2 where salary >= .9*(select max(salary) from staff);
where salary >= .9*(select max(salary) from staff)
*
ERROR at line 2:
ORA-00936: missing expression
2 where salary >= (select .9*max(salary) from staff);
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