Answer Posted / khaleek

There are three types of joins Equi Join and Non-Equi Join
and Cross Product.
Further Equi join can be divided into following categories...

1) Outer Join
2) Inner Join
3) Self Join

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


You can see the detail at..
http://interview-preparation-for-you.blogspot.com/2010/11/difference-between-inner-joinouter-join.html

What is recycle bin in Oracle?

1087

---

How to select some columns from a table in oracle?

1005

---

Is there a function to split a string in plsql?

983

---

Can we store images in oracle database?

948

---

what is reindexing?

1611

---

How to load data from external tables to regular tables?

989

---

Please explain drop constraint oracle?

1029

---

How to write a query with a right outer join in oracle?

1113

---

while i take backup using ibm tsm the following errors occurred: rman-03009 ora-19513 ora-27206 ora-19502 ora-27030 ora-ora19511

4295

---

What is the relationship among database, tablespace and data file?

929

---

What are the data types in oracle?

981

---

Can we save images in a database and if yes, how?

1002

---

Describe an oracle table?

989

---

What is data file?

1046

---

Which is better Oracle or MS SQL? Why?

4827

---