Answer Posted / harmeet

Hi, this query will gives the third highest salary from table

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

To dispay 5th highest salary, just change the number 3 to 5.
Like that we can find top N salaries.

I hope i'm not wrong.

Is insert autocommit in oracle?

1065

---

What are the varoius components of physical database structure of oracle database?

1006

---

How to get execution path reports on query statements?

981

---

Explain the use of grant option in imp command.

1022

---

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

2005

---

How to assign values to data fields in record variables?

1031

---

Explain the use of consistent option in exp command.

1063

---

How do I start tns listener?

1040

---

How to create an initialization parameter file?

1049

---

In Oracle Applications We are Using Sub Ledger Accounting. When we Transfer the Data all modules (AP,AR,CE,FA) to SLA We done Some customizations? What are They??

1840

---

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 are temporal data types in oracle?

1121

---

How to concatenate two text values in oracle?

1112

---

Explain a data segment?

1064

---

Explain the types of exception?

1143

---