notepad++正则表达式

插入sql 的Id替换

VALUES \('\w*'
VALUES \( sys_guid\(\)

插入sql 的日期替换

TO_DATE\('(\d{4})-(\d{2})-(\d{2}) (\d{2}):(\d{2}):(\d{2})', 'YYYY-MM-DD HH24:MI:SS'\)

TO_DATE\('(\d{2})-(\d{2})-(\d{4}) (\d{2}):(\d{2}):(\d{2})', 'DD-MM-YYYY HH24:MI:SS'\)

SYSDATE

每一千条添加commit;

((update pcisnew.web_app_tgt w set w.c_tgt_txt_fld_30 = '\["4"\]',w.t_upd_tm =sysdate where w.c_app_no ='\d*';\r\n){1000})

\1commit;\n