方式一： select regexp_substr('1,2,ds','[^,]+', 1, level, 'i') as arr from dual connect by level <= length('1,2,ds')-length(regexp_replace('1,2,ds', ',', ''))+1 方式二： sel 继续阅读

 select str::VARCHAR from (select regexp_split_to_table(',1,2,3,,', ',') str) a where str!='' --字符串转数组 继续阅读