Answer / khaleek

There are only three type of joins
1) Equi Join
2) Non Equi Join
3) Cartesian Product or Cross Join.

Further Equi Join and Non Equi join can be divided into
following categories.
1) Inner Join
2) Outer Join
3) Self Join

Again Outer can be divide into following categories.
1) Left Outer Join
2) Right Outer Join
3) Full Outer Join

For detail please see at
<a
href="http://interview-preparation-for-you.blogspot.com/2010/11/difference-between-inner-joinouter-join.html">http://interview-preparation-for-you.blogspot.com/2010/11/difference-between-inner-joinouter-join.html</a>

What are the benefits of pl sql?

0 Answers  

---

Is there any restriction on the use of union in embedded sql?

0 Answers  

---

there are .......different types of serializability

1 Answers   Wipro,

---

Store procedure will return a value?

4 Answers   eMids,

---

Can a primary key be a foreign key?

0 Answers  

---

What are stored procedures used for?

0 Answers  

---

What is difference between mysql and postgresql?

0 Answers  

---

How does postgresql compare to oracle/db2/ms sql server/informix?

0 Answers  

---

How do I turn a list into a table?

0 Answers  

---

what is transaction? : Sql dba

0 Answers  

---

what's the difference between a primary key and a unique key? : Sql dba

0 Answers  

---

Can you skip header records while loading? : aql loader

0 Answers  

---