Oracle Expert

Just reminder for myself
WITH t AS (
SELECT ‘AAA,a,b,c,d,e,f,g,h,i,j,k,l’ or_str from dual
)
SELECT SUBSTR(
or_str,
INSTR(’,’ || or_str,’,',1,LEVEL),
INSTR(or_str || ‘,’,',’,1,LEVEL) - INSTR(’,’ || or_str,’,',1,LEVEL)
) SubString
FROM t
CONNECT BY LEVEL <= LENGTH(or_str)-LENGTH(REPLACE(or_str,’,')) + 1
AND PRIOR or_str = or_str
AND PRIOR DBMS_RANDOM.VALUE IS NOT NULL
/