Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Outer join and Full outer join?
- 5 Answers
- 39958 Views
- I also Faced
- E-Mail Answers
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 is the difference between PFILE and SPFILE in Oracle?
What is the difference between a hot backup and a cold backup in oracle?
How to find out what oracle odbc drivers are installed?
How to create lov dynamically at runtime & attach to text field?
What is the difference between translate and replace in oracle?
How to create an oracle testing table?
Explain the use of inctype option in exp command.
How to count duplicated values in a column in oracle?
What are the most common interview questions on ETL Testing for experience?
How to compare dates in oracle sql?
HI Friends Myself Manoj,i am from bengaluru.i have 1 yr of exp in PLSQL but not upto the mark..now attending interviews but m not able to clear even 1 round..i have attended 3 interviews till today.purpose of writing this query is,i want to know the intreview topics that interviewer going to ask frequently,mainly SCENARIO based questions.IF anybody have any PLSQL projects please give it to me,it will helps me alot.Thanks for your patience.
How to manage transaction isolation level?
what are steps for interface? where is exchange rate defined in which table?
What is a nested table and how is it different from a normal table?
How to insert a new row into a table in oracle?
