Oracle SQL Question:
Explain Which is more faster - IN or EXISTS?
Answer:
EXISTS is faster than IN
Because exists returns Boolean value whereas IN returns only value.
Because exists returns Boolean value whereas IN returns only value.
| Previous Question | Next Question |
| Explain What is an UTL_FILE.What are different procedures and functions associated with it? | How to find out nth highest salary from emp table? |