Answer Posted / suryakiran

The main usage of subqueries is to retrieve a single record
from that same table or another table.

And also we can use subqueries to retrieve multiple
records,for this we have to use multiple sub queies,instead
of this its better to use joins based on a condition.

We can perform all operations for joins by using subqueries
but it is very complicated.

How do I manually create a database in oracle?

1067

---

What are a query and state the different types of queries and their uses?

1061

---

Can multiple cursors being opened at the same time?

1112

---

please explain.. DB architecture ...

2078

---

What is set verify off in oracle?

1153

---

Oracle

2422

---

HI, Please let me know the syllabus for Oracle OCA and OCP Certification

2544

---

Explain the use of indexes option in exp command.

1205

---

What is not equal to in oracle?

1047

---

how can we store any pdf file in oracle

2214

---

Why is oracle used?

978

---

What is flashback in Oracle?

1059

---

What language does oracle use?

1164

---

What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.

1024

---

How to use null as conditions in oracle?

1123

---