<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>

<Code sql> select * from emp where ename in ( select regexp_substr('pingpong,arrow,function', '[^,]+', 1, level)

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

); </Code>