oracle字符串分割

方式2

select regexp_substr('20180023,FDY018','[^,]+', 1, level) from dual
connect by regexp_substr('20180023,FDY018', '[^,]+', 1, level) is not null