-- 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;
Oracle 创建临时表
最新推荐文章于 2021-07-05 09:16:08 发布