Answer Posted / s.maheshbabu

quarry inside a quarry is called sub quarry.when sub quarry
is also called nested quarry.
co-related sub quarry is one as inner quarry is evaluated.is
anther result of inner are evaluated.
nested quarry is multiple time of one outer quarry.

ex;-quarry used in()caused co-related quarry.
quarry used with=operator is nested quarry.

What is an oracle user role?

1037

---

How to rename a column in an existing table?

1081

---

How to create a testing table in oracle?

1031

---

What is background process in Oracle?

1138

---

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

1028

---

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

2061

---

What is instant client oracle?

1072

---

In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?

2385

---

How to change program global area (pga) in oracle?

1144

---

Is it possible to split the print reviewer into more than one region ?

2338

---

Oracle

2422

---

Why oracle is used?

1103

---

src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));

1746

---

How to check database size in Oracle?

1251

---

How to return top 5 rows in oracle?

1112

---