Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Outer join and Full outer join?
- 5 Answers
- 40184 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 to sort output in descending order in oracle?
What happens if the imported table already exists?
What are oracle functions?
How to test null values?
What is sharded cluster?
i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?
Explain implicit cursor.
Explain oracle left join with an example?
What is oracle server autotrace in oracle?
What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.
What is the difference between a hot backup and a cold backup in oracle?
List the various oracle database objects?
how the indexes are stored in the Oracle Database?
What is rowid and rownum in oracle?
What is integrity and what is constraint??Explain with example
