전체 글
-
-
Oracle - REGEXPDog Foot/Oracle 2014. 5. 20. 16:10
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 ..
-