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

  1. Categories >> Software >> Databases >> Oracle >> Oracle General
  2. Suggest New Category

What is a OUTER JOIN?

Question Posted / parthasarathi

Answer Posted / parthasarathi

outer join is used to fetch unmatched records along with matched records..

there are 3 kinds of outer joins available.

1.Left outer join :- used to fetch unmatched records at left side table.

2.right outer join :- used to fetch unmatched records at right side table.

3.Full outer join :- used to fetch unmatched records at both side tables.

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain view?

979

What is the usage of synonyms?

1062

Explain the importance of .pll extension in oracle?

956

How to import one table back from a dump file?

972

Explain oracle 12c new features for developers?

995

How to create a testing table in oracle?

948

Which is better Oracle or MS SQL? Why?

6267

How to use like conditions in oracle?

996

How to upsert (update or insert into a table)?

952

How do I uninstall oracle 11g?

1043

What are the arithmetic operations?

1026

What is the disadvantage of User defind function?

2239

How will you identify oracle database software release?

944

What is an oracle and why it is used?

1080

How to create a server parameter file?

1081