Interested to Buy Any Domain ? << Click Here >> for more details...
What different of iner joint & outer joint with example
- 4 Answers
- 10224 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 display row numbers with the records?
How can we force the database to use the user specified rollback segment?
Please explain oracle left join with an example?
What is a table index in oracle?
Is a rollback possible to any savepoint?
How to define a data source name (dsn) in odbc manager?
How many anonymous blocks can be defined?
What is oracle and what are its different editions?
How to Truncate Table in Oracle
List the types of joins used in writing subqueries?
Whats the benefit of dbms_stats over analyze?
What is the string concatenation operator in oracle?
WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?
What is archive log in Oracle?
What is system tablespace?
