What is the difference between Outer join and Full outer join?
- 5 Answers
- 39141 Views
- I also Faced
- E-Mail Answers
Answer Posted / sakshisree
Outer Join:
There are three types of outer joins namely:
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---For retreiving all the columns from both
the tables irrespective of column match.
| Is This Answer Correct ? | 38 Yes | 12 No |
Post New Answer View All Answers
Is oracle a programming language?
How data locks are respected in oracle?
How to create additional tablespaces for an new database?
Please explain joins in oracle?
How do you get nicely formatted results from an oracle procedure that returns a reference cursor?
What is the scope of a local variable?
Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?
What is the difference between PFILE and SPFILE in Oracle?
What is a view and how is it different from a table?
How to use group functions in the select clause using oracle?
What is the purpose of save points in oracle database?
How to use "while" statements in oracle?
What is the relationship among database, tablespace and data file?
how the indexes are stored in the Oracle Database?
What is tns name?
