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

Explain the use of indexes option in imp command.

1262

---

Is there an oracle sql query that aggregates multiple rows into one row?

1027

---

How to see free space of each tablespace?

1082

---

when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.

2044

---

What query tells you how much space a tablespace named test is taking up, and how much space is remaining?

2335

---

interview questions with answer for cts

2636

---

Explain a data segment?

1112

---

What is oracle database 10g express edition?

1169

---

Explain the dml?

1051

---

What is recovery manager(rman) backup in Oracle?

1231

---

What is translate in oracle?

1141

---

What is the difference between online and offline backups?

1132

---

How many types of cluster table in Oracle?

1080

---

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

1068

---

What is memory advisor in Oracle?

1132

---