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

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