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 >> SQL PLSQL
  2. Suggest New Category

Give an example of Full Outer Join?

Question Posted / parli jain


Give an example of Full Outer Join? ..

Answer / senthil kumar

6. full outer join : ALL UNMATCHED DATA FROM BOTH TABLES

SELECT * FROM TABLE A FULL OUTER JOIN TABLE B ON (A.ID= B.ID)
Ex:

TABLE A
NO NAME 1 X
2 Y
5 Z

TABLE B
NO NAME 1 XX
2 YY
3 ZZ
4 AA

OUTPUT:
NO NAME NO NAME
1 X 1 XX
2 Y 2 YY
3 ZZ
4 AA
5 Z

Is This Answer Correct ?    3 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

what is bdb (berkeleydb)? : Sql dba

0 Answers  

How to convert comma separated string to array in pl/sql?

0 Answers  

Are null values same as that of zero or a blank space?

0 Answers  

How to return more than one value from a function?

11 Answers   Satyam,

Can I learn sql in a week?

0 Answers  

What is an invalid partition table?

0 Answers  

Is pl sql useful?

0 Answers  

What are the differences between implicit and explicit cursors?

0 Answers  

What is an oracle stored procedure?

0 Answers  

what are the different types of joins?

4 Answers   Choice Solutions,

Is vs as in pl sql?

0 Answers  

What will you get by the cursor attribute sql%found?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories