SQL> WITH split_val AS (SELECT 'A,B,C,D,E' AS VAL FROM DUAL)
2 SELECT REGEXP_SUBSTR (VAL,
3 '[^,]+',
4 1,
5 ROWNUM)
6 AS result
7 FROM split_val
8 CONNECT BY LEVEL <= LENGTH (REGEXP_REPLACE (VAL, '[^,]+')) + 1;
RESULT
------------------------------------
A
B
C
D
E
SQL>
2 SELECT REGEXP_SUBSTR (VAL,
3 '[^,]+',
4 1,
5 ROWNUM)
6 AS result
7 FROM split_val
8 CONNECT BY LEVEL <= LENGTH (REGEXP_REPLACE (VAL, '[^,]+')) + 1;
RESULT
------------------------------------
A
B
C
D
E
SQL>
No comments:
Post a Comment