Answer Posted / amit sutar

select min(salary)

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

where rownum<=5;

What is the usage of synonyms?

591

---

How to best split csv strings in oracle 9i?

590

---

How to create a stored procedure in oracle?

575

---

What is materialized view in Oracle?

630

---

i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?

1472

---

---

What is set operator oracle?

530

---

What is parameterized cursor in oracle?

578

---

What is Library Cache in Oracle?

644

---

How to use windows user to connect to the server?

536

---

What are the differences between blob and clob in oracle?

585

---

what is the difference between restoring and recovering?

558

---

How a tablespace is related to data files?

583

---

can u send the sql dumps to sivakumarr1987@gmail.com plz help me

2599

---

What are the ways tablespaces can be managed and how do they differ?

1618

---

How do I find the database name in oracle?

601

---