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>

Give the various rollback segment states.

1003

---

 How to use an oracle sequence generator in a mapping?

1021

---

What is tns entry?

1065

---

What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.

1059

---

What is the difference between PFILE and SPFILE in Oracle?

996

---

Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?

1328

---

6. Display the client name and order date for all orders using the traditional method.

2244

---

Explain the use of tables option in exp command.

1054

---

How do we display rows from the table without duplicates?

920

---

is there a tool to trace queries, like profiler for sql server?

1079

---

How to rename an existing table?

1052

---

Can you tell me how to add new column in existing views?how?How is possible?

1372

---

What happens to the data files if a tablespace is dropped?

996

---

Explain self joins in oracle?

951

---

How to write an inner join with the where clause in oracle?

997

---