Answer Posted / peter

SQL> select sal
2 from (select sal,
3 row_number() over
4 (order by sal desc ) rn
5 from emp )
6 where rn = 2;

SAL
----------
3000

SQL>

What is a nested table and how is it different from a normal table?

1101

---

WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?

2355

---

How do I manually uninstall oracle client?

1145

---

What is system global area (sga) in oracle?

1031

---

What is ordinary table in oracle?

1238

---

Explain the use of show option in imp command.

1144

---

I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database

2182

---

How to drop an existing table in oracle?

1099

---

What is program global area (pga) in oracle?

1088

---

What is a partition in oracle?

1202

---

What is merge statement used for?

1072

---

How to delete a column in an existing table?

1128

---

What are the uses of linked server and explain it in detail?

1117

---

How to call a sub procedure?

1145

---

What is oracle join syntax?

1061

---