Answer Posted / selvaraj v

In oracle 10g :

SELECT * FROM
(SELECT DEPTNO,
EMPNO,
ENAME,
SAL,
DENSE_RANK() OVER(PARTITION BY DEPTNO ORDER BY SAL
DESC) RANK
FROM EMP);

OUTPUT :
------------>

DEPTNO EMPNO ENAME SAL RANK
---------- ---------- ---------- ---------- ----------
10 7839 KING 5000 1
10 7782 CLARK 2450 2
10 7934 MILLER 1300 3
20 7788 SCOTT 3000 1
20 7902 FORD 3000 1
20 7566 JONES 2975 2
20 7876 ADAMS 1100 3
20 7369 SMITH 800 4
30 7698 BLAKE 2850 1
30 7499 ALLEN 1600 2
30 7844 TURNER 1500 3

DEPTNO EMPNO ENAME SAL RANK
---------- ---------- ---------- ---------- ----------
30 7521 WARD 1250 4
30 7521 WARD 1250 4
30 7654 MARTIN 1250 4
30 7900 JAMES 950 5

15 rows selected.

What is a Garbage Collection? and what is full recursive Garbage collection?

2958

---

How would you best determine why your MVIEW couldnt FAST REFRESH?

1933

---

What do you understand by a database object? Can you list a few of them?

1066

---

How to use "out" parameter properly?

1125

---

How do I limit the number of oracle database connections generated by weblogic server?

1118

---

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

1085

---

What is oracle in java?

1019

---

What is a table index?

1171

---

How to delete a column in an existing table?

1132

---

1) Does oracle have any table which contain all the exceptions and it's code internally?

1806

---

How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?

3247

---

What is a trigger and what are its types in oracle?

1156

---

How to select an oracle system id (sid)?

1123

---

Explain what are the characteristics of data files?

1139

---

Explain the use of Merge statement in oracle 11g

1077

---