Answer Posted / soujanya

RANK calculates the rank of a value in a group of values.
Rows with equal values for the ranking criteria receive the
same rank. Oracle then adds the number of tied rows to the
tied rank to calculate the next rank. Therefore, the ranks
may not be consecutive numbers.

eg: SELECT RANK(15500, .05) WITHIN GROUP
(ORDER BY salary, commission_pct) "Rank"
FROM employees;

how to convert .db (extention) database file into .dmp (extention ) for oracle database ?

2541

---

What is an oracle recycle bin?

976

---

What is Library Cache in Oracle?

1115

---

What is connection pooling in oracle?

947

---

Can sub procedure/function be called recursively?

982

---

What is meant by an index?

1117

---

How to start your 10g xe server?

1014

---

Where are the settings stored for each instance in oracle?

1092

---

What is a static data dictionary in oracle?

1082

---

What is an external table?

997

---

What is the usage of synonyms?

1115

---

How to drop a stored function?

1124

---

How to login to the server without an instance?

1144

---

How to upsert (update or insert into a table)?

983

---

Difference between inner join vs where ?

1009

---