Answer Posted / bhuvana

Joins-
1.Want to combine and fetch data from more than 2 tables.
2.Joins are faster, efficient, easy to understand and better performance.
Subquery-
Want to combine and fetch data from a pair of table.

master table and child table performances and comparisons in Oracle ?

2138

---

How to do clean up if create database failed?

1033

---

How do I connect to oracle database?

1125

---

How to drop an index in oracle?

1076

---

definition of cluster and non-clustered index?

3035

---

hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards

2001

---

ur a sql devoloper...what is the process in ur company for finding the database BUGS .. seperate DB testers are there? or devr.s are manage? if DB TESTERS in there what is the process

2290

---

How to use existing values in update statements using oracle?

1071

---

What do you mean by merge in oracle and how can we merge two tables?

1052

---

What are the advantages of oracle?

1029

---

What do you mean by merge in oracle and how can you merge two tables?

951

---

What is the difference between I and G in Oracle?

1099

---

What are the attributes of cursor?

1054

---

How oracle handles dead locks?

1071

---

Where are the settings stored for each instance in oracle?

1107

---