Please explain the difference between outer join and inner
join? With examples would be appreciable..!
- 6 Answers
- 17212 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
How to count duplicated values in a column in oracle?
you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz
How to call a stored function with parameters?
What is logical backup in oracle?
In oracle there is column command, how will you explain that?
What is the difference between PFILE and SPFILE in Oracle?
If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?
What are internal user account in oracle?
How oracle handles dead locks?
What are the different oracle database objects?
What is oracle instant client?
Explain the use of show option in imp command.
Is there an oracle sql query that aggregates multiple rows into one row?
How index is implemented in oracle database?
What is parameterized cursor in oracle?
