Interested to Buy Any Domain ? << Click Here >> for more details...
What different of iner joint & outer joint with example
- 4 Answers
- 9813 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 an external table?
Explain the use of show option in imp command.
How to use select statement to count the number of rows in oracle?
Explain the use of owner option in exp command.
What is partitioned table in Oracle?
What is index-organized table in Oracle?
Where are the settings stored for each instance in oracle?
Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?
How to start your 10g xe server from command line?
What is system tablespace?
How to drop a tablespace?
What is the quickest way to export a table to a flat file?
How to define a sub function?
Can we store images in oracle database?
How will you write a query to get a 5th rank student from a table student_report?
