SELECT column_a ,REGEXP_SUBSTR(column_b, '[^,]+', 1, LEVEL) AS split_value
FROM abc CONNECT BY LEVEL <= REGEXP_COUNT(column_b, ',') + 1 ORDER BY 
column_a;