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;

How to increment dates by 1 in oracle?

990

---

How to export your connection information to a file?

1073

---

What is the relation of a user account and a schema?

1062

---

how the indexes are stored in the Oracle Database?

2213

---

What is the difference between translate and replace?

1011

---

What is a system tablespace and when it is created?

918

---

How to shutdown your 10g xe server from command line?

1014

---

State any two functions of oracle?

981

---

What do you mean by merge in oracle and how can we merge two tables?

1001

---

What is an oracle wallet?

880

---

What do you mean by group by clause?

977

---

How to create an oracle database manually?

1018

---

What is procedure overloading in oracle?

992

---

Explain about your project and its relation to the current job position you are applying to?

943

---

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

1936

---