个人写得正则表达式一例

要匹配的文本：

insert into b_kkqp_jgcl (JLBH, HPHM, HPZL, JGSJ, CLSD, ZGXS, ZDXS, CWKC, HPYS, CLLX, JLLX, HDSJ, BZWZDM, SBBH, CDBH, FXBH, TPSL, CLBJ, SHBJ, ZFBJ, SJLY, CCLX, BZ, TJBJ, CSYS, JLLB, XSFX, CSBJ, YZYS, TPLX, XRSJ, URL)
values ('610300001045022016081000035347', '陕CT8283', 0, to_date('10-08-2016 00:03:53', 'dd-mm-yyyy hh24:mi:ss'), 22, 80, 80, 3.00, '0', '2', '0', 610300, '610300001045', '610300001045', 2, 'EW', 1, null, '0', '0', '127.0.0.1', 1, null, null, 0, 0, 1, 1, 1, 999, to_date('10-08-2016 00:44:40', 'dd-mm-yyyy hh24:mi:ss'), '/201605/25/08/12345678901-20160525083919-13-1.jpg;');


insert into b_kkqp_jgcl (JLBH, HPHM, HPZL, JGSJ, CLSD, ZGXS, ZDXS, CWKC, HPYS, CLLX, JLLX, HDSJ, BZWZDM, SBBH, CDBH, FXBH, TPSL, CLBJ, SHBJ, ZFBJ, SJLY, CCLX, BZ, TJBJ, CSYS, JLLB, XSFX, CSBJ, YZYS, TPLX, XRSJ, URL)
values ('610300001045032016081000035469', '陕CT8136', 0, to_date('10-08-2016 00:03:54', 'dd-mm-yyyy hh24:mi:ss'), 27, 80, 80, 3.00, '0', '2', '0', 610300, '610300001045', '610300001045', 3, 'NS', 1, null, '0', '0', '127.0.0.1', 1, null, null, 0, 0, 1, 1, 1, 999, to_date('10-08-2016 00:47:09', 'dd-mm-yyyy hh24:mi:ss'), '/201605/25/08/12345678901-20160525083919-13-1.jpg;');


insert into b_kkqp_jgcl (JLBH, HPHM, HPZL, JGSJ, CLSD, ZGXS, ZDXS, CWKC, HPYS, CLLX, JLLX, HDSJ, BZWZDM, SBBH, CDBH, FXBH, TPSL, CLBJ, SHBJ, ZFBJ, SJLY, CCLX, BZ, TJBJ, CSYS, JLLB, XSFX, CSBJ, YZYS, TPLX, XRSJ, URL)
values ('610300001045022016081000035325', '陕CT8283', 0, to_date('10-08-2016 00:03:53', 'dd-mm-yyyy hh24:mi:ss'), 22, 80, 80, 3.00, '0', '2', '0', 610300, '610300001045', '610300001045', 2, 'EW', 1, null, '0', '0', '127.0.0.1', 1, null, null, 0, 0, 1, 1, 1, 999, to_date('10-08-2016 00:47:09', 'dd-mm-yyyy hh24:mi:ss'), '/201605/25/08/12345678901-20160525083919-13-1.jpg;');

正则表达式：

insert into b_kkqp_jgcl .+\n.+\);\n

分析：

\n : 匹配换行符

）：括弧在正则表达式为关键字， ‘）’要写成\)