Answer Posted / prasanna

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

or

delete from employees where employee_id in (select
employee_id from employees where 2 =(select count(distinct
e.salary) from employees e
where e.salary > employees.salary));

Explain what are synonyms used for?

1045

---

How does the on-delete-cascade statement work?

1123

---

What is a user role in oracle?

1137

---

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

1068

---

Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?

1991

---

What is where clause in oracle?

1039

---

What is the Tune Query

2299

---

When do you get a .pll extension in oracle? Explain its importance

1054

---

What is oracle in java?

979

---

What is a nvl function?

1038

---

What are operators in oracle?

1065

---

How to create a table index in oracle?

1139

---

What are the differences between primary key and unique key?

1014

---

What is oracle join syntax?

1006

---

How to list all indexes in your schema?

1101

---