对字符串 ‘12012012666,12012012668,12012012995’ 按逗号分割
SELECT REGEXP_SUBSTR ('12012012666,12012012668,12012012995', '[^,]+', 1,rownum) as CARDID
from dual connect by rownum<=LENGTH ('12012012666,12012012668,12012012995') - LENGTH (regexp_replace('12012012666,12012012668,12012012995', ',', ''))+1
结果为