Interested to Buy Any Domain ? << Click Here >> for more details...
What different of iner joint & outer joint with example
- 4 Answers
- 9817 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
Can we connect to ORACLE db using Windows Authentication?
Give the various rollback segment states.
Does oracle partitioning improve performance?
What is SQL access advisor in Oracle?
For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?
What is the difference between hot backup and cold backup in oracle?
What is a cursor variable?
Where is the export dump file located?
What is set verify off in oracle?
What is ceil and floor in oracle?
How to add a new column to an existing table in oracle?
Why oracle is used?
Explain an index segment?
Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ mak2786@gmail.com thanks Arun
What do you mean by a tablespace?
