Answer Posted / amit sutar

select min(salary)

from(select distinct(salary)
from employees
order by salary desc)

where rownum<=5;

Differentiate between translate and replace?

1040

---

How to get a create statement for an existing table?

908

---

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

979

---

Explain temporal data types in oracle

1044

---

how the indexes are stored in the Oracle Database?

2214

---

Is java required for oracle client?

928

---

How index is implemented in oracle database?

946

---

How to connect ms access to oracle servers?

947

---

How to empty your oracle recycle bin?

982

---

What is the difference between a user and a schema in oracle?

984

---

How to experiment a data lock in oracle?

1001

---

What is the purpose of save points in oracle database?

1007

---

How to use "startup" command to start default instance?

963

---

What is oracle thin client?

975

---

How to create a server parameter file?

1081

---