Oracle 创建临时表

-- Create table
create global temporary table BI_TEMP
(
  IKOU_FLAG         CHAR(1 ) default 1,
  IKOU_PGID         CHAR(20 ),
  IKOU_JOBID        CHAR(20 ),
  IKOU_INSERT_DATE  DATE,
  IKOU_UPDATE_PGID  CHAR(20 ),
  IKOU_UPDATE_JOBID CHAR(20 ),
  IKOU_UPDATE_DATE  DATE,
  IKOU_UPDATE_FLAG  CHAR(1 ) default 0,
  IKOU_FLAG2        CHAR(1 ) default 1,
  IKOU_UPDATE_FLAG2 CHAR(1 ) default 0,
  IKOU_FLAG3        CHAR(1 ) default 1,
  IKOU_UPDATE_FLAG3 CHAR(1 ) default 0,
  IKOU_FLAG4        CHAR(1 ) default 1,
  IKOU_UPDATE_FLAG4 CHAR(1 ) default 0,
  IKOU_FLAG5        CHAR(1 ) default 1,
  IKOU_UPDATE_FLAG5 CHAR(1 ) default 0,
  K001              VARCHAR2(200 ),
  K002              VARCHAR2(200 ),
  K003              VARCHAR2(200 ),
  K004              VARCHAR2(200 ),
  K005              VARCHAR2(200 ),
  K006              VARCHAR2(200 ),
  K007              VARCHAR2(200 ),
  V001              VARCHAR2(4000 ),
  V002              VARCHAR2(4000 ),
  V003              VARCHAR2(4000 ),
  V004              VARCHAR2(4000 ),
  V005              VARCHAR2(4000 ),
  V006              VARCHAR2(4000 ),
  V007              VARCHAR2(4000 ),
  V008              VARCHAR2(4000 ),
  V009              VARCHAR2(4000 ),
  V010              VARCHAR2(4000 ),
  V011              VARCHAR2(4000 ),
  V012              VARCHAR2(4000 ),
  V013              VARCHAR2(4000 )
)
on commit preserve rows;