oracle使用substr instr实现类似于java substring的功能

来源:互联网 发布:php soap添加header 编辑:程序博客网 时间:2024/03/29 13:37
select cast(substr(a.str1,                   instr(a.str1, ';', 1, '27') + 1,                   (instr(a.str1, ';', 1, '28') -                   instr(a.str1, ';', 1, '27') - 1)) as varchar2(10)) as value1  from table1 a where (length(a.str1) - length(replace(a.str1, ';', ''))) = 29   and cast(substr(a.str1,                   instr(a.str1, ';', 1, '27') + 1,                   (instr(a.str1, ';', 1, '28') -                   instr(a.str1, ';', 1, '27') - 1)) as varchar2(10)) is not null;

0 0
原创粉丝点击