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.

Explain the dml?

991

---

Explain the characteristics of oracle dba?

1126

---

What is the use of file param in imp command?

1168

---

What are the types of trigger in oracle?

988

---

What is bind variable in oracle 11g?

1041

---

How to open a cursor variable?

1045

---

How to update a table row with a record?

1019

---

Explain enable novalidate constraint.

1094

---

What are the restrictions on external table columns?

1060

---

What is a cognitive schema?

982

---

What is oracle rowcount?

1091

---

How to end the current transaction in oracle?

1038

---

Will you be able to store pictures in the database?explain.

1000

---

In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col

4181

---

How to change system global area (sga) in oracle?

1017

---