Please explain the difference between outer join and inner
join? With examples would be appreciable..!
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
How to load data through external tables?
you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz
How to create id with auto_increment on oracle?
What is oracle sid?
What is connection pool in oracle?
What are the limitations of check constraint?
how to clone 9i Database on to 10g Database.
What is the difference between 10g OEM and 11g OEM?
Explain drop constraint oracle?
How to create a table index in oracle?
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
How view is different from a table?
What is tns name?
Explain overloading. Can functions be overloaded?
What are the ways tablespaces can be managed and how do they differ?