<Code:sql> select regexp_substr('pingpong,arrow,function', '[^,]+', 1, level)

from dual
connect by regexp_substr('pingpong,arrow,function', '[^,]+', 1, level) is not null;

</Code>