oracle split string

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

we are a community of more than 2 million smartest coders
registration for
employee referral programs
are now open
get referred to google, amazon, flipkart and more
register now
  
pinned-register now
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;