PLSQL executes multiple statement instances at the same time

PLSQL simultaneously executes multiple statement instances/* Create table * // * Create table TBSLSWDICTTHEMETYPE */-- Create tablecreate table TBSLSWDICTTHEMETYPE (themetypeguid VARCHAR2 (50) not null, themetypename VARCHAR2 (200) not null, themetypecode VARCHAR2 (100) not null, parentguid VARCHAR2 (50), themelevel NUMBER (4) not null, showorderid NUMBER (4) not null, isused NUMBER (4) not null, remark NVARCHAR2 (2000) tablespace SZSLSYS pctfree 10 initrans 1 maxtrans 255 storage (initial 64 next 8 minextents 1 maxextents unlimited) nologging; -- Add comments to the columns comment on column TBSLSWDICTTHEMETYPE. themetypeguid is 'guid '; comment on column TBSLSWDICTTHEMETYPE. themetypename is 'topic type name, which cannot be repeated, for example, river and lake basic information'; comment on column TBSLSWDICTTHEMETYPE. themetypecode is 'user program code, numbering rule: SL + "first letter of the topic name pinyin" For example: SLHH, indicating "river lake basic information", the topic Type Code cannot be repeated '; comment on column TBSLSWDICTTHEMETYPE. parentguid is 'parent-level topic GUID. If it is null, it indicates the top-level '; comment on column TBSLSWDICTTHEMETYPE. themelevel is 'current level '; comment on column TBSLSWDICTTHEMETYPE. showorderid is 'sequential number, used to adjust the display sequence of the topic data list '; comment on column TBSLSWDICTTHEMETYPE. isused is 'enabled: 0: Disabled 1: enabled'; -- Create/Recreate primary, unique and foreign key constraints alter table TBSLSWDICTTHEMETYPE add constraint PK_THEMETYPEGUID primary key (THEMETYPEGUID) using index tablespace SZSLSYS pctfree 10 initrans 2 maxtrans 255 storage (initial 64 K next 1 M minextents 1 maxextents unlimited); alter table TBSLSWDICTTHEMETYPE add constraint limit unique (THEMETYPECODE) using index tablespace SZSLSYS pctfree 10 initrans 2 maxtrans 255 storage (initial 64 K next 1 M minextents 1 maxextents unlimited); alter table TBSLSWDICTTHEMETYPE add constraint limit unique (THEMETYPENAME) using index tablespace SZSLSYS pctfree 10 initrans 2 maxtrans 255 storage (initial 64 K next 1 M minextents 1 maxextents unlimited); alter table TBSLSWDICTTHEMETYPE add constraint limit foreign key (PARENTGUID) references values (THEMETYPEGUID);/* Create table TBSLSWDATAIMPORTLOG */-- Create tablecreate table values (logguid VARCHAR2 (50) not null, themetypeguid VARCHAR2 (50) not null, processstate NUMBER (4) not null, logcontent NVARCHAR2 (2000) not null, submitdepartment NVARCHAR2 (100), submittime DATE, sourcefilename VARCHAR2 (100) not null, sourcedataformat NUMBER (4) not null, reccount NUMBER (4) not null, datarange VARCHAR2 (100), tempdsname VARCHAR2 (40) not null, tempfcname VARCHAR2 (40) not null, intemplibtime DATE, currdsname VARCHAR2 (40) not null, currfcname VARCHAR2 (40) not null, intemplibmodel NUMBER (2) not null, incurrlibmodel NUMBER (2) not null, incurrlibtime DATE) tablespace SZSLSYS pctfree 10 initrans 1 maxtrans 255 storage (initial 64 next 1 minextents 1 maxextents unlimited) nologging; -- Add comments to the columns comment on column TBSLSWDATAIMPORTLOG. logguid is 'guid '; comment on column TBSLSWDATAIMPORTLOG. themetypeguid is 'id of the Data Type of the water conservancy project to be imported into the database. The field value is from the topic type number field in the water conservancy project data dictionary table '; comment on column TBSLSWDATAIMPORTLOG. processstate is '0: Upload Failed 1: Upload successful 2: Review passed 3: Review failed 4: Check failed 5: Check successful 6: Import temporary database failed 7: temporary database entry successful 8: current database entry failed 9: current database entry successful '; comment on column TBSLSWDATAIMPORTLOG. logcontent is 'processing log description, XML format, including "number, time, event, handler, processing status, result" and other data project'; comment on column TBSLSWDATAIMPORTLOG. submitdepartment is 'name of the data submission unit. for public service platforms, the uploaded unit name can be '; comment on column TBSLSWDATAIMPORTLOG. submittime is 'format: yyyy-mm-dd hh: mm'; comment on column TBSLSWDATAIMPORTLOG. sourcefilename is 'only records the file name without having to carry the path'; comment on column TBSLSWDATAIMPORTLOG. sourcedataformat is '0: Shapefile1: AutoCad2: Personal Geodatabase3: File Geodatabase4: Mdb intermediate library '; comment on column TBSLSWDATAIMPORTLOG. reccount is 'number of source data records'; comment on column TBSLSWDATAIMPORTLOG. datarange is 'data range vertex coordinate, format: (vertex 1X coordinate, vertex 1Y coordinate), (vertex 2X coordinate, vertex 2Y coordinate), (vertex 3X coordinate, vertex 3Y coordinate )'; comment on column TBSLSWDATAIMPORTLOG. tempdsname is 'temporary database SDE DataSet name'; comment on column TBSLSWDATAIMPORTLOG. tempfcname is 'temporary library SDE Featureclass name'; comment on column TBSLSWDATAIMPORTLOG. intemplibtime is 'format: yyyy-mm-dd hh: mm, record the last data processing time'; comment on column TBSLSWDATAIMPORTLOG. currdsname is 'current database SDE DataSet name'; comment on column TBSLSWDATAIMPORTLOG. currfcname is 'current library SDE Featureclass name'; comment on column TBSLSWDATAIMPORTLOG. intemplibmodel is 'warehouse Receiving Method: 0: warehouse receiving method: 1: warehouse receiving method incrementally '; comment on column TBSLSWDATAIMPORTLOG. incurrlibmodel is 'warehouse Receiving Method: 0: warehouse receiving method: 1: warehouse receiving method incrementally '; comment on column TBSLSWDATAIMPORTLOG. incurrlibtime is 'format: yyyy-mm-dd hh: mm, record the last data processing time'; -- Create/Recreate primary, unique and foreign key constraints alter table limit add constraint PK_LOGGUID primary key (LOGGUID) using index tablespace SZSLSYS pctfree 10 limit 2 maxtrans 255 storage (initial 64 K next 1 M minextents 1 maxextents unlimited ); alter table partition add constraint Values foreign key (THEMETYPEGUID) references values (THEMETYPEGUID); -- create a table Partition table partition (exportguid VARCHAR2 (50) not null, themetypeguid NVARCHAR2 (50 ), datarange VARCHAR2 (50) not null, targetformat NUMBER (4) not null, datafileurl NVARCHAR2 (200) not null, applyuserid NVARCHAR2 (50) not null, applyunit NVARCHAR2 (100) not null, applytime DATE, proccessstate NUMBER (4) not null, logcontent NVARCHAR2 (2000) not null, audituserid VARCHAR2 (50), audittime DATE, remark NVARCHAR2 (1000 )) tablespace SZSLSYS pctfree 10 initrans 1 maxtrans 255 storage (initial 64 next 1 minextents 1 maxextents unlimited) nologging; -- Add comments to the columns comment on column TBSLSWDATAEXPORTLOG. exportguid is 'guid '; comment on column TBSLSWDATAEXPORTLOG. themetypeguid is 'Multiple topic types, which can be separated by commas '; comment on column TBSLSWDATAEXPORTLOG. datarange is 'comma-separated data range polygon vertex coordinates. Format: (vertex 1X coordinate, vertex 1Y coordinate), (vertex 2X coordinate, vertex 2Y coordinate), (vertex 3X coordinate, vertex 3Y coordinate) '; comment on column TBSLSWDATAEXPORTLOG.tar getformat is '0: Excel1: Shapefile2: AutoCad3: Personal Geodatabase4: File geodatabas'; comment on column TBSLSWDATAEXPORTLOG. datafileurl is 'name of the file to be downloaded Url path'; comment on column TBSLSWDATAEXPORTLOG. applyuserid is 'reference tbUsers table'; comment on column TBSLSWDATAEXPORTLOG. applyunit is 'requester name'; comment on column TBSLSWDATAEXPORTLOG. applytime is 'format: yyyy-mm-dd hh: mm'; comment on column TBSLSWDATAEXPORTLOG. proccessstate is '0: Application in progress 1: Review not passed 2: Review passed 3: file generation error 4: file generation successful 5: downloaded '; comment on column TBSLSWDATAEXPORTLOG. logcontent is 'processing log description, XML format, including "number, time, event, handler, processing status, result" and other data project'; comment on column TBSLSWDATAEXPORTLOG. audituserid is 'user number that references tbusers'; -- Create/Recreate primary, unique and foreign key constraints alter table TBSLSWDATAEXPORTLOG add constraint PK_EXPORTGUID primary key (EXPORTGUID) using index tablespace SZSLSYS pctfree 10 initrans 2 maxtrans 255; commit; -- initialize table metadata data/* river and lake basic information */insert into partition (ThemetypeGuid, Themetypename, Themetypecode, Parentguid, themelevel, showorderid, Isused) values ('f6d523d0-b8d1-4389-97ee-027a0bfa5f68 ', 'River basic information', 'slhh', null, 1); -- insert subitem insert into partition (ThemetypeGuid, themetypename, Themetypecode, Parentguid, Themelevel, showorderid, Isused) values ('your-b8d1-4389-97ee-027a0bfa5f69 ', 'River basic status', 'slhh _ heliu_poly', 'your-b8d1-4389-97ee-027a0bfa5f68', 2, 1, 1); insert into values (ThemetypeGuid, Themetypename, Themetypecode, Parentguid, Themelevel, showorderid, Isused) values ('f6d523d0-b8d1-4389-97ee-027a0bfa5f70 ', 'Lake Basic Situation ', 'slhh _ HuPo_Poly ', 'wait-b8d1-4389-97ee-027a0bfa5f68', 1); insert into values (ThemetypeGuid, Themetypename, Themetypecode, Parentguid, Themelevel, showorderid, Isused) values ('f6d523d0-b8d1-4389-97ee-027a0bfa5f71 ', 'hydrological station and waterstation information', 'slhh _ SWZ_Pot', 'f6d523d0-b8d1-4389-97ee-027a0bfa5f68 ', 2, 3, 1); insert into values (ThemetypeGuid, themetypename, Themetypecode, Parentguid, Themelevel, showorderid, Isused) values ('your-b8d1-4389-97ee-027a0bfa5f72 ', 'River section status', 'slhh _ hldm_arc', 'your-b8d1-4389-97ee-027a0bfa5f68', 2, 4, 1);/* Water Conservancy Project */insert into values (ThemetypeGuid, Themetypename, Themetypecode, Parentguid, Themelevel, showorderid, Isused) values ('water conservancy Project ', 'slgc ', null, 1); -- insert subitem insert into values (ThemetypeGuid, Themetypename, Themetypecode, Parentguid, Themelevel, showorderid, Isused) values ', 'hydropower Project', 'slgc _ SDZ_Pot ', 'pipeline-b8d1-4389-97ee-027a0bfa5f73', 2, 5, 1); insert into values (values, Themetypename, Themetypecode, Parentguid, Themelevel, showorderid, Isused) values ('f6d523d0-b8d1-4389-97ee-027a0bfa5f75 ', 'sluice Project', 'slgc _ SZha_Pot', 'parallel-b8d1-4389-97ee-027a0bfa5f73 ', 1); insert into values (ThemetypeGuid, Themetypename, Themetypecode, parentguid, Themelevel, showorderid, Isused) values ('f6d523d0-b8d1-4389-97ee-027a0bfa5f76 ', 'pumping station Project', 'slgc _ Bump_Pot', 'f6d523d0-b8d1-4389-97ee-027a0bfa5f73 ', 2, 7, 1 ); insert into values (ThemetypeGuid, Themetypename, Themetypecode, Parentguid, Themelevel, showorderid, Isused) values ('dike-b8d1-4389-97ee-027a0bfa5f77 ', 'dike Project', 'slgc _ DiF_Arc ', 'values-b8d1-4389-97ee-027a0bfa5f73 ', 1); insert into values (ThemetypeGuid, Themetypename, Themetypecode, Parentguid, Themelevel, showorderid, Isused) values ('values-b8d1-4389-97ee-027a0bfa5f78 ', 'dike feature section ', 'slgc _ difdm_arc', 'dike-b8d1-4389-97ee-027a0bfa5f73', 1); insert into partition (ThemetypeGuid, Themetypename, Themetypecode, Parentguid, Themelevel, showorderid, isused) values ('f6d523d0-b8d1-4389-97ee-027a0bfa5f79 ', 'slgc _ WeiQu_Poly', 'f6d523d0-b8d1-4389-97ee-027a0bfa5f73 ', 1); insert into values (ThemetypeGuid, themetypename, Themetypecode, Parentguid, Themelevel, showorderid, Isused) values ('dam-b8d1-4389-97ee-027a0bfa5f80 ', 'dam Project', 'slgc _ tangba_arc', 'dam-b8d1-4389-97ee-027a0bfa5f73, 1);/* social economy Water */insert into values (ThemetypeGuid, Themetypename, Themetypecode, Parentguid, Themelevel, showorderid, Isused) values ('f6d523d0-b8d1-4389-97ee-027a0bfa5f81 ', 'economic and social Water', 'sljj ', null, 1); -- insert subitem insert into partition (ThemetypeGuid, Themetypename, Themetypecode, Parentguid, Themelevel, showorderid, Isused) values ('small-b8d1-4389-97ee-027a0bfa5f82 ', 'large scale livestock and poultry farm Water', 'sljj _ ChuQYZC_Poly', 'f6d523d0-b8d1-4389-97ee-027a0bfa5f81 ', 1); insert into values (ThemetypeGuid, Themetypename, themetypecode, Parentguid, Themelevel, showorderid, Isused) values ('f6d523d0-b8d1-4389-97ee-027a0bfa5f83 ', 'Water Supply Enterprise Water', 'sljj _ GGGSQY_Pot', 'Weather-b8d1-4389-97ee-027a0bfa5f81, 1); insert into values (ThemetypeGuid, Themetypename, Themetypecode, Parentguid, Themelevel, showorderid, Isused) values ('f6d523d0-b8d1-4389-97ee-027a0bfa5f84 ', 'industrial enterprise Water ', 'sljj _ GYeQY_Pot ', 'small-b8d1-4389-97ee-027a0bfa5f81', 1); insert into values (ThemetypeGuid, Themetypename, Themetypecode, Parentguid, Themelevel, showorderid, Isused) values ('f6d523d0-b8d1-4389-97ee-027a0bfa5f85 ', 'Water for construction and tertiary id', 'sljj _ JZYeDiSanCY_Pot', 'f6d523d0-b8d1-4389-97ee-027a0bfa5f81 ', 2,15, 1 ); /* river lake development governance protection */insert into values (ThemetypeGuid, Themetypename, Themetypecode, Parentguid, Themelevel, showorderid, Isused) values ('f6d523d0-b8d1-4389-97ee-027a0bfa5f86 ', 'River Lake Development and Governance protection situation ', 'slkf', null, 1); -- insert subitem into partition (ThemetypeGuid, Themetypename, Themetypecode, Parentguid, Themelevel, showorderid, Isused) values ('f6d523d0-b8d1-4389-97ee-027a0bfa5f87 ', 'River lake water intake (scale or above)', 'slkf _ HHQSKBig_Pot ', 'f6d523d0-b8d1-4389-97ee-027a0bfa5f86', 1); insert into values (ThemetypeGuid, themetypename, Themetypecode, Parentguid, Themelevel, showorderid, Isused) values ('surface water watermark', 'slkf _ DMSSYD_Pot ', 'surface water watermark, 1); insert into values (ThemetypeGuid, Themetypename, Themetypecode, Parentguid, Themelevel, showorderid, Isused) values ('f6d523d0-b8d1-4389-97ee-027a0bfa5f89 ', 'River governance protection ', 'slkf _ HLZLBH_Poly ', 'values-b8d1-4389-97ee-027a0bfa5f86', 1); insert into values (ThemetypeGuid, Themetypename, Themetypecode, Parentguid, Themelevel, showorderid, Isused) values ('f6d523d0-b8d1-4389-97ee-027a0bfa5f90 ', 'Lake governance protection', 'slkf _ HPZLBH_Poly ', 'f6d523d0-b8d1-4389-97ee-027a0bfa5f86', 1); insert into values (ThemetypeGuid, Themetypename, themetypecode, Parentguid, Themelevel, showorderid, Isused) values ('f6d523d0-b8d1-4389-97ee-027a0bfa5f91 ', 'River Lake sewage output', 'slkf _ RuHHPWK_Pot', 'hour-b8d1-4389-97ee-027a0bfa5f86, 1);/* water conservancy industry capacity construction */insert into values (ThemetypeGuid, Themetypename, Themetypecode, Parentguid, Themelevel, showorderid, Isused) values ('your-b8d1-4389-97ee-027a0bfa5f92 ', 'Water conservancy industry capacity construction information', 'slnl ', null, 1); -- insert subitem into partition (ThemetypeGuid, Themetypename, Themetypecode, Parentguid, Themelevel, showorderid, Isused) values ('f6d523d0-b8d1-4389-97ee-027a0bfa5f93 ', 'Water conservancy authorization', 'slnl _ XZJG_Pot', 'f6d523d0-b8d1-4389-97ee-027a0bfa5f92 ', 1); insert into values (ThemetypeGuid, Themetypename, themetypecode, Parentguid, Themelevel, showorderid, Isused) values ('f6d523d0-b8d1-4389-97ee-027a0bfa5f94 ', 'Water conservancy authority', 'slnl _ SYDW_Pot ', 'Water conservancy-b8d1-4389-97ee-027a0bfa5f92', 2, 22, 1); insert into values (ThemetypeGuid, Themetypename, delimiter, Parentguid, Themelevel, showorderid, Isused) values ('watermark-b8d1-4389-97ee-027a0bfa5f95 ', 'watermark', 'slnl _ SLQY_Pot ', 'values-b8d1-4389-97ee-027a0bfa5f92 ', 1); insert into values (ThemetypeGuid, Themetypename, Themetypecode, Parentguid, Themelevel, showorderid, Isused) values ('values-b8d1-4389-97ee-027a0bfa5f96 ', 'Water conservancy Social Group', 'slnl _ SheHTT_Pot ', 'short-b8d1-4389-97ee-027a0bfa5f92', 1); insert into values (ThemetypeGuid, Themetypename, Themetypecode, Parentguid, Themelevel, showorderid, isused) values ('f6d523d0-b8d1-4389-97ee-027a0bfa5f97 ', 'township Water Conservancy Management Unit', 'slnl _ XZhenGLDW_Pot ', 'f6d523d0-b8d1-4389-97ee-027a0bfa5f92', 2, 25, 1 ); /* water conservancy industry capacity construction */insert into irrigation (ThemetypeGuid, Themetypename, Themetypecode, Parentguid, Themelevel, showorderid, Isused) values ('irrigation-b8d1-4389-97ee-027a0bfa5f98 ', 'irrigation special ', 'slgg ', null, 1); -- insert subitem insert into values (ThemetypeGuid, Themetypename, Themetypecode, Parentguid, Themelevel, showorderid, Isused) values ('your-b8d1-4389-97ee-027a0bfa5f99 ', 'irrigation district ', 'slgg _ GQu_Poly', 'f6d523d0-b8d1-4389-97ee-027a0bfa5f98 ', 1);/* water conservancy industry capacity construction */insert into partition (ThemetypeGuid, Themetypename, Themetypecode, parentguid, Themelevel, showorderid, Isused) values ('91b3a646-efb4-4966-b8a8-47caead02204 ', 'Groundwater sampling Water', 'slqs', null, 1 ); -- insert subitem insert into partition (ThemetypeGuid, Themetypename, Themetypecode, Parentguid, Themelevel, showorderid, Isused) values ('91b3a646-efb4-4966-b8a8-47caead02205 ', 'Electrical wells above scale ', 'slqs _ JDJBig_Pot ', 'capacity-efb4-4966-b8a8-47caead02204', 1); commit; delete partition; insert into partition (SUBSYSID, TOPUSERSIZE, LEFTUSERSIZE, HEIGHTUSERSIZE, WIDTHUSERSIZE, TOPPWDSIZE, LEFTPWDSIZE, dimensions, WIDTHPWDSIZE, TOPLOGINSIZE, LEFTLOGINSIZE, HEIGHTLOGINSIZE, WIDTHLOGINSIZE, TOPEXITSIZE, LEFTEXITSIZE, dimensions, WIDTHEXITSIZE) values (6000,321,105, 22,126,321,275, 22,128,319,411, 26, 55,319,479, 26, 55 ); insert into partition (SUBSYSID, TOPUSERSIZE, LEFTUSERSIZE, HEIGHTUSERSIZE, WIDTHUSERSIZE, TOPPWDSIZE, primary, TOPLOGINSIZE, primary, primary, WIDTHLOGINSIZE, TOPEXITSIZE, primary, primary, 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, weight, WIDTHPWDSIZE, TOPLOGINSIZE, LEFTLOGINSIZE, HEIGHTLOGINSIZE, WIDTHLOGINSIZE, TOPEXITSIZE, LEFTEXITSIZE, distance, WIDTHEXITSIZE) values (6021,263, 87, 21,105,263,229, 19,108,262,343, 20, 35,262,383, 20, 34 ); insert into partition (SUBSYSID, TOPUSERSIZE, LEFTUSERSIZE, HEIGHTUSERSIZE, WIDTHUSERSIZE, TOPPWDSIZE, primary, TOPLOGINSIZE, primary, primary, WIDTHLOGINSIZE, TOPEXITSIZE, primary, primary, 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, weight, WIDTHPWDSIZE, TOPLOGINSIZE, LEFTLOGINSIZE, HEIGHTLOGINSIZE, WIDTHLOGINSIZE, TOPEXITSIZE, LEFTEXITSIZE, distance, WIDTHEXITSIZE) values (6023,321,105, 22,126,321,275, 22,128,319,411, 26, 26, 55); commit;