oracle split string
snippet in sql

oracle split string

user1880

-- Splits a comma separated string into rows
SELECT regexp_substr('SARAH,JOE,PIMPO,LOUIS', '[^,]+', 1, LEVEL)
FROM DUAL
CONNECT BY regexp_substr('SARAH,JOE,PIMPO,LOUIS', '[^,]+', 1, LEVEL) IS NOT NULL;