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 difference between IN and Exists in Oracle?

Answer Posted / sri

when the condition is in a subquery then in will be used
where if there is a condition in superquery
(parent) exists will be used. Usage of IN will improve the
performance

Is This Answer Correct ?    0 Yes 10 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is index?how it can work in informatica

2084


What are ETL Tools?

1175


What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks

5794


What is the need of etl tools?

1182


What is the difference between informatics 7x and 8x and what is latest version?

1138


What is rank transformation in informatica

1233


If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me

2059


can anyone explain me about retail domain project in informatica?

8002


How do you handle two sessions in Informatica

1219


Explain the aggregator transformation?

1223


In what scenario we use to improve session performance by pushdown optimization?can any one give example?

6282


What is decode in static cache?

1264


How can we remove the duplicates from flat file source?

1075


What is target load order?

1302


What is repository manager?

1028