例如 有如下SQL
INSERT INTO Table1 (A, B, C) VALUES (to_timestamp('20121224','YYYY-MM-DD HH24:MI:SS'),‘’,to_timestamp('20121224','YYYY-MM-DD HH24:MI:SS')
INSERT INTO Table1 (A, B, C) VALUES (to_timestamp('20121224','YYYY-MM-DD HH24:MI:SS'),‘’,''')
INSERT INTO Table1 (A, B, C) VALUES (to_timestamp('20121224','YYYY-MM-DD HH24:MI:SS'),‘’,''')
想替换所有经过to_timestamp变化后的为空值
INSERT INTO Table1 (A, B, C) VALUES ('',‘’,'')
INSERT INTO Table1 (A, B, C) VALUES ('',‘’,'')
INSERT INTO Table1 (A, B, C) VALUES ('',‘’,'')
用正则to_timestamp\(*SS'\),即可