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

The EXISTS clause is used to check the existence of rows returned by a subquery. It returns TRUE if the subquery returns one or more rows.

The IN clause is used to filter rows based on a list of values or a subquery result set. It checks if a value matches any value in a list or subquery.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

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

1145


Could you explain what is enterprise data warehouse?

1226


Is there any target staging area in informatica not staging area

2631


How do we call shell scripts from informatica?

1191


What is a repository? And how to add it in an informatica client?

1195


What are the new features of informatica 9.x at the developer level?

1106


Can we change Dynamic to Static or Persistent cache? If so what happens?

2256


Implementation methodology

1773


How can one identify whether mapping is correct or not without connecting session?

1498


Explain the code page compatibility?

1122


What are active transformations.

1704


what are the best practices to extract data from flat file source which are bigger than 100 mb memory?

2417


How to go to the older version for a mapping?

1159


what is unit testing?tell me proceedure

2276


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

1957