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));

What is meant by recursive hints in oracle?

1134

---

What is format trigger?

2121

---

What is the relationship among database, tablespace and data file?

1039

---

List out the components of logical database structure of oracle database.

1096

---

How do I use unicode codesets with the weblogic jdriver for oracle driver?

1125

---

What is a parameter file in oracle?

1191

---

What is meant by an index?

1224

---

How do you bind variables in oracle?

1024

---

how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?

2058

---

How to drop an index in oracle?

1121

---

what is normalisation?what are its uses?

2334

---

How many categories of data types?

1043

---

How to install oracle database 10g xe?

1064

---

you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz

2002

---

Explain what are synonyms used for?

1096

---