步骤一;
创建两张测试表;
创建表主表
COR_GTW_CESHI
备份表
COR_GTW_CESHI_BEIFEN
-- Create table
create table COR_GTW_CESHI
(
id CHAR(20) not null,
cmd_type VARCHAR2(40),
req_package_id CHAR(20),
req_seq_no VARCHAR2(32),
cmd_status CHAR(2),
req_times INTEGER,
ref_biz_id CHAR(20),
trans_no VARCHAR2(32),
pay_acnt_no VARCHAR2(32),
pay_acnt_name VARCHAR2(80),
pay_bank_code VARCHAR2(12),
pay_bank_name VARCHAR2(80),
rec_acnt_no VARCHAR2(32),
rec_acnt_name VARCHAR2(80)