yuyeqianhen的博客

第一种 SELECT REGEXP_SUBSTR ('1,2,3', '[^,]+', 1, rownum) FROM dual CONNECT BY rownum <= LENGTH ('1,2,3') - LENGTH (regexp_replace('1,2,3', ',', ''))+ 1; 第二种 SELECT DISTINCT REGEXP_SUBSTR ('1,2,3','[^,]+',1,LEVEL) as "token" FROM DUAL CONNECT B.