PLSQL同时执行多条语句实例(四)

2014-11-24 11:32:44 · 作者: · 浏览: 250
646-efb4-4966-b8a8-47caead02204',2,27,1);
commit;
delete TBSYSLOGINCONPOSITION;
insert into TBSYSLOGINCONPOSITION (SUBSYSID, TOPUSERSIZE, LEFTUSERSIZE, HEIGHTUSERSIZE, WIDTHUSERSIZE, TOPPWDSIZE, LEFTPWDSIZE, HEIGHTPWDSIZE, WIDTHPWDSIZE, TOPLOGINSIZE, LEFTLOGINSIZE, HEIGHTLOGINSIZE, WIDTHLOGINSIZE, TOPEXITSIZE, LEFTEXITSIZE, HEIGHTEXITSIZE, WIDTHEXITSIZE)
values (6000, 321, 105, 22, 126, 321, 275, 22, 128, 319, 411, 26, 55, 319, 479, 26, 55);
insert into TBSYSLOGINCONPOSITION (SUBSYSID, TOPUSERSIZE, LEFTUSERSIZE, HEIGHTUSERSIZE, WIDTHUSERSIZE, TOPPWDSIZE, LEFTPWDSIZE, HEIGHTPWDSIZE, WIDTHPWDSIZE, TOPLOGINSIZE, LEFTLOGINSIZE, HEIGHTLOGINSIZE, WIDTHLOGINSIZE, TOPEXITSIZE, LEFTEXITSIZE, HEIGHTEXITSIZE, WIDTHEXITSIZE)
values (2000, 263, 87, 20, 105, 263, 229, 20, 107, 261, 343, 21, 42, 261, 403, 22, 42);
insert into TBSYSLOGINCONPOSITION (SUBSYSID, TOPUSERSIZE, LEFTUSERSIZE, HEIGHTUSERSIZE, WIDTHUSERSIZE, TOPPWDSIZE, LEFTPWDSIZE, HEIGHTPWDSIZE, WIDTHPWDSIZE, TOPLOGINSIZE, LEFTLOGINSIZE, HEIGHTLOGINSIZE, WIDTHLOGINSIZE, TOPEXITSIZE, LEFTEXITSIZE, HEIGHTEXITSIZE, WIDTHEXITSIZE)
values (6021, 263, 87, 21, 105, 263, 229, 19, 108, 262, 343, 20, 35, 262, 383, 20, 34);
insert into TBSYSLOGINCONPOSITION (SUBSYSID, TOPUSERSIZE, LEFTUSERSIZE, HEIGHTUSERSIZE, WIDTHUSERSIZE, TOPPWDSIZE, LEFTPWDSIZE, HEIGHTPWDSIZE, WIDTHPWDSIZE, TOPLOGINSIZE, LEFTLOGINSIZE, HEIGHTLOGINSIZE, WIDTHLOGINSIZE, TOPEXITSIZE, LEFTEXITSIZE, HEIGHTEXITSIZE, WIDTHEXITSIZE)
values (6017, 263, 87, 20, 105, 263, 229, 20, 107, 261, 343, 21, 42, 261, 403, 22, 42);
insert into TBSYSLOGINCONPOSITION (SUBSYSID, TOPUSERSIZE, LEFTUSERSIZE, HEIGHTUSERSIZE, WIDTHUSERSIZE, TOPPWDSIZE, LEFTPWDSIZE, HEIGHTPWDSIZE, WIDTHPWDSIZE, TOPLOGINSIZE, LEFTLOGINSIZE, HEIGHTLOGINSIZE, WIDTHLOGINSIZE, TOPEXITSIZE, LEFTEXITSIZE, HEIGHTEXITSIZE, WIDTHEXITSIZE)
values (6023, 321, 105, 22, 126, 321, 275, 22, 128, 319, 411, 26, 55, 319, 479, 26, 55);
commit;