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
- 18873 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / sunny
Inner join means it display all matching records in both tables depends upon condition....
Outer joins are three types..
1.left outer
2.right outer
3.full outer
In left outer:it will display all columns of right side table and matching columns of both tables.
In right outer:it will display all columns of left side table and matching columns of both tables.
In full outer:all matching non matching columns of both tables are displayed.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is memory advisor in Oracle?
What is meant by recursive hints in oracle?
Explain an index?
HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE
What is program global area (pga) in oracle?
What are the differences between primary key and unique key?
What are the different editions of oracle?
What is a read write transaction in oracle?
What's dateware house and what's clustor with practicle example
How to create a stored function in oracle?
Why do we need oracle client?
How to create a stored procedure in oracle?
What are the advantages of oracle 12c?
What is open database communication (odbc) in oracle?
What do you mean by a tablespace?
