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

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