KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
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!
Tags (comma-separated)
Save Edits
Cancel