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
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 语句试试怎么插入