4条回答
- ~沉O淀~ 2019-02-22 15:27关注
with
test(col) as
(select '206444-224821-6398873-17662358-2383908-1-6398973' from dual union all
select '136444-224521-6393473-17662358-2356908-2-6394573' from dual union all
select '266444-224898-6124573-13462358-2983908-3-6098973' from dual)
select distinct col,substr(col,instr(col,'-',1,4)+1,instr(col,'-',1,5)-instr(col,'-',1,4)-1) from test;206444-224821-6398873-17662358-2383908-1-6398973 2383908 136444-224521-6393473-17662358-2356908-2-6394573 2356908 266444-224898-6124573-13462358-2983908-3-6098973 2983908
解决 无用评论 打赏 举报