Oracle 创建临时表
Oracle 存储过程中不像SQLServer 中 在存储过程中用#就可以创建临时表,用来缓存需要处理的数据。Oracle主要需要物理创建临时表结构,用到global temporary table 关键字。
语法如下:
-- Create table
create global temporary table TBL_TEMP_MULTIPREPAY
(
PAY_ID NUMBER(20),
DPT_CDE VARCHAR2(11),
DPT_NME VARCHAR2(100),
THR_DPT_NME VARCHAR2(100),
PROD_KIND VARCHAR2(10),
CASE_NO VARCHAR2(30),
CLAIM_NO VARCHAR2(30),
PLY_NO VARCHAR2(30),
DISPATCH_ID NUMBER(20)
CREATE_TM DATE,
CLM_TMS_DISP NUMBER(22),
DONE_TM DATE,
DONE_AMT NUMBER(20,2)
)
on commit delete rows;
-- Add comments to the table
comment on table TBL_TEMP_MULTIPREPAY
is '仅供多次赔付清单使用';
相关推荐
Carlos 2020-05-26
liuyang000 2020-09-25
康慧欣 2020-09-10
zoroday 2020-07-05
URML 2020-07-04
xinluliu0 2020-06-16
favouriter 2020-06-05
talkingDB 2020-05-05
azhou 2020-03-08
achiverhai 2020-03-04
adsadadaddadasda 2020-03-03
mycosmos 2020-03-03
helencoder 2020-02-20
gululululu 2020-02-12
hithyc 2020-02-02
步行者 2020-01-06
applex 2019-12-29
huacuilaifa 2019-12-23
zhuzhufxz 2019-12-22