Answer Posted / bharath

select e1.* from emp e1
where &n=
(select count(distinct(*))
from emp e2
where e2.sal>e1.sal);

Please explain drop constraint oracle?

1101

---

How to create a table in a specific tablespace?

972

---

What is flashback in Oracle?

1015

---

How do I learn what codesets are available in oracle?

1036

---

What is sequence?

1076

---

normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi

2204

---

What is an external table?

1013

---

what is the difference between restoring and recovering?

1009

---

Explain index?

1256

---

How to update values on multiple rows in oracle?

1034

---

How to assign values to data fields in record variables?

1030

---

does the query needs a hint to access a materialized view?

1857

---

How to use attributes of the implicit cursor in oracle?

1008

---

How to retrieve data from an explicit cursor?

1058

---

List the parts of a database trigger.

1048

---