有用户提供要插入的药监码，确定 要插入的值后，拼写SQL，再批量替换

用户提供的药监码 需要是 按回车分割类似
87802480000732209182
87802480000732209183
87802480000732209184

替换字符 步骤

使用notepad++ 的替换 ，勾选 正则表达式

查找字符

(\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d\d)

替换成 ，注意这里需要一个有结果的字符，如果直接用条件查询，会照成死锁

insert into stockin (FGSBM, KHDM, SLDDH, RKRQ, RKTZDH, SHDH, SKU, PH, BARCODE, SL, XXM, CZR, CZRQ, CZM, ISEXPORT, DRBZ, DRR, FLAG, RKLX, PACKAGE, PICKTYPE, XYKH_NAME, SJSL, RELATIONID, GLFGSBM, PROCFLAG, UPDATETIME) SELECT ‘61’, ‘418184’, ‘6012436200’, ‘2024-01-15’, ‘AN802024011501179’, ‘AN802024011501179-01’, ‘1100008601’, ‘6222780’, ‘83617850291549342814’, 150, ‘10’, ‘420255’, ‘2024-01-15 15:29:15’, ‘0102’, null, null, null, null, ‘0’, ‘ ‘, ‘0’, null, 150, null, null, null, null from dual ;

其中 \1 代表替换的字符