create table CAPCHKMERC(
   CORG_NO	     VARCHAR2(30)    not null,
   --银行简称
   MERC_ID	     VARCHAR2(30)    not null,
   --商户号   
   MERC_NAM	     VARCHAR2(30)    ,
   --商户名称
   TXN_CNL	     VARCHAR2(30)    not null,
   --渠道标志
   TM_SMP        VARCHAR2(26) DEFAULT SYSDATE not null,
   --时间戳  
   CONSTRAINT CAPCHKMERC_PK PRIMARY KEY (CORG_NO,MERC_ID) 
   );   
     
insert into CAPCHKMERC (CORG_NO, MERC_ID, MERC_NAM, TXN_CNL) 
       values('PAB','800075500050015','壹钱包','1qianbao | haofang | trust');
       
insert into CAPCHKMERC (CORG_NO, MERC_ID, MERC_NAM, TXN_CNL) 
       values('PAB','800021000080018','陆金所','lufax');
       
insert into CAPCHKMERC (CORG_NO, MERC_ID, MERC_NAM, TXN_CNL) 
       values('BOC','800075500050015','壹钱包','1qianbao | haofang | trust');
       
insert into CAPCHKMERC (CORG_NO, MERC_ID, MERC_NAM, TXN_CNL) 
       values('ICBC','800075500050015','壹钱包','1qianbao');  
       
insert into CAPCHKMERC (CORG_NO, MERC_ID, MERC_NAM, TXN_CNL) 
       values('ICBC','800021000080018','陆金所','lufax');   
       
insert into CAPCHKMERC (CORG_NO, MERC_ID, MERC_NAM, TXN_CNL) 
       values('CCB','800075500050015','壹钱包','1qianbao | haofang | trust');
       
insert into CAPCHKMERC (CORG_NO, MERC_ID, MERC_NAM, TXN_CNL) 
       values('CCB','800021000080018','陆金所','lufax');    
       
insert into CAPCHKMERC (CORG_NO, MERC_ID, MERC_NAM, TXN_CNL) 
       values('CMBC','800075500050015','壹钱包','1qianbao');