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 EXISTS here? Also IN clause has 1000 limitation. Does EXISTS also has any such limitation?

Thanks!

sql oracle-database
Edit
Report