Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between IN and Exists in Oracle?
- 4 Answers
- 18039 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
How do you migrate data from one environment to another?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
How can we use batches?
What are the issues you have faced in your project? How did you overcome those issues?
What differs when we choose the sorted input for aggregator transformation?
What is sorter transformation?
r u done any partitions in ur project?
What are the types of caches in lookup? Explain them.
Is it possible to create multiple domains on a single Informatica server?
What is a sequence generator transformation?
Differentiate between a database and data warehouse?
How to extract sap data using informatica? What is abap? What are idocs?
Separate from an archive server and a powerhouse?
What are the popular informatica products?
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
