Date: 12 Jun 2003 01:56:49 -0700
Message-ID: <2c8b4611.0306120056.21808339_at_posting.google.com>
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