SQL Language (MOSC)

MOSC Banner

Strange Start Connect Prior

edited Mar 4, 2014 2:48PM in SQL Language (MOSC) 5 commentsAnswered

Me, again

- fighting another issue with the Start Connect Prior Logic!

Script:

SELECT CONNECT_BY_ROOT(IXKIT) OSZ56ITMP,

  CONNECT_BY_ROOT(IXKITL) OSZ56LITM,

  LEVEL OSLEV,

  A.IXKIT,

  A.IXITM

FROM TESTDTA.F3002 A

WHERE A.IXTBM                     ='M'

AND IXEFFF                        <114037

AND IXEFFT                        >114037

  START WITH A.IXKIT              = 263273

AND IXMMCU                        ='     2740001'

  CONNECT BY NOCYCLE PRIOR A.IXITM=A.IXKIT

AND PRIOR A.IXCMCU                =A.IXMMCU

Now, look at the highlighted values.  I understood that the results should be passing the IXITM Value into the IXKIT Value, when the Level is Incremented.  There are a couple occasions where the IXITM number that 'should' be passed to the next row - is completely odd.  Look at the highlighted rows.  Am I missing something - or did I crash into a bug?

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