Interested to Buy Any Domain ? << Click Here >> for more details...
Please explain the difference between outer join and inner
join? With examples would be appreciable..!
- 6 Answers
- 19127 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / mahima
Inner join: displays only matching record from 2 tables
Outer join:
Left outer join display all the records from 1st table even
if dont have matching record in 2nd table
rignt outer join display all the record from the 2nd table
even if there is not matching record in 1st table
| Is This Answer Correct ? | 40 Yes | 2 No |
Post New Answer View All Answers
Explain enable novalidate constraint.
How many types of auditing in Oracle?
What is the difference between online and offline backups?
How to empty your oracle recycle bin?
How to define and use table alias names in oracle?
How do I use unicode codesets with the weblogic jdriver for oracle driver?
How to create a single index for multiple columns?
How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?
What is a cognitive schema?
How do I start tns listener?
 What are the oracle DML commands possible through an update strategy?
How do I reset a sequence in oracle?
What is a trigger and what are its types?
How to use like conditions in oracle?
What are the execution control statements?
