Re: Missing Expression in 8.0.4, but not 8.1.6

From: Chris <christianboivin1_at_hotmail.com>
Date: 4 Dec 2001 13:26:42 -0800
Message-ID: <da20daf0.0112041326.697e0393_at_posting.google.com>


I think this feature
arrived at the same time (8.1.5) then
the command :
select (select 1 from dual) c1, (select 2 from dual) c2 from dual

try this for your 8.0.4 database
select name, salary from staff
where salary >= (select max(salary)*.9 from staff);

i don't have a 8.0.4 db here so i can't test

hth
Chris

"Eric Esterling" <EEsterling_at_mediaone.net> wrote in message news:<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 Tue Dec 04 2001 - 22:26:42 CET

Original text of this message