Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

Differentiate between reusable transformation and mapplet.

1028


State the differences between sql override and lookup override?

1112


What are some examples of informatica etl programs?

887


Define joiner transformation?

986


I have a flat file, want to reverse the contents of the flat file

1065


How to delete duplicate row using informatica?

982


How might you approve all mappings in the archive all the while?

956


What can we do to improve the performance of informatica aggregator transformation?

1041


explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?

2098


What are the types of presistent cache in look up tr.

2005


What are session parameters ? How do you set them?

1773


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

1099


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

1007


Have you worked with/created Parameter file

1611


Can we create two repositories on same database instance in oracle?

1014