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));

Is oracle a programming language?

1039

---

What are the attributes of cursor?

1105

---

What is transport network substrate (tns) in oracle?

1096

---

How to execute the package in oracle?

1136

---

What is an oracle and why it is used?

1214

---

Can you drop an index associated with a unique or primary key constraint?

1070

---

What is clustered table in Oracle?

1262

---

What are the restrictions in a oracle read only transaction?

1084

---

What is the parameter mode that can be passed to a procedure?

1111

---

What are the differences between lov and list item?

1147

---

What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?

1114

---

Can we write insert statement in function in oracle?

1156

---

How do I uninstall oracle 11g?

1178

---

What are the different types of database objects?

1121

---

What is the difference between I and G in Oracle?

1152

---