SELECT t.log,
replace(SUBSTR(t.log, 1, INSTR(t.log, '|',1,2) - 1),'| 访问ID:','') as 访问ID,
replace(replace(SUBSTR(t.log, 1, INSTR(t.log, '|',3,2) - 1),SUBSTR(t.log, 1, INSTR(t.log, '|',1,2) - 1),''),'| 访问地址:','') as 访问地址,
replace(replace(SUBSTR(t.log, 1, INSTR(t.log, '|',3,3) - 1),SUBSTR(t.log, 1, INSTR(t.log, '|',1,3) - 1),''),'| 请求方式:','') as 请求方式,
replace(SUBSTR(t.log, 1, INSTR(t.log, '|',3,4) - 1),SUBSTR(t.log, 1, INSTR(t.log, '|',1,3) - 1),'') as 参数
FROM zfb_csfu_log_2015081901 t
Oracle内处理字符串
最新推荐文章于 2024-01-31 09:05:26 发布