SQL Language (MOSC)

MOSC Banner

Convert Text Equation to an 'actual' Equation?

edited Feb 26, 2014 6:02AM in SQL Language (MOSC) 10 commentsAnswered ✓
OK - Stretching, here - please give any guidance you can?


The query:

            SELECT  CONNECT_BY_ROOT(IXKIT) OSZ56ITMP, CONNECT_BY_ROOT(IXMMCU) OSZ56MCUP, LEVEL OSLEV,
              A.IXMMCU OSMMCU, A.IXKIT OSKIT, A.IXKITL OSKITL, A.IXCMCU OSCMCU,
              A.IXITM OSCPIT, A.IXLITM OSCPIL, A.IXQNTY OSQNTY, ('1' ||SYS_CONNECT_BY_PATH(a.ixqnty/10000, '*')) OSEXQTY
            FROM TESTDTA.F3002 A
              WHERE A.IXTBM='M' AND A.IXMMCU IN ('     2620001','     2740001') AND IXEFFF<114021 AND IXEFFT>114021
              START WITH A.IXKIT IN (SELECT DISTINCT D.SDITM FROM TESTDTA.F4211 D 
                WHERE  A.IXMMCU=D.SDMCU AND D.SDMCU IN ('     2620001','     2740001') AND D.SDNXTR<'560' AND D.SDPDDJ<115108 AND SDITM > 0 AND SDDOCO=12000034 )

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