Answer Posted / amitabh sharma

Here are 2 queries for finding 3rd highest salary:

select * from emp e
where 3 = (select count(sal) from emp
where e.sal < sal);


SELECT * FROM
(
SELECT Ename, SAL, dense_Rank() OVER (ORDER BY SAL DESC )
RANKNEW FROM EMP)
WHERE RANKNEW = 3

Regards,
Amitabh Sharma

Differentiate between function and procedure in oracle.

1078

---

What is an oracle user role?

984

---

In oracle there is column command, how will you explain that?

1057

---

How to drop a stored function?

1138

---

Why we use bulk collect in oracle?

1044

---

what is the difference between substr and instr function in oracle?

1090

---

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

2008

---

What is data block in Oracle?

1116

---

Explain the use of record length option in exp command.

1067

---

20. Using a set operator, display the client number of all clients who have never placed an order.

2187

---

How to pass a parameter to a cursor in oracle?

1184

---

How to open and close an explicit cursor in oracle?

1058

---

Does oracle partitioning improve performance?

995

---

what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?

2265

---

What is the difference between $oracle_base and $oracle_home?

1089

---