What is the difference between Outer join and Full outer join?
Answer Posted / a g srikanth
Amongh outer joins there are three types
1)Left outer join
2)Right outer join
3)Full outer join
Left outer join: In this join the (+) sign is given with
the table to the left of the equal to sign
i.e emp.deptid(+)=dept.deptid
here we are seeking blank columns from the left table i.e.
emp if no matching columns are there in the right table i.e
dept
Right outer join: In this join the (+) sign is given with
the table to the right of the equal to sign
i.e emp.deptid=dept.deptid (+)
here we are seeking blank columns from the right table i.e.
dept if no matching columns are there in the left table i.e
emp.
NOTE:scott.emp and dept values do not give any rows for
right outer joins, for right outer join, assume that there
is some employee in emp table who is not yet assigned any
department number.
Full outer join:in this type of join we force blanks if any
from both the tables
SELECT *
FROM emp
FULL OUTER JOIN dept
ON emp.Deptid = dept.Deptid
Is This Answer Correct ? | 5 Yes | 6 No |
Post New Answer View All Answers
What privilege is needed for a user to create tables in oracle?
Explain the blob datatype?
Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.
How do you increase the OS limitation for open files (LINUX and/or Solaris)?
What is an external table?
what is the difference between functional dependecy and multilevel dependency?
Explain the use of control file?
Differentiate between pre-select and pre-query?
Name the various constraints used in oracle?
What is Reduced List of Values?
How to define a procedure inside another procedure?
What is the maximum limit on the number of columns in a table?
A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.
How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?
What happens if you set the sga too low in oracle?