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
What is domain and gateway node?
Explain Dataware house architecture .how data flow from intial to end?
Explain lookup transformation source types in informatica
What is the meaning of decode in informatica?
Please let me know how to make Data masking in informatica..
How can you validate all mappings in the repository simultaneously?
Informatica settings are available in which file?
What is rank transformation in informatica
Explain in detail about scd type 1 through mapping.
What is the sequence generator transformation in informatica?
explain about unit testing? in real time?
What are the types of schemas we have in data warehouse and what are the difference between them?
What is the difference between a connected look up and unconnected lookup?
What are junk dimensions?
I have a flat file, want to reverse the contents of the flat file