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
How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.
How to create lov dynamically at runtime & attach to text field?
Explain the use of grant option in exp command.
Why do you use stored procedures and state some of its disadvantages?
What is an oracle?
How to loop through data rows in the implicit cursor?
what are bitmap indexes? How does they work?
How to drop a stored procedure in oracle?
How can I create database in oracle?
What do you mean by a database transaction & what all tcl statements are available in oracle?
How to speed up webrick?
Explain self joins in oracle?
What is object data modeling?
Can you drop an index associated with a unique or primary key constraint?
How many file formats are supported to export data?