Oracle string to multiple row

실행쿼리

WITH t AS (
	SELECT 'A,B,C' OLD_VALS
	     , '1,2,3' NEW_VALS
	  FROM dual
)
SELECT REGEXP_SUBSTR(t.OLD_VALS, '[^,]+', 1, c1.COLUMN_VALUE) AS OLD_VAL
             , REGEXP_SUBSTR(t.NEW_VALS, '[^,]+', 1, c1.COLUMN_VALUE) AS NEW_VAL
          FROM t
             , TABLE(CAST(MULTISET(SELECT level FROM dual CONNECT BY level <= LENGTH(REGEXP_REPLACE(t.OLD_VALS, '[^,]+')) + 1) as sys.OdciNumberList)) c1

실행결과