Open Sakurasan opened 5 years ago
https://www.cnblogs.com/skylumia/p/4685326.html
查询某条,修改某字段以后再插入
主要用到 ‘B0’ as TRAN—TP
insert into apstfr.tbl_mgm_mcht_map_inf select (OBJ_INS_CD, RULE_NAME, RULE_PROI, 'B0' as TRAN_TP, PROD_CD, TRN_CD, BIZ_CD, MCHNT_GRP, MCHNT_CD, TERM_CD, MCC_M_TP, MCC_S_TP, MCC_CD, SPEC_BILL, ACQ_INS_CD, FWD_INS_CD, ISS_INS_GRP, ISS_INS_CD, ACCT_BANK_NO, CARD_BIN, CARD_CLASS, AMT_LOW, AMT_HIGH, RULE_S_DT, RULE_E_DT, RULE_S_TM, RULE_E_TM, AMT_INT, OEM_BRAND, DES_ACQ_INS_CD, DES_MCC_CD, DES_MCHNT_GRP, DES_MCHNT_CD, DES_MCHNT_NM, DES_TERM_CD, DES_BILL_FLG, RULE_USE_FLG, OPER_IN, EVENT_ID, REC_ID, REC_UPD_USR_ID, REC_UPD_TS, REC_CRT_TS) from apstfr.tbl_mgm_mcht_map_inf where mchnt_cd = '862491053110001'
oracle查询连接的用户和数量
https://www.cnblogs.com/skylumia/p/4685326.html
查询某条,修改某字段以后再插入
insert into apstfr.tbl_mgm_mcht_map_inf select (OBJ_INS_CD, RULE_NAME, RULE_PROI, 'B0' as TRAN_TP, PROD_CD, TRN_CD, BIZ_CD, MCHNT_GRP, MCHNT_CD, TERM_CD, MCC_M_TP, MCC_S_TP, MCC_CD, SPEC_BILL, ACQ_INS_CD, FWD_INS_CD, ISS_INS_GRP, ISS_INS_CD, ACCT_BANK_NO, CARD_BIN, CARD_CLASS, AMT_LOW, AMT_HIGH, RULE_S_DT, RULE_E_DT, RULE_S_TM, RULE_E_TM, AMT_INT, OEM_BRAND, DES_ACQ_INS_CD, DES_MCC_CD, DES_MCHNT_GRP, DES_MCHNT_CD, DES_MCHNT_NM, DES_TERM_CD, DES_BILL_FLG, RULE_USE_FLG, OPER_IN, EVENT_ID, REC_ID, REC_UPD_USR_ID, REC_UPD_TS, REC_CRT_TS) from apstfr.tbl_mgm_mcht_map_inf where mchnt_cd = '862491053110001'