oracle字符串提取记录

--用作批量核查时限制次数 select t2."PHONE_NUMBER",t2."TIME",t2."URL", substr(t2.post_params, instr(t2.post_params, ‘reportTime:‘)+length(‘reportTime:‘), instr(t2.post_params, ‘,companyName‘)-instr(t2.post_params, ‘reportTime:‘)-length(‘reportTime:‘)) as reportTime, substr(t2.post_params, instr(t2.post_params, ‘companyName:‘)+length(‘companyName:‘), instr(t2.post_params, ‘,xyCode‘)-instr(t2.post_params, ‘companyName:‘)-length(‘companyName:‘)) as companyName, substr(t2.post_params, instr(t2.post_params, ‘xyCode:‘)+length(‘xyCode:‘), instr(t2.post_params, ‘,zb‘)-instr(t2.post_params, ‘xyCode:‘)-length(‘xyCode:‘)) as xyCode, substr(t2.post_params, instr(t2.post_params, ‘,zb:‘)+length(‘,zb:‘), instr(t2.post_params, ‘,value‘)-instr(t2.post_params, ‘,zb:‘)-length(‘,zb:‘)) as zb, substr(t2.post_params, instr(t2.post_params, ‘,type:‘)+length(‘,type:‘), length(t2.post_params)-instr(t2.post_params, ‘,type:‘)-length(‘,type:‘)) as type from user_log t2 where t2.url like ‘%/check/single‘;

 

查询结果

 

oracle字符串提取记录

标签：info   操作   time   str   instr   replace   ams   where   返回