Oracle SQL Question:

Download Job Interview Questions and Answers PDF

Explain Which is more faster - IN or EXISTS?

SQL Oracle Interview Question
SQL Oracle Interview Question

Answer:

EXISTS is faster than IN
Because exists returns Boolean value whereas IN returns only value.

Download SQL Oracle Interview Questions And Answers PDF

Previous QuestionNext 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?