By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE tab(Name, Project, Error) AS
SELECT 108,'test' ,'Err1, Err2, Err3' FROM dual UNION
SELECT 109,'test2','Err1' FROM dual;
2 rows affected
SELECT *
FROM tab t
OUTER APPLY (SELECT TRIM(p) AS p
FROM JSON_TABLE(REPLACE(JSON_ARRAY(t.Error), ',', '","'),
'$[*]' COLUMNS (p VARCHAR2(4000) PATH '$'))) s;
| NAME | PROJECT | ERROR | P |
|---|---|---|---|
| 108 | test | Err1, Err2, Err3 | Err1 |
| 108 | test | Err1, Err2, Err3 | Err2 |
| 108 | test | Err1, Err2, Err3 | Err3 |
| 109 | test2 | Err1 | Err1 |