字符串中以字符分隔数据的处理

select 'insert into xxx (xxx1) values('''|| regexp_substr('C:       72771379200   107376275456','[^ ]+',1,level) ||''');' xxx from dual connect by level<=3;




select regexp_substr('C:       72771379200   107376275456','[^ ]+',1,level) from dual connect by level<=3;


SELECT ID
  FROM (SELECT REGEXP_SUBSTR('1,2,3', '[^,]+', 1, LEVEL) ID
          FROM DUAL
        CONNECT BY LEVEL <= 1000000)
 WHERE ID IS NOT NULL;






SELECT REGEXP_SUBSTR('1,2,3', '[^,]+', 1, LEVEL) ID
          FROM DUAL

        CONNECT BY LEVEL <= LENGTH('1,2,3')-LENGTH(REPLACE('1,2,3',',',''))+1;