Answer Posted / khan

DELETE FROM
(SELECT EMP_ID, SALARY, DENSE_RANK() OVER (ORDER BY SALARY DESC) AS CNT FROM EMPLOYEE)
WHERE CNT = 3;

Explain the use of grant option in imp command.

1038

---

What is the data pump export utility?

1093

---

What is an anonymous block?

1266

---

I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database

2148

---

What is object data modeling?

973

---

What is the difference between 10g OEM and 11g OEM?

975

---

How do you increase the OS limitation for open files (LINUX and/or Solaris)?

1939

---

What is a cursor variable?

1144

---

Explain oracle data types with examples?

1038

---

can u send the sql dumps to sivakumarr1987@gmail.com plz help me

3060

---

Will you be able to store pictures in the database?

1132

---

What is the difference between post-database commit and post-form commit?

1210

---

src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));

1698

---

How to convert times to characters in oracle?

1035

---

What is recycle bin in Oracle?

1161

---