Interested to Buy Any Domain ? << Click Here >> for more details...
What different of iner joint & outer joint with example
- 4 Answers
- 10053 Views
- I also Faced
- E-Mail Answers
Answer Posted / tripti gour
INNER JOIN: inner join fetch only matched data from 2 or
more tables.
ex: select empno, ename, e1.deptno, d1.deptno, dname
from emp e1, dept d1
where e1.deptno = d1.deptno;
output will the all records whose deptno is exists in both
table (emp and dept)
OUTER JOIN: is used to fetched matched and unmatched data
from 2 or more tables.there are 3 type of outer join:
Right outer join , Left outer join, Full outer join.
Right outer join will display the matched and unmatched
records of right side located table.and Left outer join does
just opposite of it.and Full outer join will display matched
and unmatched both type of records from both tables.
ex: select empno, ename, e1.deptno, d1.deptno, dname
from emp e1 right outer join dept d1
on e1.deptno =d1.deptno;
| Is This Answer Correct ? | 2 Yes | 4 No |
Post New Answer View All Answers
How to convert a string to a date in oracle database?
How to check the server version in oracle?
What is integrity and what is constraint??Explain with example
How do I limit the number of rows returned by an oracle query after ordering?
What are the different pseudo commands? Explain in general?
How will you identify oracle database software release?
What is a connect identifier?
How can I introduce multiple conditions in like operator?
What is a tns file?
How to use subqueries with the exists operator in oracle?
How can we find out the duplicate values in an oracle table?
How to use "if" statements on multiple conditions?
How to create a new view in oracle?
What is transaction control statement and how many types of transaction control statement in Oracle?
What is procedure overloading in oracle?
