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 oracle rowcount?

1051

---

How to resolve the ORA-39133 error in Oracle?

1069

---

What are the general rules on data consistency?

977

---

Can we use bind variables in oracle stored procedure?

918

---

What is a select query statement in oracle?

923

---

What is recycle bin in Oracle?

1107

---

How to create an oracle testing table?

1023

---

How to shutdown your 10g xe server from command line?

1035

---

What is bulk load in oracle?

1030

---

How can I create database in oracle?

975

---

State all possible different index configurations a table can possibly have?

960

---

What is a database table in oracle?

984

---

What is object data modeling?

918

---

What are the uses of synonyms?

1103

---

Explain the use of constraints option in exp command.

1011

---