Answer Posted / tulasi

select * from emp x where 1=(select count(distinct sal)
from emp y where x.sal<=y.sal);

query to find nth sal

select * from emp x where &n=(select count(distinct sal)
from emp y where x.sal<=y.sal);

How to see the table columns used in an index?

998

---

How to convert csv to table in oracle?

973

---

What is Library Cache in Oracle?

1117

---

How to define a cusotmer as a supplier in ORACLE R12

2212

---

Does oracle charge for java?

1043

---

Can objects of the same schema reside in different tablespace?

1046

---

What happens if you lost a data file?

1027

---

How to import one table back from a dump file?

1009

---

How to rename an index?

1050

---

What is logical backup in oracle?

999

---

Is primary key indexed by default in oracle?

967

---

How to drop an existing table in oracle?

1047

---

Explain what are clusters?

1087

---

Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?

987

---

How would you go about verifying the network name that the local_listener is currently using?

2027

---