Oracle 分割字符串

Oracle 分割字符串

select ltrim(rtrim('1a1,22s')) from dual;
select concat('1s1,s11', ',') from dual;
select substr('1s13,s11,232,1ds', 1, instr('1s13,s11,232,1ds', ',') - length(',')) from dual;
select subStr('1s13,s11,232,1ds', instr('1s13,s11,232,1ds', ',', 1, 2) + length(','), instr('1s13,s11,232,1ds', ',', 1, 3) - instr('1s13,s11,232,1ds', ',', 1, 2)) from dual;

select  instr('1s13,s11,232,1ds', ',', 1, 2)  from dual;

select instr('1s13,s11,232,1ds', ',', 1, 3) - 1 from dual;

select subStr('1s13,s11,232,1ds', instr('1s13,s11,232,1ds', ',', 1, 1) + length(','), (instr('1s13,s11,232,1ds', ',', 1, 2) - instr('1s13,s11,232,1ds', ',', 1, 1) - length(','))) from dual;