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
Can we create two repositories on same database instance in oracle?
Could you explain what is enterprise data warehouse?
Is there any target staging area in informatica not staging area
How do we call shell scripts from informatica?
What is a repository? And how to add it in an informatica client?
What are the new features of informatica 9.x at the developer level?
Can we change Dynamic to Static or Persistent cache? If so what happens?
Implementation methodology
How can one identify whether mapping is correct or not without connecting session?
Explain the code page compatibility?
What are active transformations.
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
How to go to the older version for a mapping?
what is unit testing?tell me proceedure
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?