====== Comma ======

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