Answer Posted / peter

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

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

SQL>

What is a parameter file in oracle?

1185

---

How to run create database statement?

1075

---

Explain an index segment?

1158

---

How to export your own schema?

1048

---

Can sub procedure/function be called recursively?

1045

---

what is meant by magic query

2230

---

How to define a sub function?

1197

---

Explain the blob datatype?

1122

---

What privilege is needed for a user to insert rows to tables in another schema?

1056

---

Where is the export dump file located?

1218

---

What happens if variable names collide with table/column names?

1262

---

How to loop through data rows in the implicit cursor?

1116

---

candidate key is subset of super key but not vice-verse explain

2106

---

Give the different types of rollback segments.

1076

---

i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)

2383

---