Interested to Buy Any Domain ? << Click Here >> for more details...
What different of iner joint & outer joint with example
- 4 Answers
- 10028 Views
- I also Faced
- E-Mail Answers
Answer Posted / nusrath sultana
Inner join:fetch the data when matched,similar to equi join.
Outer join:fetch the data matched as well as some unmatched
data.
there are three types of outer join :
1)left outer join:it will fetch the data when matches in two
or more relation and the unmatched data from the left
relation is also selected.
SQL>SELECT E.ENAME,E1.COMM FROM EMP E LEFT OUTER JOIN EMP E1
ON E.EMPNO=E1.EMPNO;
2)right outer join:it will fetch the data when matches in
two or more relation and the unmatched data from the right
relation also selected.
SQL>SELECT E.ENAME,E1.COMM FROM EMP E RIGHT OUTER JOIN EMP
E1 ON E.EMPNO=E1.EMPNO;
3)full outer join:it will fetch the data when matches in two
or more relation and the unmatched data from the BOTH
relations are also selected.
SQL>SELECT E.ENAME,E1.COMM FROM EMP E FULL OUTER JOIN EMP E1
ON E.EMPNO=E1.EMPNO;
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
In what script is snap$ created? In what script is the scott/tiger schema created?
How to create a new table in oracle?
What is the max number of columns in an oracle table?
How to select an oracle system id (sid)?
How to sort the query output in oracle?
How does Oracle guarantee data integrity of data changes?
How do I reset a sequence in oracle?
How to shutdown your 10g xe server?
What is an oracle function?
If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...
Explain the use of online redo log files in oracle.
Explain the dml?
What is the difference between count (*), count (expression), count (distinct expression)?
Explain oracle data types with examples?
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 ?
