PLSQL同时执行多条语句实例(六)
ThemetypeGuid,Themetypename,Themetypecode,Parentguid,Themelevel,showorderid,Isused)
values('f6d523d0-b8d1-4389-97ee-027a0bfa5f89','河流治理保护情况','SLKF_HLZLBH_Poly','f6d523d0-b8d1-4389-97ee-027a0bfa5f86',2,18,1);
insert into TBSLSWDICTTHEMETYPE(ThemetypeGuid,Themetypename,Themetypecode,Parentguid,Themelevel,showorderid,Isused)
values('f6d523d0-b8d1-4389-97ee-027a0bfa5f90','湖泊治理保护情况','SLKF_HPZLBH_Poly','f6d523d0-b8d1-4389-97ee-027a0bfa5f86',2,19,1);
insert into TBSLSWDICTTHEMETYPE(ThemetypeGuid,Themetypename,Themetypecode,Parentguid,Themelevel,showorderid,Isused)
values('f6d523d0-b8d1-4389-97ee-027a0bfa5f91','入河湖排污口','SLKF_RuHHPWK_Pot','f6d523d0-b8d1-4389-97ee-027a0bfa5f86',2,20,1);
/*水利行业能力建设情况*/
insert into TBSLSWDICTTHEMETYPE(ThemetypeGuid,Themetypename,Themetypecode,Parentguid,Themelevel,showorderid,Isused)
values('f6d523d0-b8d1-4389-97ee-027a0bfa5f92','水利行业能力建设情况','SLNL',null,1,5,1);
--插入子项
insert into TBSLSWDICTTHEMETYPE(ThemetypeGuid,Themetypename,Themetypecode,Parentguid,Themelevel,showorderid,Isused)
values('f6d523d0-b8d1-4389-97ee-027a0bfa5f93','水利行政机关','SLNL_XZJG_Pot','f6d523d0-b8d1-4389-97ee-027a0bfa5f92',2,21,1);
insert into TBSLSWDICTTHEMETYPE(ThemetypeGuid,Themetypename,Themetypecode,Parentguid,Themelevel,showorderid,Isused)
values('f6d523d0-b8d1-4389-97ee-027a0bfa5f94','水利事业单位','SLNL_SYDW_Pot','f6d523d0-b8d1-4389-97ee-027a0bfa5f92',2,22,1);
insert into TBSLSWDICTTHEMETYPE(ThemetypeGuid,Themetypename,Themetypecode,Parentguid,Themelevel,showorderid,Isused)
values('f6d523d0-b8d1-4389-97ee-027a0bfa5f95','水利企业','SLNL_SLQY_Pot','f6d523d0-b8d1-4389-97ee-027a0bfa5f92',2,23,1);
insert into TBSLSWDICTTHEMETYPE(ThemetypeGuid,Themetypename,Themetypecode,Parentguid,Themelevel,showorderid,Isused)
values('f6d523d0-b8d1-4389-97ee-027a0bfa5f96','水利社会团体','SLNL_SheHTT_Pot','f6d523d0-b8d1-4389-97ee-027a0bfa5f92',2,24,1);
insert into TBSLSWDICTTHEMETYPE(ThemetypeGuid,Themetypename,Themetypecode,Parentguid,Themelevel,showorderid,Isused)
values('f6d523d0-b8d1-4389-97ee-027a0bfa5f97','乡镇水利管理单位','SLNL_XZhenGLDW_Pot','f6d523d0-b8d1-4389-97ee-027a0bfa5f92',2,25,1);
/*水利行业能力建设情况*/
insert into TBSLSWDICTTHEMETYPE(ThemetypeGuid,Themetypename,Themetypecode,Parentguid,Themelevel,showorderid,Isused)
values('f6d523d0-b8d1-4389-97ee-027a0bfa5f98','灌溉专项','SLGG',null,1,6,1);
--插入子项
insert into TBSLSWDICTTHEMETYPE(ThemetypeGuid,Themetypename,Themetypecode,Parentguid,Themelevel,showorderid,Isused)
values('f6d523d0-b8d1-4389-97ee-027a0bfa5f99','灌区','SLGG_GQu_Poly','f6d523d0-b8d1-4389-97ee-027a0bfa5f98',2,26,1);
/*水利行业能力建设情况*/
insert into TBSLSWDICTTHEMETYPE(ThemetypeGuid,Themetypename,Themetypecode,Parentguid,Themelevel,showorderid,Isused)
values('91b3a646-efb4-4966-b8a8-47caead02204','地下水取水井专项','SLQS',null,1,7,1);
--插入子项
insert into TBSLSWDICTTHEMETYPE(ThemetypeGuid,Themetypename,Themetypecode,Parentguid,Themelevel,showorderid,Isused)
values('91b3a646-efb4-4966-b8a8-47caead02205','规模以上机电井','SLQS_JDJBig_Pot','91b3a