Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Outer join and Full outer join?
- 5 Answers
- 40204 Views
- I also Faced
- E-Mail Answers
Answer Posted / bukko
A join is between 2 tables (or views), for example:
TABLE1 <==> TABLE2
A LEFT OUTER JOIN returns all rows from the LEFT table (TABLE1 in the example) and only the rows from the RIGHT table (TABLE2) where the columns in the join clause match.
A RIGHT OUTER JOIN is, unsurprisingly, the same but reveresed, i.e. all rows from TABLE2 plus the rows from TABLE1 where the columns in the join clause match.
A FULL OUTER JOIN is both; it returns all rows which would result if it were a LEFT OUTER JOIN plus all the rows which would result if it were a RIGHT OUTER JOIN.
| Is This Answer Correct ? | 9 Yes | 4 No |
Post New Answer View All Answers
Explain what does a control file contain?
What is the usage of analyze command in oracle?
What is the difference between a hot backup and a cold backup in oracle?
How does Oracle guarantee data integrity of data changes?
How would you best determine why your MVIEW couldnt FAST REFRESH?
How to start a specific oracle instance?
What is oracle thin client?
What are the roles of dba?
What is a sub query and what are the different types of subqueries?
How to insert multiple rows with one insert statement in oracle?
Explain about integrity constraint?
What is a cursor variable?
What is a static data dictionary in oracle?
What is the data type of dual table?
What is a system tablespace and when it is created?
