WITH csv
AS (SELECT 'AA,BB,CC,D33D,EE,FFDD,MM,GG' AS csvdata FROM DUAL)
SELECT REGEXP_SUBSTR (csv.csvdata, '[^,]+', 1, LEVEL) pivot_char
FROM DUAL, csv
CONNECT BY REGEXP_SUBSTR (csv.csvdata,'[^,]+', 1, LEVEL) IS NOT NULL;
Posted By: Alam
Doyen System Pvt. Ltd.
Friday 22 February 2019
How to Convert Comma Separated Values into Table using 'REGEXP_SUBSTR'
WITH csv
AS (SELECT 'AA,BB,CC,D33D,EE,FFDD,MM,GG' AS csvdata FROM DUAL)
SELECT REGEXP_SUBSTR (csv.csvdata, '[^,]+', 1, LEVEL) pivot_char
FROM DUAL, csv
CONNECT BY REGEXP_SUBSTR (csv.csvdata,'[^,]+', 1, LEVEL) IS NOT NULL;
Posted By: Alam
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment