insert into TS_SYS_STAFFCERTMANAGER
(
ID,
ORANAME,
STAFFNAME,
CERTTYPE,
CERTNAME,
CERTCODE,
CERTACCESSORYATT,
STAFFID,
starttime,
endtime,
catalogid
)
select ts_sys_staffcertmanager_id_seq.nextval,A.* from(
<foreach collection="list" item="item" index="index" separator="union all" >
select
#{item.oraname,jdbcType=VARCHAR},
#{item.staffname,jdbcType=VARCHAR},
#{item.certtype,jdbcType=VARCHAR},
#{item.certname,jdbcType=VARCHAR},
#{item.certcode,jdbcType=VARCHAR},
#{item.certaccessoryatt,jdbcType=VARCHAR},
#{item.staffid,jdbcType=INTEGER},
#{item.starttime,jdbcType=DATE},
#{item.endtime,jdbcType=DATE},
#{item.catalogid,jdbcType=VARCHAR}
from dual
</foreach>
)A
(
ID,
ORANAME,
STAFFNAME,
CERTTYPE,
CERTNAME,
CERTCODE,
CERTACCESSORYATT,
STAFFID,
starttime,
endtime,
catalogid
)
select ts_sys_staffcertmanager_id_seq.nextval,A.* from(
<foreach collection="list" item="item" index="index" separator="union all" >
select
#{item.oraname,jdbcType=VARCHAR},
#{item.staffname,jdbcType=VARCHAR},
#{item.certtype,jdbcType=VARCHAR},
#{item.certname,jdbcType=VARCHAR},
#{item.certcode,jdbcType=VARCHAR},
#{item.certaccessoryatt,jdbcType=VARCHAR},
#{item.staffid,jdbcType=INTEGER},
#{item.starttime,jdbcType=DATE},
#{item.endtime,jdbcType=DATE},
#{item.catalogid,jdbcType=VARCHAR}
from dual
</foreach>
)A