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;

what is the scenario where you take the database to NoArchivelog mode?

2377

---

What privilege is needed for a user to create tables in oracle?

991

---

What is max rowid in oracle?

1081

---

How would you begin to troubleshoot an ORA-3113 error?

2125

---

Explain an index segment?

1159

---

How to compare dates in oracle sql?

1160

---

What are the different types of failures that occur in Oracle database?

1121

---

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

1129

---

Can we use oracle pl/sql block in core java? if so how? pls get back to me .....

3019

---

Is java required for oracle client?

1048

---

What is the max number of columns in an oracle table?

1047

---

How to assign values to variables?

1164

---

What is the difference between $oracle_base and $oracle_home?

1136

---

What is procedure overloading in oracle?

1113

---

Explain user account with reference to oracle.

1029

---