with t as(
select '身份证1' as sfz from dual union
select '身份证2' as sfz from dual union
select '身份证2' as sfz from dual
)
SELECT DGV.*
FROM datagridview DGV
WHERE EXISTS(
SELECT 1 FROM T
WHERE T.SFZ = DGV.SFZ
)以上.
WITH T 构造的结果集,可以动态扩展例如:
select '身份证1' as sfz from dual union
select '身份证2' from dual union
select '身份证3' from dual union
select '身份证4' from dual union
select '身份证5' from dual union
select '身份证6' from dual
select '身份证1' as sfz from dual union
select '身份证2' as sfz from dual union
select '身份证2' as sfz from dual
)
SELECT DGV.*
FROM datagridview DGV
WHERE EXISTS(
SELECT 1 FROM T
WHERE T.SFZ = DGV.SFZ
)以上.
WITH T 构造的结果集,可以动态扩展例如:
select '身份证1' as sfz from dual union
select '身份证2' from dual union
select '身份证3' from dual union
select '身份证4' from dual union
select '身份证5' from dual union
select '身份证6' from dual
在oracle数据库怎么处理都快,怕是你程序写得不对吧?
数据表装身份证记录,加上索引,用表之间的关联或exists,十万多条数据应该效率不会太差。。