Answer Posted / bharath

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

Difference between open_form and call_form in oracle.

684

---

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

1635

---

How to connect the oracle server as sysdba?

633

---

What is bulk copy or bcp in oracle?

610

---

How to invoke the original export import utilities?

507

---

---

What language does oracle use?

601

---

How to Truncate Table in Oracle

657

---

How to use null as conditions in oracle?

584

---

How many categories of data types in oracle?

607

---

How to use fetch statement in a loop?

557

---

How to create a new table in oracle?

593

---

What are the various types of snapshots ?

562

---

What suggestions do you have to reduce the network traffic?

551

---

What are the different oracle database objects?

588

---

What are the set operators union, union all, minus & intersect meant to do?

566

---