Oracle--

1、查询一列等于多值

查询一列等于多值用 in 或者 or

--查询一列等于多值
select m.proposalNo from prpcmain m where m.policyno in ('301031623700660001114','301071623700660000913');
select * from prpcmain m where m.policyno='301031623700660001114' or m.policyno='301071623700660000913';