PL/SQL 多条insert语句一起执行

谁践踏了优雅 2022-05-23 06:48 388阅读 0赞

一次性执行多条insert语句

INSERT INTO wtr\_workrecord  
   (id,wbs\_id,gic\_id,activity\_id,city\_id,work\_date,norduration,description,sitename,neid,netypeid,user\_id,checkuser\_id,approveuser\_id,status, period,ot1duration,ot2duration,ot3duration,time\_type,tp,tp\_price, spc,ot1\_price,ot2\_price,ot3\_price,validatedays,rejectreason,comtype,submittime,checktime,approvetime,istrainee,tptype,sbtconfirmstate,sbtuserid,sbtconfirmtime,sbpconfirmstate,sbpuserid,sbpconfirmtime,wastate,travel,deptid,teamid, worktypeid,worktypename,modifyby,modifydate, workinfuno,workinprice,fare)  
VALUES  
   (2565389, 1001496, 10, 648, 1, '2018/6/1', 480, '', '', 0, 34, 1005376, NULL, NULL, 2, 201806, 0, 0, 0, 1, 0.0000, 50.00, 760.00, 0.00, 50.00, 50.00, 1, '', 0, '2018/6/4 09:55:10', NULL, NULL, 0, 1, 0, NULL, NULL, 0, NULL, NULL, 2, NULL, 0, 5, 7, 'NOS-网规网优工程师', 1005376, '2018/6/4 09:55:19', 0.00, 0.00, 0.00);  
  
  
INSERT INTO wtr\_workrecord  
   (id,wbs\_id,gic\_id,activity\_id,city\_id,work\_date,norduration,description,sitename,neid,netypeid,user\_id,checkuser\_id,approveuser\_id,status, period,ot1duration,ot2duration,ot3duration,time\_type,tp,tp\_price, spc,ot1\_price,ot2\_price,ot3\_price,validatedays,rejectreason,comtype,submittime,checktime,approvetime,istrainee,tptype,sbtconfirmstate,sbtuserid,sbtconfirmtime,sbpconfirmstate,sbpuserid,sbpconfirmtime,wastate,travel,deptid,teamid, worktypeid,worktypename,modifyby,modifydate, workinfuno,workinprice,fare)  
VALUES  
   (2565390, 1001442, 18, 657, 1, '2018/5/28', 480, '项目跟踪，能力梳理等', '', 0, 34, 1000232, NULL, NULL, 1, 201806, 0, 0, 0, 1, 0.0000, 0.00, 0.00, 0.00, 0.00, 0.00, 1, NULL, 1, '2018/6/4 09:55:24', NULL, NULL, 0, 0, 0, NULL, NULL, 0, NULL, NULL, 2, NULL, 33, 30, 18, 'IS-软件开发工程师', 1000232, '2018/6/4 09:55:24', 0.00, 0.00, 0.00);  
  
  
INSERT INTO wtr\_workrecord  
   (id,wbs\_id,gic\_id,activity\_id,city\_id,work\_date,norduration,description,sitename,neid,netypeid,user\_id,checkuser\_id,approveuser\_id,status, period,ot1duration,ot2duration,ot3duration,time\_type,tp,tp\_price, spc,ot1\_price,ot2\_price,ot3\_price,validatedays,rejectreason,comtype,submittime,checktime,approvetime,istrainee,tptype,sbtconfirmstate,sbtuserid,sbtconfirmtime,sbpconfirmstate,sbpuserid,sbpconfirmtime,wastate,travel,deptid,teamid, worktypeid,worktypename,modifyby,modifydate, workinfuno,workinprice,fare)  
VALUES  
   (2565391, 1001442, 18, 657, 1, '2018/5/29', 480, '项目跟踪，能力梳理等', '', 0, 34, 1000232, NULL, NULL, 1, 201806, 0, 0, 0, 1, 0.0000, 0.00, 0.00, 0.00, 0.00, 0.00, 1, NULL, 1, '2018/6/4 09:55:24', NULL, NULL, 0, 0, 0, NULL, NULL, 0, NULL, NULL, 2, NULL, 33, 30, 18, 'IS-软件开发工程师', 1000232, '2018/6/4 09:55:24', 0.00, 0.00, 0.00);

这样是不能插入的，会报语法错误

需要将其封装成语句块，即加上begin和end

begin  
INSERT INTO wtr\_workrecord  
   (id,wbs\_id,gic\_id,activity\_id,city\_id,work\_date,norduration,description,sitename,neid,netypeid,user\_id,checkuser\_id,approveuser\_id,status, period,ot1duration,ot2duration,ot3duration,time\_type,tp,tp\_price, spc,ot1\_price,ot2\_price,ot3\_price,validatedays,rejectreason,comtype,submittime,checktime,approvetime,istrainee,tptype,sbtconfirmstate,sbtuserid,sbtconfirmtime,sbpconfirmstate,sbpuserid,sbpconfirmtime,wastate,travel,deptid,teamid, worktypeid,worktypename,modifyby,modifydate, workinfuno,workinprice,fare)  
VALUES  
   (2565389, 1001496, 10, 648, 1, '2018/6/1', 480, '', '', 0, 34, 1005376, NULL, NULL, 2, 201806, 0, 0, 0, 1, 0.0000, 50.00, 760.00, 0.00, 50.00, 50.00, 1, '', 0, '2018/6/4 09:55:10', NULL, NULL, 0, 1, 0, NULL, NULL, 0, NULL, NULL, 2, NULL, 0, 5, 7, 'NOS-网规网优工程师', 1005376, '2018/6/4 09:55:19', 0.00, 0.00, 0.00);  
  
  
INSERT INTO wtr\_workrecord  
   (id,wbs\_id,gic\_id,activity\_id,city\_id,work\_date,norduration,description,sitename,neid,netypeid,user\_id,checkuser\_id,approveuser\_id,status, period,ot1duration,ot2duration,ot3duration,time\_type,tp,tp\_price, spc,ot1\_price,ot2\_price,ot3\_price,validatedays,rejectreason,comtype,submittime,checktime,approvetime,istrainee,tptype,sbtconfirmstate,sbtuserid,sbtconfirmtime,sbpconfirmstate,sbpuserid,sbpconfirmtime,wastate,travel,deptid,teamid, worktypeid,worktypename,modifyby,modifydate, workinfuno,workinprice,fare)  
VALUES  
   (2565390, 1001442, 18, 657, 1, '2018/5/28', 480, '项目跟踪，能力梳理等', '', 0, 34, 1000232, NULL, NULL, 1, 201806, 0, 0, 0, 1, 0.0000, 0.00, 0.00, 0.00, 0.00, 0.00, 1, NULL, 1, '2018/6/4 09:55:24', NULL, NULL, 0, 0, 0, NULL, NULL, 0, NULL, NULL, 2, NULL, 33, 30, 18, 'IS-软件开发工程师', 1000232, '2018/6/4 09:55:24', 0.00, 0.00, 0.00);  
  
  
INSERT INTO wtr\_workrecord  
   (id,wbs\_id,gic\_id,activity\_id,city\_id,work\_date,norduration,description,sitename,neid,netypeid,user\_id,checkuser\_id,approveuser\_id,status, period,ot1duration,ot2duration,ot3duration,time\_type,tp,tp\_price, spc,ot1\_price,ot2\_price,ot3\_price,validatedays,rejectreason,comtype,submittime,checktime,approvetime,istrainee,tptype,sbtconfirmstate,sbtuserid,sbtconfirmtime,sbpconfirmstate,sbpuserid,sbpconfirmtime,wastate,travel,deptid,teamid, worktypeid,worktypename,modifyby,modifydate, workinfuno,workinprice,fare)  
VALUES  
   (2565391, 1001442, 18, 657, 1, '2018/5/29', 480, '项目跟踪，能力梳理等', '', 0, 34, 1000232, NULL, NULL, 1, 201806, 0, 0, 0, 1, 0.0000, 0.00, 0.00, 0.00, 0.00, 0.00, 1, NULL, 1, '2018/6/4 09:55:24', NULL, NULL, 0, 0, 0, NULL, NULL, 0, NULL, NULL, 2, NULL, 33, 30, 18, 'IS-软件开发工程师', 1000232, '2018/6/4 09:55:24', 0.00, 0.00, 0.00);  
   end;