What different of iner joint & outer joint with example
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
How to create a table interactively?
How to count duplicated values in a column in oracle?
what is the difference between substr and instr function in oracle?
I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?
Explain the use of indexes option in imp command.
What is the recommended interval at which to run statspack snapshots, and why?
what are the default admin accounts in Oracle 10g ?
Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?
What are the oracle built-in data types?
What is a data lock in oracle?
Respected sir, Please send me technical questions related to oracle apps..
What is a trigger and what are its types?
while i take backup using ibm tsm the following errors occurred: rman-03009 ora-19513 ora-27206 ora-19502 ora-27030 ora-ora19511
What is logical backup in oracle?
Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ mak2786@gmail.com thanks Arun