[Oracle SQL] Split Comma Delimited String

Oracle 11G ile yapılabilecek bir splitting işlemi:

WITH docs_string AS

(SELECT 'mehmet,ahmet,hasan,huseyin,mahmut' AS str

  FROM   dual)

SELECT LEVEL lvl

      ,regexp_substr(str,

                     '[^,]+',

                     1,

                     LEVEL) splitted_string

FROM   docs_string t

CONNECT BY LEVEL <= regexp_count(str,

                                 ',') + 1;

------------------------------------

LVL SPLITTED_STRING
1 mehmet
2 ahmet
3 hasan
4 huseyin
5 mahmut