sql 按符号切割长字符串为多行

select regexp_substr(t.mywords , '[^,]+', 1, rownum,'i'), myid
from (select myid,mywords from tablename where myid='12345') t
connect by rownum <= LENGTH(t.mywords ) - LENGTH(REGEXP_REPLACE(t.mywords , ',', '')) + 1;