SQL Language (MOSC)

MOSC Banner

ORA-3113 on FULL OUTER JOIN

edited Aug 29, 2010 7:44PM in SQL Language (MOSC) 10 commentsAnswered
 Hi all!
First of all, I don't know if this is the right community (topic) for this problem.

We have three cases with Oracle9iR2 9.2.0.6 and in two off them creation of a view with outer join fails (I know that 9.2.0.6 isn't really up-to-date):

CREATE or replace VIEW NKFAV83
( KU,
  HJ,
  FPL_JAHR,
  BETRAG) AS
SELECT KU, HJ, FPL_JAHR,
       SUM(CASE
                WHEN (BETRAG IS NULL)  THEN 0
                ELSE BETRAG
             END)
  FROM NKFAV02
WHERE MITTART = 'VE'
GROUP BY  KU , HJ , FPL_JAHR
;
 
CREATE or replace VIEW NKFKO97
(KU, HJ, PLANJAHR, VE)
AS
SELECT   NKFKO82.KU, NKFKO82.HJ, NKFKO82.PLANJAHR,
         SUM(CASE

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center