Mybatis查询Oracle序列关闭缓存

    <select id="select" parameterType="integer" resultType="java.lang.Integer" fetchSize = "2000" flushCache="true" useCache="false">
        select LZ_HGVA_MID_SEQ.NEXTVAL FROM (select 1 from LZ_HGVA_MID_IDS where id <![CDATA[ <= ]]>  #{dataValueSize})
    </select>

• 关闭缓存 ：flushCache="true" useCache="false"
• 返回大小：fetchSize = "2000"
• 查询序列：LZ_HGVA_MID_SEQ.NEXTVAL（LZ_HGVA_MID_SEQ为序列名）
• 只存单列id的表：LZ_HGVA_MID_IDS