Answer Posted / deepika s verma

In Oracle we can catogrise joins in following ways -
(1) Equi Join (Query having joining condition)
- Natural Join
- Join Using
- Join ON
(2) Non Equi Join or Cartesian Join ( without using joining
condition)
(3)Outer Join
- left outer join
- right outer join
- full outer join
(4) self Join or Theta Join
(5) Cross Join
(6) Inner Join

How to convert times to characters in oracle?

976

---

What is the data type of dual table?

918

---

What is a database table in oracle?

951

---

What are the set operators union, union all, minus & intersect meant to do?

935

---

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

1013

---

What happens to the current transaction if the session is killed?

924

---

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

1008

---

What is archive log in Oracle?

1068

---

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

1001

---

How to insert multiple rows with one insert statement in oracle?

1019

---

How to enter a new row into a table interactively?

960

---

What is oracle in java?

909

---

What is an oracle database?

989

---

What is a cursor and what are the steps need to be taken?

1116

---

What is memory advisor in Oracle?

1022

---