ibatis 在oracle中不重复插入

  ibatis，在oracle中不重复插入可以用一句sql来实现，具体如下：

   

INSERT INTO a (id,CARD,TRADEMONEY,MONEY,FEE,TRADETIME,MERCHANT,TRACEAUDITNO,BATCHNO,CHANNEL_TRACEAUDITNO,flag,INDEXCODE,LQUIDDATE)
SELECT
b_seq_id.nextval,#map9#,#map7#,#qingsuan#,#map8#,#map0#,#map2#,#map4#,'','','0',#map1#,#map81#
FROM DUAL WHERE

#map9#||#map7#||#qingsuan#||#map8#||#map0#

NOT IN (SELECT CARD||TRADEMONEY||MONEY||FEE||TRADETIME FROM a)