oracle in 超1000方案

T.PRICE_MAIN_ID IN
<foreach item="priceMainId" collection="ids" open="(" separator="union all"
close=")">
select #{priceMainId} from dual
</foreach>

 

 

(
select 1 from daul union all
select 2 from daul union all
select 3 from daul union all
..
select 4 from daul

)