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
- 19171 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
WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?
How to experiment a data lock in oracle?
Which is faster join or subquery in oracle?
Explain the function of optimizer in oracle?
how to join query for one source type is oracle another source type is sql server ?
Explain the use of control file?
How remove data files before opening a database?
What privilege is needed for a user to create indexes in oracle?
What are the uses of synonyms?
How to select all columns of all rows from a table in oracle?
How to check database size in Oracle?
How to update values in a table in oracle?
what is meant by magic query
What is BBED in Oracle?
what are actual and formal parameters?
