Multiple Where
OS: RHEL 6.10
DB: Oracle RAC 2 Nodes, 11.2.0.3.0
Question: I need to run following query, I can run it one at a time, but I would like to get one output.. Is there a way to do it ?
I tried this but it didn't work: select * from account where num_ref = 'abc634800' , 'abc729597','abc880331','abc037366','abc048227';
this works, one at a time: select * from account where num_ref = 'abc634800';
select * from account where num_ref ='abc729597';
select * from account where num_ref ='abc880331';
etc, etc.
I have tried Google but I could not find a solution. Thanks for your help.