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>

Why use resource manager in Oracle?

1110

---

What are the execution control statements?

1071

---

How to define a variable of a specific record type?

1081

---

How do I start tns listener?

1051

---

How to handle a single quote in oracle sql?

1058

---

What are the arithmetic operations?

1087

---

What is open database communication (odbc) in oracle?

1004

---

What is a package in oracle?

1108

---

What is hash cluster in oracle?

1176

---

Difference between oracle's plus (+) notation and ansi join notation?

1111

---

What is a partition in oracle?

1127

---

What are joins, explain all types of joins?

2299

---

How to create an oracle testing table?

1075

---

What is a tns file?

1001

---

What is clustered table in Oracle?

1201

---