Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Outer join and Full outer join?
- 5 Answers
- 40124 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
Can select statements be used on views in oracle?
What is a relational database management system?
Explain drop constraint oracle?
What is memory advisor in Oracle?
What are the different types of record groups in oracle? Explain each of them
What is a private synonym?
What is truncate oracle?
how may join possible between (requisition with purchase order)
Can we store images in oracle database?
what is port in oracle? how is it related to database application.
How to turn on or off recycle bin for the session?
 How to use an oracle sequence generator in a mapping?
What operating systems are supported by oracle database 10g xe?
How to write a query with a right outer join in oracle?
How to see free space of each tablespace?
