with b as(
select '01.02,01.03,01.04,01.05' as m from dual
)
select nvl(regexp_substr(m,'\d+.\d+',1,level) ,'NULL')as s from b connect by level<7
之后就得到了
SQL> with b as(
2 select '01.02,01.03,01.04,01.05' as m from dual
3 )
4 select nvl(regexp_substr(m,'\d+.\d+',1,level) ,'NULL')as s from b connect by level<7
5 ;
S
----------------------------------------------
01.02
01.03
01.04
01.05
NULL
NULL
6 rows selected
去空。然后使用select ino 语句试试怎么插入