主要的坑:
1、在于date类型的处理,其中apply time是dateTime类型
2、在于要把\‘替换成’
mysql导出语句
INSERT INTO `xpims_trd`.`txqa_grp_rule_item`(`G_CODE`, `ITEM_CODE`, `ITEM_NAME`, `ITEM_ORDER`, `ITEM_DESC`, `ITEM_EXPR`, `ITEM_EXPR_DESC`, `APPLY_TIME`) VALUES ('GR_211208135748ede439', 'GI_2112081439231acd1c', '买入返售金融资产', 6, NULL, ' CASH.CASH_OTHER_TYPE in( \'逆回购\',\'逆回购_利息\' ) ', NULL, '0000-00-00 00:00:00');
oracle插入语句,其中apply time 为date类型
INSERT INTO TXQA_GRP_RULE_ITEM(G_CODE, ITEM_CODE, ITEM_NAME, ITEM_ORDER, ITEM_DESC, ITEM_EXPR, ITEM_EXPR_DESC, APPLY_TIME) VALUES ('GR_2112101128203c1dbc', 'GI_211210112820f5cf6a', '期货保证金', 0, NULL, ' CASH.CASH_OTHER_TYPE = ''期货保证金'' ', ' ', to_date('01-01-1900', 'dd-mm-yyyy'));