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
- 19180 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
If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?
How to unlock the sample user account in oracle?
How to generate query output in html format?
Briefly explain what is literal? Give an example where it can be used?
How to best split csv strings in oracle 9i?
normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi
What is rich query?
What is the usage of save points in oracle database?
How to experiment a data lock in oracle?
Explain the difference between replace() and translate() functions in oracle?
What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?
How to call a stored function with parameters?
What is flashback in Oracle?
How do you tell what your machine name is and what is its IP address?
How to use null as conditions in oracle?
