What is the exact difference b/w IN and EXIST in Oracle..?
Answer Posted / sujeetha
It is almost similar to IN but the difference is that in
EXIST it will retrive the row atleast one row in the inner
query satisfies but in IN we can have manuy values
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
In warehouses how many schemas are there?
How can we create index after completion of load process?
if we have a delimiters at unwanted places in a flat file how can we over come those.
Clarify the aggregator change?
Which version configuration tool used in ur project?
Explain direct and indirect flat file loading (source file type) - informatica
How to generate or load values in to the target table based on a column value using informatica etl tool.
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
What all join we can perform in LOOKUP transformation?
What are the guidelines to be followed while using union transformation?
What is domain and gateway node?
What is a repository manager?
server hot-ws270 is connect to Repository B. What does it mean?
How can we improve session performance in aggregator transformation?
As union transformation gives UNION ALL output, how you will get the UNION output?