Answer Posted / rakhi

SELECT *
FROM (
SELECT employee_id, last_name, salary,
RANK() OVER (ORDER BY salary DESC) EMPRANK
FROM employees)
WHERE emprank = 2;

Explain the use of rows option in imp command.

604

---

How oracle handles dead locks?

598

---

What is tns entry?

619

---

how to do daily transactions with out sql* loader control file regesterd in apps?

1219

---

What is oracle database client?

551

---

---

Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ mak2786@gmail.com thanks Arun

1661

---

What is meant by joins? List out the types of joins.

519

---

Explain database link?

660

---

How to pass parameters to procedures?

553

---

How to use existing values in update statements using oracle?

545

---

What is the difference between I and G in Oracle?

601

---

What do you mean by merge in oracle?

589

---

How to unlock the sample user account in oracle?

556

---

What is BBED in Oracle?

683

---

How to concatenate two text values in oracle?

589

---