oracle 可以多個字段同時in 可以減少查詢的次數(shù)
select * from tablewhere (patient_id,visit_id) in (select '80870719','1' from dual)