ibatis insert all


alter table table_name drop column column_name

<insert id="insep.insertkeepCont"  parameterClass="java.util.List">
<![CDATA[
INSERT ALL
]]>
<dynamic>
<iterate conjunction="  ">
<![CDATA[
INTO table_name
(KEEP_NO
, MGT_NO1
, MGT_NO2
, e_NO
, SEL_CHK_MM
)
VALUES
]]> (#[].keepNo#
,#[].mgtNo1#
,#[].mgtNo2#
,#[].eNo#
,#[].selChkMm#
)
</iterate>
<![CDATA[
SELECT * FROM DUAL
]]>
</dynamic>
</insert>

Popular posts from this blog

youtube download

com.gpki.secureweb.GPKISecureWEBException: ErrCode=1507,ErrMsg=[GPKI_CMS_ProcessEnvelopedData] 해당 인증서로는 데이터를 풀 수 없습니다.

rexpert 공식필드(javascript) 점검일 주기 계산