将这种数据 select * from T_B_INFO_TEST
转化成这种数据:select * from T_b_INFO_RESULT
转化数据的脚本:
insert into T_b_INFO_RESULT
select q.c_month,
regexp_substr(q.prod_code, '[^,]+', 1, q.rn) prod_code,
q.c_soto,
q.kpi_value
from (select t.c_month, t.prod_code, t.c_soto, t.kpi_value, t1.rn
from (select a.c_month,
a.prod_code,
a.c_soto,
a.kpi_value,
length(a.prod_code) -
length(replace(a.prod_code, ',')) + 1 rn
from t_B_info_test a) t,
(select level rn
from dual
connect by level <=
(select max(length(b.prod_code) -