What is the difference between Outer join and Full outer join?
- 5 Answers
- 39140 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
What is an oracle recycle bin?
How to start a new transaction in oracle?
What happens if the imported table already exists?
Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?
What is a data dictionary and how can it be created?
What is the difference between pre-select and pre-query?
Explain the difference between a procedure and a function? What do you understand by those terms?
What is the minimum client footprint required to connect c# to an oracle database?
How to create a testing table in oracle?
Is java required for oracle client?
What is oracle data type?
How can I create database in oracle?
Explain an index?
How to connect ms access to oracle servers?
What is connection pool in oracle?
