Please explain the difference between outer join and inner
join? With examples would be appreciable..!
- 6 Answers
- 17214 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / khalek
In Inner Join Only Matching Records come while in Outer Join
All Matching Records + All Non Matching Record(Based on
Outer Join type).
Outer join may be any type from following.
1) Left Outer Join
2) Right Outer Join
3) Full Outer Join
You can see full detail at
<a
href="http://interview-preparation-for-you.blogspot.com/2010/11/difference-between-inner-joinouter-join.html">http://interview-preparation-for-you.blogspot.com/2010/11/difference-between-inner-joinouter-join.html</a>
| Is This Answer Correct ? | 4 Yes | 3 No |
Post New Answer View All Answers
What is sharded cluster?
How do I reset a sequence in oracle?
How many types of tables are there in oracle?
Where are the settings stored for each instance in oracle?
What is oracle analytical function?
How to insert a new row into a table in oracle?
What is data block in Oracle?
Give the constructs of a package, function or a procedure.
What is primefaces used for?
How to connect to a remote server?
Is it possible to set second Primary Key Constraint in a table in Oracle Database ?
How to invoke the data pump import utility?
Explain integrity constraints?
What is the difference between PFILE and SPFILE in Oracle?
In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col
