-
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]
-
I get this error in 8.1.7
SQL> select a.ename, nvl(a.deptno(+), 0), b.deptno
2 from emp a, dept b
3 where a.deptno(+) = b.deptno;
select a.ename, nvl(a.deptno(+), 0), b.deptno
*
ERROR at line 1:
ORA-30563: outer join operator (+) not allowed in select-list
-
(+) only makes sense in the WHERE clause. Remove it from the SELECT, GROUP BY and ORDER BY
- Chris
-
that's why I wonder why he says it works in 8i, funny
