Interested to Buy Any Domain ? << Click Here >> for more details...
Please explain the difference between outer join and inner
join? With examples would be appreciable..!
- 6 Answers
- 19380 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / vamsi krishna
INNER JOIN DISPLAYS ONLY THE RECORDS WHICH ARE SATISFYING
THE JOINING CONDITION,WHERE AS IN AN OUTER JOIN IT DISPLAYS
THE RECORDS WHICH ARE SATISFYING THE CONDITION AND ALSO
WHICH ARE NOT SATIFYING THE CONDITION ALSO.
FOR EXAMPLE TAKE EMP AND DEPT TABLE.
INNER JOIN QUERY:
SELECT EMPNO,ENAME,SAL,DEPT.DEPTNO,DNAME,LOC FROM EMP INNER
JOIN DEPT ON(EMP.DEPTNO=DEPT.DEPTNO)
OUTER JOIN QUERY:
SELECT EMPNO,ENAME,SAL,DEPT.DEPTNO,DNAME,LOC FROM EMP RIGHT
OUTER JOIN DEPT ON(EMP.DEPTNO=DEPT.DEPTNO).
IN INNER JOIN IT DISPLAYS ONLY 10,20 & 30 DEPARTMENTS.
IN OUTER JOIN IT DISPLAYS 10,20,30 AND 40 DEPARTMENTS.
TAKE DEFAULT TABLES FOR EXECUTION
| Is This Answer Correct ? | 39 Yes | 4 No |
Post New Answer View All Answers
How to invoke the data pump import utility?
How to save query output to a local file?
What is oracle latest version?
How to define an oracle sub procedure?
what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?
Is primary key indexed by default in oracle?
how to clone 9i Database on to 10g Database.
What is a initialization parameter file in oracle?
State and explain the different types of data models?
types of indexes and the rationale behind choosing a particular index for a situation.
What are joins, explain all types of joins?
How many categories of data types?
How to retrieve values from data fields in record variables?
Explain about functional dependency and its relation with table design?
What are the different types of record groups in oracle? Explain each of them
