Answer Posted / amit sutar

select min(salary)

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

where rownum<=5;

Is insert autocommit in oracle?

1066

---

How to delete all rows a table in oracle?

1068

---

What is meant by an index?

1139

---

How many file formats are supported to export data?

1218

---

what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?

2263

---

What is the difference between translate and replace?

1058

---

hi friends i completed b.com 2004.i have 3y accounting exp. in manufacturing company.now i have completed oracle finance.pls suggest me how will get job in oracle.can i get job in oracle.

2368

---

How to loop through data rows in the implicit cursor?

1073

---

Can group functions be used in the order by clause in oracle?

997

---

What is the purpose of save points in oracle database?

1114

---

what's query optimization and without use of IN AND Exist can we get another way data from query

2139

---

Explain what are the uses of rollback segment?

1004

---

What is oracle rownum?

950

---

What happens in oracle commit?

1024

---

How does oracle handle read consistency?

1095

---