PLSQL同时执行多条语句实例(三)
，顶点1Y坐标)，(顶点2X坐标，顶点2Y坐标)，(顶点3X坐标，顶点3Y坐标)';
comment on column TBSLSWDATAEXPORTLOG.targetformat
is '0：Excel
1：Shapefile
2：AutoCad
3：Personal Geodatabase
4：File Geodatabase
';
comment on column TBSLSWDATAEXPORTLOG.datafileurl
is '要
下载的文件名称名称Url路径';
comment on column TBSLSWDATAEXPORTLOG.applyuserid
is '引用tbUsers表';
comment on column TBSLSWDATAEXPORTLOG.applyunit
is '申请单位名称';
comment on column TBSLSWDATAEXPORTLOG.applytime
is '格式：yyyy-mm-dd hh:mm';
comment on column TBSLSWDATAEXPORTLOG.proccessstate
is '0：申请中
1：审核未通过
2：审核通过
3：文件生成错误
4：文件生成成功
5：已下载
';
comment on column TBSLSWDATAEXPORTLOG.logcontent
is '处理日志描述，XML格式，包括“编号、时间、事件、处理人、处理情况、结果”等数据项';
comment on column TBSLSWDATAEXPORTLOG.audituserid
is '引用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;
--初始化表TBSLSWDICTTHEMETYPE的数据
/*河湖基本情况*/
insert into TBSLSWDICTTHEMETYPE(ThemetypeGuid,Themetypename,Themetypecode,Parentguid,Themelevel,showorderid,Isused)
values('f6d523d0-b8d1-4389-97ee-027a0bfa5f68','河湖基本情况','SLHH',null,1,1,1);
--插入子项
insert into TBSLSWDICTTHEMETYPE(ThemetypeGuid,Themetypename,Themetypecode,Parentguid,Themelevel,showorderid,Isused)
values('f6d523d0-b8d1-4389-97ee-027a0bfa5f69','河流基本情况','SLHH_HeLiu_Poly','f6d523d0-b8d1-4389-97ee-027a0bfa5f68',2,1,1);
insert into TBSLSWDICTTHEMETYPE(ThemetypeGuid,Themetypename,Themetypecode,Parentguid,Themelevel,showorderid,Isused)
values('f6d523d0-b8d1-4389-97ee-027a0bfa5f70','湖泊基本情况','SLHH_HuPo_Poly','f6d523d0-b8d1-4389-97ee-027a0bfa5f68',2,2,1);
insert into TBSLSWDICTTHEMETYPE(ThemetypeGuid,Themetypename,Themetypecode,Parentguid,Themelevel,showorderid,Isused)
values('f6d523d0-b8d1-4389-97ee-027a0bfa5f71','水文站和水位站情况','SLHH_SWZ_Pot','f6d523d0-b8d1-4389-97ee-027a0bfa5f68',2,3,1);
insert into TBSLSWDICTTHEMETYPE(ThemetypeGuid,Themetypename,Themetypecode,Parentguid,Themelevel,showorderid,Isused)
values('f6d523d0-b8d1-4389-97ee-027a0bfa5f72','河流断面情况','SLHH_HLDM_Arc','f6d523d0-b8d1-4389-97ee-027a0bfa5f68',2,4,1);
/*水利工程*/
insert into TBSLSWDICTTHEMETYPE(ThemetypeGuid,Themetypename,Themetypecode,Parentguid,Themelevel,showorderid,Isused)
values('f6d523d0-b8d1-4389-97ee-027a0bfa5f73','水利工程','SLGC',null,1,2,1);
--插入子项
insert into TBSLSWDICTTHEMETYPE(ThemetypeGuid,Themetypename,Themetypecode,Parentguid,Themelevel,showorderid,Isused)
values('f6d523d0-b8d1-4389-97ee-027a0bfa5f74','水电站工程','SLGC_SDZ_Pot','f6d523d0-b8d1-4389-97ee-027a0bfa5f73',2,5,1);
insert into TBSLSWDICTTHEMETYPE(ThemetypeGuid,Themetypename,Themetypecode,Parentguid,Themelevel,showorderid,Isused)
values('f6d523d0-b8d1-4389-97ee-027a0bfa5f75','水闸工程','SLGC_SZha_Pot','f6d523d0-b8d1-4389-97ee-027a0bfa5f73',2,6,1);
insert into TBSLSWDICTTHEMETYPE(ThemetypeGuid,Themetypename,Themetypecode,Parentguid,Themelevel,showorderid,Isused)
value