By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS';
CREATE TABLE table_name(list VARCHAR2(100));
INSERT INTO table_name (list) VALUES ( '"a","b","c","d"' );
1 rows affected
INSERT INTO table_name (list) VALUES ( '"noquotes","\"quotes\"","comma,here"' );
1 rows affected
SELECT j.value
FROM table_name t
CROSS APPLY JSON_TABLE(
'[' || t.list || ']',
'$[*]'
COLUMNS
value VARCHAR2(10) PATH '$'
) j
| VALUE |
|---|
| a |
| b |
| c |
| d |
| noquotes |
| "quotes" |
| comma,here |