Please explain the difference between outer join and inner
join? With examples would be appreciable..!
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
How to select all columns of all rows from a table in oracle?
Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com
Can multiple columns be used in group by in oracle?
Explain user account with reference to oracle.
What happens to indexes if you drop a table?
What are the various constraints used in oracle?
Is oracle a programming language?
How to insert a new row into a table in oracle?
What are the differences between interval year to month and interval day to second?
What is oracle analytical function?
What are the data types in oracle?
What are the tools for Oracle ?
Is rowid unique in oracle?
What is an oracle table?
What is transaction control statement and how many types of transaction control statement in Oracle?