Oracle - REGEXP

SELECT APP_ID
     , APP_VERSION
     , FEATURE

  FROM (
        SELECT APP_ID
             , APP_VERSION
             , REGEXP_SUBSTR( FEATURE, '[^,]+', 1, LEVEL ) AS FEATURE
             , LEVEL AS LV
             , LAG( LEVEL, 1, 0 ) OVER( PARTITION BY APP_ID, APP_VERSION ORDER BY LEVEL ) AS LG --2
          FROM (
                SELECT APP_ID
                     , APP_VERSION
                     , FEATURE
                  FROM API_APP_DB
                 WHERE FEATURE IS NOT NULL --1
                )
        CONNECT BY REGEXP_SUBSTR(FEATURE, '[^,]+', 1, LEVEL ) IS NOT NULL
       )
 WHERE LV <> LG --3

 

아래와 같이 변환






 ','로 스플릿 해서 한행씩 나타내어줌