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

What does command task mean?

606


How we can create indexes after completing the loan process?

725


What are Dimensional table?

608


What are the reusable transformations?

694


What is target designer and target load order?

652






What is an expression transformation in informatica?

514


what are factless facts? And in which scenario will you use such kinds of fact tables.

1309


Why do we need informatica?

552


What is lookup change?

614


hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica

1640


How can we store previous session logs?

565


Explain what is informatica metadata and where is it stored?

604


What is the difference between a repository server and a powerhouse?

801


What is the scenario which compels informatica server to reject files?

599


What differs when we choose the sorted input for aggregator transformation?

567