<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