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
- 18871 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
Is rowid unique in oracle?
15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.
Does oracle database need java?
What is where clause in oracle?
Can select statements be used on views in oracle?
What is using clause and give example?
What are the different windows events activated at runtime ?
What is the difference between sharding and partitioning?
Explain coalesce function?
why should i declare foreign key constraint as self relation instead of binary relation in tables ?
How can we delete duplicate rows in a table?
What is meant by joins?
What is the usage of merge statement?
What is oracle database 10g express edition?
What is oracle analytical function?
