需求:
mybatis使用注解批量向oracle数据库插入数据
问题:
使用如下脚本生成SQL语句为:insert into mini_view_user_topic t (uuid, userid, topicid) values ('5', '3', '1' ),('6', '3', '2' ),('7', '3', '3' );
使用以上SQL语句在oracle中执行,报错:ORA-00999:SQL命令未正确结束
@Insert({
"<script>",
"insert into mini_view_user_topic t (uuid, userid, topicid) values ",
"<foreach collection='topics' item='item' index='index' separator=','>",
"(#{item.uuid}, #{userId}, #{item.topicId} )",
"</foreach>",