By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
3 rows affected
SOME_ID | VALUE |
---|---|
8 | A1,A2,A3 |
8 | B1,B2,B3 |
8 | C1,C2,C3 |
8 | A4,A5,A6 |
8 | B4,B5,B6 |
8 | C4,C5,C6 |
REGEXP_SUBSTR(VALUE,'[^;]+',1,LEVEL) | SYS_CONNECT_BY_PATH(REGEXP_SUBSTR(VALUE,'[^;]+',1,LEVEL),';') |
---|---|
A1,A2,A3 | ;A1,A2,A3 |
A4,A5,A6 | ;A1,A2,A3;A4,A5,A6 |
B4,B5,B6 | ;A1,A2,A3;B4,B5,B6 |
C4,C5,C6 | ;A1,A2,A3;C4,C5,C6 |
B1,B2,B3 | ;B1,B2,B3 |
A4,A5,A6 | ;B1,B2,B3;A4,A5,A6 |
B4,B5,B6 | ;B1,B2,B3;B4,B5,B6 |
C4,C5,C6 | ;B1,B2,B3;C4,C5,C6 |
C1,C2,C3 | ;C1,C2,C3 |
A4,A5,A6 | ;C1,C2,C3;A4,A5,A6 |
B4,B5,B6 | ;C1,C2,C3;B4,B5,B6 |
C4,C5,C6 | ;C1,C2,C3;C4,C5,C6 |