Home -> Usenet -> comp.databases.oracle -> Missing Expression in 8.0.4, but not 8.1.6

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> 






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


    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



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












Original text of this message