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...

Please explain the difference between outer join and inner
join? With examples would be appreciable..!

Answer Posted / ashish sajwan

In Inner join the result is show only the matching columns which are common in both tables,In outer join the results show matched and unmatched columns from both tables

Is This Answer Correct ?    3 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to open a cursor variable?

973


What is transaction control statement and how many types of transaction control statement in Oracle?

1077


What are the differences between primary key and unique key?

947


What are the varoius components of physical database structure of oracle database?

945


What are advantages of dateset in datastage?

2198


How to login to the server without an instance?

1103


what is dynamic SGA and static SGA

4327


What is system global area (sga) in oracle?

927


Is truncate autocommit in oracle?

1020


What is a dynamic performance view in oracle?

948


Hi Can any one tell me what are the API's used in requisition import.

1879


What is where clause in oracle?

980


How to use "in out" parameter properly?

998


Explain oracle’s system global area (sga).

1074


How to add a new column to an existing table in oracle?

1069