尤日志方案

CREATE TABLE wildkid_111(
Ochr VARCHAR2(4000),
NewCHR VARCHAR2(4000),
a VARCHAR2(4000),
b VARCHAR2(4000),
c  VARCHAR2(4000),
t1 DATE,
t2 DATE,
t3 DATE
);




CREATE TABLE wildkid_112 AS
SELECT * FROM wildkid_111 WHERE ochr LIKE ‘%8.统计数据%‘;

CREATE TABLE wildkid_113 AS
SELECT * FROM wildkid_111 WHERE ochr LIKE ‘%2.中保信请求v7核心原始报文%‘;

SELECT INSTR(ochr,‘random‘),instr(ochr,‘]‘,INSTR(ochr,‘random‘)),SUBSTR(ochr,INSTR(ochr,‘random‘)+7,instr(ochr,‘]‘,INSTR(ochr,‘random‘))-INSTR(ochr,‘random‘)-7) FROM wildkid_113 WHERE ROWNUM<100;

UPDATE wildkid_113 SET a=SUBSTR(ochr,INSTR(ochr,‘random‘)+7,instr(ochr,‘]‘,INSTR(ochr,‘random‘))-INSTR(ochr,‘random‘)-7) ;

SELECT to_date(SUBSTR(ochr,0,19),‘yyyy-mm-dd hh24:mi:ss‘) FROM wildkid_113;
UPDATE wildkid_113 SET t1=to_date(SUBSTR(ochr,0,19),‘yyyy-mm-dd hh24:mi:ss‘);

SELECT * FROM wildkid_112;
SELECT * FROM

UPDATE wildkid_112 SET a=SUBSTR(ochr,INSTR(ochr,‘random‘)+7,instr(ochr,‘]‘,INSTR(ochr,‘random‘))-INSTR(ochr,‘random‘)-7) ;

UPDATE wildkid_112 SET t1=to_date(SUBSTR(ochr,0,19),‘yyyy-mm-dd hh24:mi:ss‘);

SELECT * FROM wildkid_112;
SELECT * FROM wildkid_113;

尤日志方案