What is the exact difference b/w IN and EXIST in Oracle..?

Answer Posted / venkateshmalneni

EXIST is used as conditional operator in which u can write a query
IN is also used as a conditional operator in which we gives a list of elements

Is This Answer Correct ?    4 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to open an older version of an object in the workspace?

628


can we override a native sql query within informatica? Where do we do it?

636


How to create or import flat file definition in to the warehouse designer?

624


What are the types of data warehouses?

956


What are the issues you have faced in your project? How did you overcome those issues?

1925






Do you find any difficulty while working with flat files as source and target?

684


What is a passive transformation?

650


Mention few power centre client applications with their basic purpose?

546


Could you explain what is enterprise data warehouse?

567


Design time, run time. If you don't create parameter what will happen

1435


what is the size ur source like(file system or database)? how many record daily come u r banking project?

1755


What is deployment group?

694


Is there any way to read the ms excel datas directly into informatica?

558


What is the need for an etl tool?

647


Define joiner transformation?

604