SQL Language (MOSC)

MOSC Banner

Multiple Where

edited Nov 7, 2019 11:11AM in SQL Language (MOSC) 7 commentsAnswered ✓

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center