Interested to Buy Any Domain ? << Click Here >> for more details...
What different of iner joint & outer joint with example
- 4 Answers
- 9974 Views
- I also Faced
- E-Mail Answers
Answer Posted / joel
inner join will select the record that are match only. it is
just like equi join. but outer join select the record not
only the equal one but also select the not equal one.
outer join is of three type namely
right outer,
left outer and
full outer.
1) right outer join will be like below in the join condition
e.deptno(+)=d.deptno.
that is it select all the uncommon values including common
values from the table e.
2)while left outer join will be like below in the join condition
e.deptno=d.deptno(+);
it will select uncommon values including common values
from table d.
3) full outer join is as like inner join. it will select
common values only
| Is This Answer Correct ? | 14 Yes | 6 No |
Post New Answer View All Answers
What is a named program unit?
how to make an oracle object
What are the varoius components of physical database structure of oracle database?
What are data pump export and import modes?
Explain the dml?
What is an oracle?
What is a trigger and what are its types?
What is a table index in oracle?
what is the difference between functional dependecy and multilevel dependency?
Explain the use of tables option in exp command.
what happened to the global index when I truncate the data in one of the partition?
How to call a stored function with parameters?
How many types of tables are there in oracle?
Which is better Oracle or MS SQL? Why?
How many anonymous blocks can be defined?
