What is the difference between Outer join and Full outer join?
- 5 Answers
- 39139 Views
- I also Faced
- E-Mail Answers
Answer Posted / syam kumar m
Left Outer Join---For retreiving all the columns from the
first table irrespective of the column match.
Right Outer Join---For retreiving all the columns from the
second table irrespective of the column match
Full Outer Join---it retrieves the matched data from the
two tables and affter shows remaining rows in the result
set like below example.
col_one col_two col_one col_two
---------------- ---------------------
1 a 2 B
2 b 3 C
3 c 4 D
full outer join
---------------
col_one col_two col_one col_two
2 b 2 B
3 c 3 C
- - 4 D
1 a - -
| Is This Answer Correct ? | 5 Yes | 4 No |
Post New Answer View All Answers
How to rollback the current transaction in oracle?
How to use like conditions in oracle?
What is the difference between alert log file and tarce file ?
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
What are the restrictions on external table columns?
How to use select statement to count the number of rows in oracle?
Explain a segment?
How to drop a tablespace?
Explain what are the type of synonyms?
In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?
Explain the use of consistent option in exp command.
What are the execution control statements?
What is oracle rowcount?
Explain a synonym?
Please explain drop constraint oracle?
