PLSQL同时执行多条语句实例(五)
s('f6d523d0-b8d1-4389-97ee-027a0bfa5f76','泵站工程','SLGC_Bump_Pot','f6d523d0-b8d1-4389-97ee-027a0bfa5f73',2,7,1);
insert into TBSLSWDICTTHEMETYPE(ThemetypeGuid,Themetypename,Themetypecode,Parentguid,Themelevel,showorderid,Isused)
values('f6d523d0-b8d1-4389-97ee-027a0bfa5f77','堤防工程','SLGC_DiF_Arc','f6d523d0-b8d1-4389-97ee-027a0bfa5f73',2,8,1);
insert into TBSLSWDICTTHEMETYPE(ThemetypeGuid,Themetypename,Themetypecode,Parentguid,Themelevel,showorderid,Isused)
values('f6d523d0-b8d1-4389-97ee-027a0bfa5f78','堤防特征断面','SLGC_DiFDM_Arc','f6d523d0-b8d1-4389-97ee-027a0bfa5f73',2,9,1);
insert into TBSLSWDICTTHEMETYPE(ThemetypeGuid,Themetypename,Themetypecode,Parentguid,Themelevel,showorderid,Isused)
values('f6d523d0-b8d1-4389-97ee-027a0bfa5f79','圩区基本情况','SLGC_WeiQu_Poly','f6d523d0-b8d1-4389-97ee-027a0bfa5f73',2,10,1);
insert into TBSLSWDICTTHEMETYPE(ThemetypeGuid,Themetypename,Themetypecode,Parentguid,Themelevel,showorderid,Isused)
values('f6d523d0-b8d1-4389-97ee-027a0bfa5f80','塘坝工程','SLGC_TangBa_Arc','f6d523d0-b8d1-4389-97ee-027a0bfa5f73',2,11,1);
/*社会经济用水*/
insert into TBSLSWDICTTHEMETYPE(ThemetypeGuid,Themetypename,Themetypecode,Parentguid,Themelevel,showorderid,Isused)
values('f6d523d0-b8d1-4389-97ee-027a0bfa5f81','经济社会用水','SLJJ',null,1,3,1);
--插入子项
insert into TBSLSWDICTTHEMETYPE(ThemetypeGuid,Themetypename,Themetypecode,Parentguid,Themelevel,showorderid,Isused)
values('f6d523d0-b8d1-4389-97ee-027a0bfa5f82','规模化畜禽养殖场用水','SLJJ_ChuQYZC_Poly','f6d523d0-b8d1-4389-97ee-027a0bfa5f81',2,12,1);
insert into TBSLSWDICTTHEMETYPE(ThemetypeGuid,Themetypename,Themetypecode,Parentguid,Themelevel,showorderid,Isused)
values('f6d523d0-b8d1-4389-97ee-027a0bfa5f83','公共供水企业用水','SLJJ_GGGSQY_Pot','f6d523d0-b8d1-4389-97ee-027a0bfa5f81',2,13,1);
insert into TBSLSWDICTTHEMETYPE(ThemetypeGuid,Themetypename,Themetypecode,Parentguid,Themelevel,showorderid,Isused)
values('f6d523d0-b8d1-4389-97ee-027a0bfa5f84','工业企业用水','SLJJ_GYeQY_Pot','f6d523d0-b8d1-4389-97ee-027a0bfa5f81',2,14,1);
insert into TBSLSWDICTTHEMETYPE(ThemetypeGuid,Themetypename,Themetypecode,Parentguid,Themelevel,showorderid,Isused)
values('f6d523d0-b8d1-4389-97ee-027a0bfa5f85','建筑业及第三产业用水','SLJJ_JZYeDiSanCY_Pot','f6d523d0-b8d1-4389-97ee-027a0bfa5f81',2,15,1);
/*河湖开发治理保护情况*/
insert into TBSLSWDICTTHEMETYPE(ThemetypeGuid,Themetypename,Themetypecode,Parentguid,Themelevel,showorderid,Isused)
values('f6d523d0-b8d1-4389-97ee-027a0bfa5f86','河湖开发治理保护情况','SLKF',null,1,4,1);
--插入子项
insert into TBSLSWDICTTHEMETYPE(ThemetypeGuid,Themetypename,Themetypecode,Parentguid,Themelevel,showorderid,Isused)
values('f6d523d0-b8d1-4389-97ee-027a0bfa5f87','河湖取水口（规模以上）','SLKF_HHQSKBig_Pot','f6d523d0-b8d1-4389-97ee-027a0bfa5f86',2,16,1);
insert into TBSLSWDICTTHEMETYPE(ThemetypeGuid,Themetypename,Themetypecode,Parentguid,Themelevel,showorderid,Isused)
values('f6d523d0-b8d1-4389-97ee-027a0bfa5f88','地表水水源地','SLKF_DMSSYD_Pot','f6d523d0-b8d1-4389-97ee-027a0bfa5f86',2,17,1);
insert into TBSLSWDICTTHEMETYPE(