13 lines
523 B
SQL
13 lines
523 B
SQL
CREATE GLOBAL TEMPORARY TABLE CAPBATABC(
|
|
CAP_ORD_NO VARCHAR2(35) NOT NULL,
|
|
CRD_NO VARCHAR2(35) NOT NULL,
|
|
NEW_CRD_NO VARCHAR2(35) DEFAULT '',
|
|
TXN_AMT NUMBER(13,2) DEFAULT '',
|
|
IN_OUT_SIGN VARCHAR2(2) DEFAULT '',
|
|
TRSP_CD VARCHAR2(4) DEFAULT '',
|
|
TTXN_ST VARCHAR2(2) DEFAULT '',
|
|
TRSP_MSG VARCHAR2(30) DEFAULT '',
|
|
TM_SMP VARCHAR2(26) DEFAULT SYSDATE not null,
|
|
CONSTRAINT CAPBATABC_PK PRIMARY KEY (CAP_ORD_NO,CRD_NO)
|
|
)
|
|
ON COMMIT PRESERVE ROWS; |