截取字符串中的特定的imsi值
vcpara:{"666666":"11111","101201":"460099988844123","101203":"11111111","108102":"i2222221.11111111.org"}
获取460099988844123
select a.VCPARA,SUBSTR(a.VCPARA FROM INSTR(a.VCPARA,'101201')+9 FOR 15) from dual;
截取字符串中的特定的imsi值
vcpara:{"666666":"11111","101201":"460099988844123","101203":"11111111","108102":"i2222221.11111111.org"}
获取460099988844123
select a.VCPARA,SUBSTR(a.VCPARA FROM INSTR(a.VCPARA,'101201')+9 FOR 15) from dual;