Interested to Buy Any Domain ? << Click Here >> for more details...
What different of iner joint & outer joint with example
- 4 Answers
- 10044 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
State some uses of redo log files?
Can we save images in a database and if yes, how?
Does oracle partitioning improve performance?
What is the oracle implicit cursor?
Can you tell me how to add new column in existing views?how?How is possible?
22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100
what is the scripts in data base?
How to calculate date and time differences in oracle?
How can we create the complete backup of data in the oracle.
Does oracle database need java?
Hi Masters, in Oracle Applications 11i, we hace 2 functions using the same form, i need to create 1 personalization, but that code must afect only one function.... how can i do that?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
What are the execution control statements?
I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database
What is archive log in Oracle?
