Answer Posted / samir kumar sahoo

Generally there are five types of joins in oracle:

Self Join
Equi Join
Cartesian Join
Outer Join(Left outer join,Right outer join)
Non_Equi JOin

What is Reduced List of Values?

2147

---

How to define a cusotmer as a supplier in ORACLE R12

2209

---

What is the difference between postgresql and oracle?

1020

---

Is java required for oracle client?

971

---

What is a trace file and how is it created in oracle?

1024

---

What is a procedure in oracle?

1150

---

What are the common oracle dba tasks?

1122

---

How to load excel data sheet to oracle database

1002

---

How can we find out the duplicate values in an oracle table?

1032

---

Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.

2089

---

What is the disadvantage of User defind function?

2270

---

What are the different types of partitions in oracle?

948

---

Explain about functional dependency and its relation with table design?

987

---

How to turn on or off recycle bin for the session?

1082

---

What is a synonym? What are its various types?

1092

---