Interested to Buy Any Domain ? << Click Here >> for more details...
What different of iner joint & outer joint with example
- 4 Answers
- 10032 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
What is ADDM Advisor in Oracle?
Give the various exception types.
How to drop a stored procedure in oracle?
How to create a new table in oracle?
What are the logical operations?
Explain the use of constraints option in exp command.
Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.
What is different types of joins?
how the indexes are stored in the Oracle Database?
How to empty your oracle recycle bin?
what is the use of system.effective.date variable in oracle?
Name the various constraints used in oracle?
query optmization techniques and quwry analyser+projects+ppts
Can we save images in a database and if yes, how?
How to insert multiple rows with one insert statement in oracle?
