Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Outer join and Full outer join?
- 5 Answers
- 40346 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
How do you store pictures in a database?
What is parameterized cursor in oracle?
How to resolve name conflicts between variables and columns?
How to get a list of all background sessions in the database?
What does sharding mean?
What is the difference between view and materialized view in Oracle?
Hi Can any one tell me what are the API's used in requisition import.
Explain the blob datatype?
How to delete a column in an existing table in oracle?
What are the four Oracle system processes that must always be up and running for the database to be useable?
How to name query output columns in oracle?
How to establish administrator authentication to the server?
Where is the export dump file located?
What is bulk copy or bcp in oracle?
Explain the difference between sap and oracle?
