Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between IN and Exists in Oracle?
- 4 Answers
- 18304 Views
- Deloitte, I also Faced
- E-Mail Answers
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 target designer and target load order?
Differentiate between joiner and lookup transformation?
What are the different versions of informatica?
Describe an informatica powercenter?
How can you validate all mappings in the repository simultaneously?
Which are the different editions of informatica powercenter that are available?
What is option by which we can run all the sessions in a batch simultaneously?
How identifying bottlenecks in various components of informatica and resolving them?
Differentiate between sessions and batches?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
What is the function of union transformation?
what is index?how it can work in informatica
wat are deployement groups in informatica, how it will be used for developers
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
What is Cognos script editor?
