Answer Posted / mk

select Name from emp where sal=(select distinct(Max(sal))
from emp

How to sort the query output in oracle?

1028

---

Explain implicit cursor.

1036

---

How do I spool in oracle?

1012

---

What is a schema in oracle?

1018

---

What are the predefined tablespaces in a database?

1086

---

What are named parameters?

1095

---

please explain.. DB architecture ...

2029

---

what is the difference between data migration and production migration.

2347

---

How many memory layers are in the oracle shared pool?

1185

---

What is format trigger?

2075

---

I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance

2324

---

What are the various types of snapshots ?

1030

---

what is the dual table in oracle?

993

---

what is insert all statement in sql

6526

---

What do you mean by a database transaction & what all tcl statements are available in oracle?

994

---