Answer Posted / deepal saini

this is the best way to find out thethird highest salary from emp table

select max(sal) from emp where sal<(select max(sal) from emp where sal <(select max(sal)from emp));

How to create an oracle database manually?

1023

---

What is a data dictionary and how can it be created?

1057

---

What are the differences between date and timestamp in oracle?

974

---

Respected sir, Please send me technical questions related to oracle apps..

1762

---

How to drop an index?

910

---

How to rename an existing table?

1052

---

How does the on-delete-cascade statement work?

1061

---

What do you mean by merge in oracle and how can you merge two tables?

907

---

What are ddl statements in oracle?

1018

---

How to use null as conditions in oracle?

1003

---

Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?

1047

---

What would you do with an in-doubt distributed transaction?

1916

---

What is oracle thin client?

974

---

What exactly do quotation marks around the table name do?

918

---

What are the different types of partitions in oracle?

911

---