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 / ram

exists improves the performance because it returns boolian
value where as 'in' is not...so exists simplyfies internal
calculations....

Is This Answer Correct ?    9 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is mapping debugger?

1069


How can we handle two sessions in informatica?

1094


What is meant by a domain?

1189


Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?

1957


Explain the features of connected and unconnected lookup.

976


1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?

2173


What is joiner transformation in informatica?

1101


What is pmcmd command?

1182


Explain how many types of dimensions are available in informatica?

1173


What is the difference between stop and abort in informatica

1144


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

1172


Which transformation is needed while using the Cobol sources as source definitions?

1221


Explain the use of aggregator cache file?

1318


-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?

5880


What is the command used to run a batch?

1112