insert into test(tddid,name)
select sequence_id.nextval,name from
(
select '2' as name from dual
union all
select '2' as name from dual
)
select sequence_id.nextval,name from
(
select '2' as name from dual
union all
select '2' as name from dual
)
感谢网友:杭州-小鹿
ibatis 迭代插入:(提高插入效率,一条条插入1000条3分钟,用这个9000条33秒)
<insert id="testSql" parameterClass="java.util.Map">
INSERT
INTO test (
tddid,
name
)
select
sequence_id.nextval,
name
from
<iterate property="testList" open="(" close=")" conjunction="union all">
select
#testList[].name# as name
from dual
</iterate>
</insert>
INSERT
INTO test (
tddid,
name
)
select
sequence_id.nextval,
name
from
<iterate property="testList" open="(" close=")" conjunction="union all">
select
#testList[].name# as name
from dual
</iterate>
</insert>