What is the difference between IN and Exists in Oracle?
Answer Posted / imran
The EXISTS clause is used to check the existence of rows returned by a subquery. It returns TRUE if the subquery returns one or more rows.
The IN clause is used to filter rows based on a list of values or a subquery result set. It checks if a value matches any value in a list or subquery.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is lookup change?
what is Active lock explain
Performance tuning in UNIX for informatica mappings?
How to implement security measures using repository manager?
What is blocking transformation?
What do you mean by enterprise data warehousing?
How we can create indexes after completing the loan process?
What are the components of workflow manager?
What is meant by pre and post session shell command?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
can anyone suggest best free Talend data integration training online
How can you define user defied event?
What is the difference between source qualifier transformations source filter to filter transformation?
What are the restrictions of union transformation?
Plz can any one say me how to get the informatica certification materials and dumps