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

2014-11-24 11:32:44 · 作者: · 浏览: 237
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;