What is the difference between Outer join and Full outer join?
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 happens to the current transaction if the session is killed?
What is oracle update statement with inner join ?
How many file formats are supported to export data?
How to assign data of the deleted row to variables?
Who developed oracle & when?
How to write date and time literals in oracle?
Can we write dml statement in function in oracle?
How to convert a string to a date in oracle database?
How to create a new tablespace in oracle?
How to export data with a field delimiter?
What is index-organized table in Oracle?
what is the use of triggers in Java program? I mean where do we use triggers in Java programming?
how to do daily transactions with out sql* loader control file regesterd in apps?
What are the components of logical database structure in oracle database?
What are data pump export and import modes?