SQL differences between 8i and 9i

Hi,

I've got an application running on Oracle 9i which used nested queries with aggregate functions. I now have to make the app run on Oracle 8.

This kind of query doesn't run anymore :

SELECT SUM(Count) AS GRAND_Total,
(SELECT SUM(Count) AS Total_OK FROM TABLE1 WHERE STATUS = 'OK' AND
VALUEDATE >= '20000613' AND VALUEDATE <= '20060507'),
(SELECT SUM(Count) AS Total_SKIP FROM TABLE1 WHERE STATUS = 'SKIP' AND
VALUEDATE >= '20000613' AND VALUEDATE <= '20060507'),
(SELECT SUM(Count) AS Total_HIT FROM TABLE1 WHERE STATUS <> 'OK' AND
STATUS <> 'SKIP' AND VALUEDATE >= '20000613' AND VALUEDATE <= '20060507')
FROM TABLE1 WHERE VALUEDATE >= '20000613' AND VALUEDATE <= '20060507'GROUP BY 1 It runs fine on 9i...

Any advice on how to convert this to work under 8i would be appreciated ...

tia,

Tom Received on Thu Jun 12 2003 - 10:56:49 CEST