oracle创建事务级临时表

-- Create table
create global temporary table YS_GRYJ_GTT
(
  XTJGDM   VARCHAR2(4) not null,
  GRSXH    NUMBER(12) not null,
  DWSXH    NUMBER(12) not null,
  XZLX     VARCHAR2(3) not null,
  JFLB     VARCHAR2(3),
  JFNY     NUMBER(6) not null,
  YJLX     VARCHAR2(3) not null,
  SHNY     NUMBER(6) not null,
  JFJS     NUMBER(10,2) not null,
  GRJFJE   NUMBER(10,2),
  HRZHJE   NUMBER(10,2),
  CHRZHJE  NUMBER(10,2),
  ZHRZHJE  NUMBER(10,2),
  SHRZHJE  NUMBER(10,2),
  HRTCJE   NUMBER(10,2),
  CHRTCJE  NUMBER(10,2),
  ZHRTCJE  NUMBER(10,2),
  SHRTCJE  NUMBER(10,2),
  GRJFLX   NUMBER(10,2),
  HRZHLX   NUMBER(10,2),
  CHRZHLX  NUMBER(10,2),
  ZHRZHLX  NUMBER(10,2),
  SHRZHLX  NUMBER(10,2),
  HRTCLX   NUMBER(10,2),
  CHRTCLX  NUMBER(10,2),
  ZHRTCLX  NUMBER(10,2),
  SHRTCLX  NUMBER(10,2),
  JFFS     VARCHAR2(3),
  ZNJ      NUMBER(10,2),
  LXJSBZ   VARCHAR2(3),
  ZNJJSBZ  VARCHAR2(3),
  ZHJXRQ   DATE,
  ZHJZNJRQ DATE,
  TZBGSXH  NUMBER(12),
  CSDSBZ   VARCHAR2(3),
  DWJFBZ   VARCHAR2(3) not null,
  JFSXH    NUMBER(12),
  BZ       VARCHAR2(3),
  HBYWLSH  VARCHAR2(64)
)
on commit delete rows;
-- Create/Recreate indexes 
create index INDX_GRYJ_GTT_GRSXH on YS_GRYJ_GTT (GRSXH);
create index IND_YS_GRYJ_GTT_GRSXH on YS_GRYJ_GTT (GRSXH, XZLX);