I am confused with oracle IN and EXISTS. I have below requirement. I need to get all the employees whose names are in- select * from emp where ename in('smith','brown','john','johnson'); Can i use