Please explain the difference between outer join and inner
join? With examples would be appreciable..!
- 6 Answers
- 17216 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
Can you drop an index associated with a unique or primary key constraint?
How remove data files before opening a database?
How to start a new transaction in oracle?
How to convert characters to times in oracle?
Can select statements be used on views in oracle?
How to retrieve data from an explicit cursor?
How view is different from a table?
What is the data type of dual table?
IS it possible to built the oracle database without setting the kernal parameters?
How many memory layers are in the oracle shared pool?
Differentiate between pre-select and pre-query?
What is a parameter file in oracle?
List the various oracle database objects?
What is coalesce function?
What is an external table?
