What is the difference between IN and Exists in Oracle?
Answer Posted / sri
when the condition is in a subquery then in will be used
where if there is a condition in superquery
(parent) exists will be used. Usage of IN will improve the
performance
| Is This Answer Correct ? | 0 Yes | 10 No |
Post New Answer View All Answers
How to implement security measures using repository manager?
What if the source is a flat-file?
where to store informatica rejected data?
What do you mean by enterprise data warehousing?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
without table how to come first record only in oracle?
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
What are the static cache and dynamic cache in informatica?
What is the scenario which compels informatica server to reject files?
What is the difference between Active and Passive transformation?
differences between service based and product based?
What are the advantages of using informatica as an etl tool over teradata?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
what are the deliverables?in your project?
What is domain in terms of informatica?