What different of iner joint & outer joint with example
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
What is set verify off in oracle?
What is the use of oracle?
How to revoke create session privilege from a user in oracle?
Is there a combination of "like" and "in" in sql?
State and explain the different types of data models?
When do you get a .pll extension in oracle?
Oracle
What is the scope of a local variable?
How to write an inner join with the where clause in oracle?
What are the different types of partitions in oracle?
What is ADDM Advisor in Oracle?
What happens to the current transaction if a ddl statement is executed?
How to connect asp pages to oracle servers?
What are the tools for Oracle ?
What is ordinary table in oracle?