ibatis组合Oracle的iterate insert批量插入
ibatis结合Oracle的iterate insert批量插入ibatis批量插入oracle数据库<insert id="batchInsert" parameterClass="java.util.List">INSERT INTO SYS_ROLE_MENU(ROLE_ID, MENU_ID )SELECT A.*FROM (<iterate conjunction ="union all"…
ibatis结合Oracle的iterate insert批量插入ibatis批量插入oracle数据库<insert id="batchInsert" parameterClass="java.util.List">INSERT INTO SYS_ROLE_MENU(ROLE_ID, MENU_ID )SELECT A.*FROM (<iterate conjunction ="union all"…