Answer Posted / vinoth

subquery is also known as nested query ....
so guys don't confused about answer
what u had is the correct answer
baiiiiiiiiiiiiiiiii.....

How to add a new column to an existing table in oracle?

1100

---

What is the difference between postgresql and oracle?

997

---

Explain the use of indexes option in imp command.

1115

---

What is the Tune Query

2245

---

How many file formats are supported to export data?

1159

---

What are nested tables?

1121

---

Difference between the “verify” and “feedback” command?

1324

---

What is varray?

1057

---

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

1051

---

Explain implicit cursor.

971

---

How to select an oracle system id (sid)?

1029

---

Hi Masters, in Oracle Applications 11i, we hace 2 functions using the same form, i need to create 1 personalization, but that code must afect only one function.... how can i do that?

2190

---

if you ctreate table identity

2331

---

What is the dynamic sql in oracle?

1027

---

Why does oracle 9i treat an empty string as null?

998

---