ORACLE IN 查询时出现ORA-01795:列表中的最大表达式数为1000解决方法

   <update id="updateSuddenIcd">
        update SCREEN_SUDDEN_ICD set SUDDEN_SCREEN_CHOICE ='1'
        <where>
            CODE in
            <if test="configValue!=null and configValue!=''">
                <foreach collection="configValue.split(',')" open="(" close=")" index="index" item="item" separator=",">
                    <if test="(index % 999) == 998"> NULL ) OR CODE IN (</if>#{item}
                </foreach>
            </if>
        </where>
    </update>