2014. 11. 28. 10:05
<insert id="multiInsert1" parameterClass="java.util.List">
INSERT INTO
TB_TEST(SEQ_NO,LOC_CD, LOC_NM)
select testseq.nextval, locCd, locNm from (
<iterate conjunction=" union all ">
select #[].locCd# locCd, #[].locNm# locNm from dual
</iterate>
)
</insert>

 

 

Posted by Thread