Oracle in 的个数超过1000
Oracle中在一个查询语句里 in 的个数最多为1000个
当我们in的个数有1000+时,可以考虑使用union all来查询
把in的个数以一次999个来查询用union all来连接起来,然后就可以了
select DJXH,NSRMC,nsrsbh,JK_BZ,ZT_DM from
(
select DJXH,NSRMC,nsrsbh,JK_BZ,ZT_DM from sxgl_fxts where jk_bz='Y' AND ZT_DM=83 and djxh in
(.......................)
union all
select DJXH,NSRMC,nsrsbh,JK_BZ,ZT_DM from sxgl_fxts where jk_bz='Y' AND ZT_DM=83 and djxh in
(.......................)
union all
select DJXH,NSRMC,nsrsbh,JK_BZ,ZT_DM from sxgl_fxts where jk_bz='Y' AND ZT_DM=83 and djxh in
(.......................)
union all
select DJXH,NSRMC,nsrsbh,JK_BZ,ZT_DM from sxgl_fxts where jk_bz='Y' AND ZT_DM=83 and djxh in
(.......................)
)