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

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