Mybatis循环插入Oracle数据库
查询索引
select SEQUENCE_NAME from user_sequences;
循环插入
第一种:
INSERT INTO XXXX(
xxx,
xxx,
xxx,
xxx
)
SELECT
索引.NEXTVAL AS ID, A.*
FROM
(
<foreach collection="list" item="item" index="index" separator="UNION ALL">
SELECT
#{item.ID},
#{item.xxx},
#{item.xxx}
FROM dual
</foreach>
) A
</insert>
第二种:
INSERT INTO XXXX(
xxx,
xxx,
xxx,
xxx
)
SELECT
索引.NEXTVAL,
#{item.xxx},
#{item.xxx},
#{item.xxx}
FROM dual
) A