기록용

$.datepicker.formatDate('dd M yy', new Date())

날짜 변환형식 .

AND EMAIL_ID in

            <trim suffixOverrides=" OR EMAIL_ID IN ()">
                <foreach item="item" index="index" collection="mailList"
                         open="(" close=")">
                    <if test="index != 0">
                        <choose>
                            <when test="index % 1000 == 999">) OR EMAIL_ID IN (</when>
                            <otherwise>,</otherwise>
                        </choose>
                    </if>
                    #{item}
                </foreach>
            </trim>
        </when>
    </choose>

오라클 1000개이상일 때 해결책