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 might one distinguish in the case of mapping is right or not without associating session?

733


Target increases every day even though no new record was inserted

1221


what is mean by complex business rule ?

1800


TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com

1555


Define mapping and session?

676






How do you load only null records into target? Explain through mapping flow.

1629


What is joiner transformation?

660


How to use pmcmd utility command?

684


How does a sorter cache works?

668


Sequence generator, when you move from develoment to production how will you reset

1527


How do you manage the Parameter files while migrating your data from one environment to another environment?

653


What are mapplets?

909


How can we use mapping variables in informatica? Where do we use them?

731


Explain lookup transformation in informatica

736


What are mapplets? How is it different from a Reusable Transformation?

728