Answer / 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 difference between view and materialized view in Oracle?

0 Answers   MCN Solutions,

---

It's Urgent? How to IMPORT .xls & .txt file into ORACLE?

5 Answers  

---

From the database level, how can you tell under which time zone a database is operating?

1 Answers  

---

What are triggers?Where are they used?

3 Answers  

---

How to Truncate Table in Oracle

0 Answers   HCL,

---

Explain about the analyze command in oracle?

0 Answers  

---

how to get required data from oracle source is like this ram_05_seetha lax_05_viswa bamr05frummy run_01_away sw_sas_trim i want my target data like ram_05_seetha lax_05_viswa to get data using %_05_% but it will give ram_05_seetha lax_05_viswa bamr05frummy how can i get my target data?

1 Answers   Infosys,

---

What is cluster Key ?

3 Answers  

---

Hi all, Can any one give answer for this question. Suppose im having employee table with fields, eno, ename, dept, address1, address2, address3. In address field employee can fill only address1 or address2 or address3... at a time he can fill three address fields. now i want all employee names who filled only one address field.. Plz its urjent can any one give querry.. Thanks in advance.

4 Answers   JPMorgan Chase,

---

What are the various types of snapshots ?

0 Answers  

---

How to define default values for formal parameters?

0 Answers  

---

What is rowid and rownum in oracle?

0 Answers  

---