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;

What to do if the startbd.bat failed to start the xe instance?

1129

---

How to set up autotrace for a user account?

1113

---

How to start a new transaction in oracle?

1137

---

How to count duplicated values in a column in oracle?

1107

---

Why is oracle used?

981

---

How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.

2265

---

State the difference between a primary key and foreign key?

998

---

what is difference between sql plus and sql*plus? (not sql and sql plus).

3943

---

What operating systems are supported by oracle database 10g xe?

1090

---

How do I start tns listener?

1099

---

What privilege is needed for a user to create indexes in oracle?

1085

---

What are the extensions used by oracle reports?

1090

---

Explain the features of oracle?

1109

---

what is Single Byte Overhead...?

2614

---

What are a collation and state the different types of collation sensitivity?

1244

---