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 aggregator transformation in informatica?
How to load data in informatica ?
Enlist the differences between database and data warehouse.
Explain the use of aggregator cache file?
What are the guidelines to be followed while using union transformation?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
What is the function of union transformation?
What is a joiner transformation and why it is an active one?
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
expain about the tune parameters?
What do you mean by blocking transformation?
What is a code page?
Differences between connected and unconnected lookup?
What is a difference between complete, stop and abort?
4 yrs etl devloper roles and responsibilities?any body give solutions