oracle split string

Solutions on MaxInterview for oracle split string by the best coders in the world

showing results for - "oracle split string"
Judd
14 May 2020
1-- Splits a comma separated string into rows
2SELECT regexp_substr('SARAH,JOE,PIMPO,LOUIS', '[^,]+', 1, LEVEL)
3FROM DUAL
4CONNECT BY regexp_substr('SARAH,JOE,PIMPO,LOUIS', '[^,]+', 1, LEVEL) IS NOT NULL;