-
Hi Guys,
The following query is working fine in oracle 7.3 and oracle 8i but not working in 9i. Can you tell me why? The outer joint in SELECT statement is not allowed..thats what 9i complaining but it was fine for 8i.
Thanx in advance
Devang
SELECT C.COUNTER_ID,
C.COUNTER_SUBTYPE_ID,
NVL(CS.PRINT_SEQ(+),0),
NVL(CS.COUNTER_SUBTYPE_DESC(+),
C.COUNTER_ID || ' ' ||
C.COUNTER_SUBTYPE_ID || ' no description'),
NVL(CS.PRINT_FORMAT(+),' '),
SUM(NVL(C.COUNTER_VALUE,0))
FROM COUNTER_DETAIL C,
COUNTER_SUBTYPE CS
WHERE TO_NUMBER(C.COUNTER_OWNER_ID) = 6508
AND C.COUNTER_ID = CS.COUNTER_ID(+)
AND C.COUNTER_SUBTYPE_ID = CS.COUNTER_SUBTYPE_ID(+)
GROUP BY C.COUNTER_ID, C.COUNTER_SUBTYPE_ID, CS.PRINT_SEQ(+),
CS.COUNTER_SUBTYPE_DESC(+), CS.PRINT_FORMAT(+)
ORDER BY CS.PRINT_SEQ(+), C.COUNTER_ID, C.COUNTER_SUBTYPE_ID
/
[Edited by DevangP on 10-03-2002 at 02:43 PM]
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|