Answer Posted / surya

select * from emp where &n-1=(select count(distinct sal)
from emp e where emp.sal<e.sal);

For example:-
If you enter n=1,it will display first highest salary
if you enter n=2,it will display second highest salary
......

if you enter n=nth,it will display nth salary

Explain enable novalidate constraint.

1064

---

How to rename an index?

1050

---

What do database buffers contain?

1005

---

How to define a data field as not null?

1092

---

why should i declare foreign key constraint as self relation instead of binary relation in tables ?

2024

---

 How to use an oracle sequence generator in a mapping?

1053

---

What are data pump export and import modes?

1048

---

What is ceil and floor in oracle?

1052

---

How do we represent comments in oracle?

1031

---

How do I know if oracle client is installed on windows?

1003

---

In what script is snap$ created? In what script is the scott/tiger schema created?

2691

---

material view and view disadvantages?

1049

---

How to create tables for odbc connection testing?

1086

---

what is the difference between functional dependecy and multilevel dependency?

2445

---

How many types of cluster table in Oracle?

1019

---