展开全部
||
测试32313133353236313431303231363533e78988e69d8331333332643835数据create table test
(id int,
phone varchar2(200));
insert into test values (1,'13811111111,13311111111,13900000000');
insert into test values (2,'15811111111,15911111111,18800000000');
运行select id,c from
(with t as (select id,phone c from test)
select id,substr(t.ca,instr(t.ca, ',', 1, c.lv) + 1,instr(t.ca, ',', 1, c.lv + 1) - (instr(t.ca, ',', 1, c.lv) + 1)) AS c
from (select id,',' || c || ',' AS ca,length(c || ',') - nvl(length(REPLACE(c, ',')),0) AS cnt FROM t) t,
(select LEVEL lv from dual CONNECT BY LEVEL <= 100) c where c.lv <= t.cnt)
order by id
结果