Answer Posted / santhoshkumar

select name,salary from emp where salary=(select min(sal)
from (select distinct TOP 3(salary) from emp order by
salary desc;

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

2329

---

Name the various constraints used in oracle?

1030

---

What is a select query statement in oracle?

977

---

How to write a query with an inner join in oracle?

1048

---

Is primary key indexed by default in oracle?

994

---

What are ddl statements in oracle?

1082

---

What is oracle analytical function?

1155

---

How to end the current transaction in oracle?

1038

---

How to use subqueries with the exists operator in oracle?

1032

---

Does oracle charge for java?

1061

---

How many data types are supported?

1086

---

Explain integrity constraint?

1164

---

What is the usage of save points in oracle database?

967

---

How to rename an existing table?

1133

---

What is a database schema in oracle?

1115

---