频道栏目
首页 > 数据库 > Oracle > 正文
PLSQL同时执行多条语句实例
2013-04-10 15:46:37         来源:Burongwawa520的专栏  
收藏   我要投稿

PLSQL同时执行多条语句实例

 

/*建表*/

/*创建表TBSLSWDICTTHEMETYPE*/

/*创建表TBSLSWDICTTHEMETYPE*/

-- Create table

create 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 '专题类型名称,不能重复,例如:河湖基本情况';

comment on column TBSLSWDICTTHEMETYPE.themetypecode

  is '用户程序编码,编号规则:SL+“专题名称拼音首字母”例如:SLHH,表示“河湖基本情况”,专题类型代码不能重复';

comment on column TBSLSWDICTTHEMETYPE.parentguid

  is '父级专题GUID,为空表示最顶层';

comment on column TBSLSWDICTTHEMETYPE.themelevel

  is '当前处于哪个等级';

comment on column TBSLSWDICTTHEMETYPE.showorderid

  is '流水号,用来调整专题数据列表时的显示顺序';

comment on column TBSLSWDICTTHEMETYPE.isused

  is '是否启用:

0:未启用

1:已启用

';

-- 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 64K

    next 1M

    minextents 1

    maxextents unlimited

  );

alter table TBSLSWDICTTHEMETYPE

  add constraint U_THEMETYPECODE unique (THEMETYPECODE)

  using index 

  tablespace SZSLSYS

  pctfree 10

  initrans 2

  maxtrans 255

  storage

  (

    initial 64K

    next 1M

    minextents 1

    maxextents unlimited

  );

alter table TBSLSWDICTTHEMETYPE

  add constraint U_THEMETYPENAME unique (THEMETYPENAME)

  using index 

  tablespace SZSLSYS

  pctfree 10

  initrans 2

  maxtrans 255

  storage

  (

    initial 64K

    next 1M

    minextents 1

    maxextents unlimited

  );

alter table TBSLSWDICTTHEMETYPE

  add constraint FK_THEMETYPEGUID_THEMETYPEGUID foreign key (PARENTGUID)

  references TBSLSWDICTTHEMETYPE (THEMETYPEGUID);

 

/*创建表TBSLSWDATAIMPORTLOG*/

-- Create table

create table TBSLSWDATAIMPORTLOG

(

  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 '要入库的水利水务专题数据类型编号,字段值来源水利水务专题数据字典表中的专题类型编号字段';

comment on column TBSLSWDATAIMPORTLOG.processstate

  is '0:上传失败

1:上传成功

2:审核通过

3:审核未通过

4:检查失败

5:检查成功

6:入临时库失败

7:入临时库成功

8:入现势库失败

9:入现势库成功

';

comment on column TBSLSWDATAIMPORTLOG.logcontent

  is '处理日志描述,XML格式,包括“编号、时间、事件、处理人、处理情况、结果”等数据项';

comment on column TBSLSWDATAIMPORTLOG.submitdepartment

  is '数据提交单位名称,对于公共服务平台上传的,可以是上传单位名称;';

comment on column TBSLSWDATAIMPORTLOG.submittime

  is '格式:yyyy-mm-dd hh:mm';

comment on column TBSLSWDATAIMPORTLOG.sourcefilename

  is '只记录文件名,不必带路径';

comment on column TBSLSWDATAIMPORTLOG.sourcedataformat

  is '0:Shapefile

1:AutoCad

2:Personal Geodatabase

3:File Geodatabase

4:Mdb中间库

';

comment on column TBSLSWDATAIMPORTLOG.reccount

  is '源数据记录数';

comment on column TBSLSWDATAIMPORTLOG.datarange

  is '数据范围顶点坐标,格式:(顶点1X坐标,顶点1Y坐标),(顶点2X坐标,顶点2Y坐标),(顶点3X坐标,顶点3Y坐标)';

comment on column TBSLSWDATAIMPORTLOG.tempdsname

  is '临时库SDE DataSet名称';

comment on column TBSLSWDATAIMPORTLOG.tempfcname

  is '临时库SDE Featureclass名称';

comment on column TBSLSWDATAIMPORTLOG.intemplibtime

  is '格式:yyyy-mm-dd hh:mm,记录最后一次数据处理时间';

comment on column TBSLSWDATAIMPORTLOG.currdsname

  is '现势库SDE DataSet名称';

comment on column TBSLSWDATAIMPORTLOG.currfcname

  is '现势库SDE Featureclass名称';

comment on column TBSLSWDATAIMPORTLOG.intemplibmodel

  is '入库方式:

0:更新方式入库

1:增量方式入库

';

comment on column TBSLSWDATAIMPORTLOG.incurrlibmodel

  is '入库方式:

0:更新方式入库

1:增量方式入库

';

comment on column TBSLSWDATAIMPORTLOG.incurrlibtime

  is '格式:yyyy-mm-dd hh:mm,记录最后一次数据处理时间';

-- Create/Recreate primary, unique and foreign key constraints 

alter table TBSLSWDATAIMPORTLOG

  add constraint PK_LOGGUID primary key (LOGGUID)

  using index 

  tablespace SZSLSYS

  pctfree 10

  initrans 2

  maxtrans 255

  storage

  (

    initial 64K

    next 1M

    minextents 1

    maxextents unlimited

  );

alter table TBSLSWDATAIMPORTLOG

  add constraint FK_LOGGUID_THEMETYPEGUID foreign key (THEMETYPEGUID)

  references TBSLSWDICTTHEMETYPE (THEMETYPEGUID);

 

 

--创建表TBSLSWDATAEXPORTLOG

create table TBSLSWDATAEXPORTLOG

(

  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 '多个专题类型,可以用逗号分隔';

comment on column TBSLSWDATAEXPORTLOG.datarange

  is '逗号分隔的数据范围多边形顶点坐标,格式:(顶点1X坐标,顶点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)

values('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(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','91b3a646-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;

 

点击复制链接 与好友分享!回本站首页
上一篇:Oracle监听服务强制被关闭不能启动TNS识别问题解决
下一篇:Pl sql case语句应用实例
相关文章
图文推荐
文章
推荐
点击排行

关于我们 | 联系我们 | 广告服务 | 投资合作 | 版权申明 | 在线帮助 | 网站地图 | 作品发布 | Vip技术培训 | 举报中心

版权所有: 红黑联盟--致力于做实用的IT技术学习网站