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 are the differences between primary key and unique key?

950

---

What is Library Cache in Oracle?

1077

---

How to download oracle database 10g xe?

962

---

What is background process in Oracle?

1053

---

How do I use os authentication with weblogic jdriver for oracle and connection pools?

1000

---

Please explain joins in oracle?

1011

---

In what script is snap$ created? In what script is the scott/tiger schema created?

2659

---

Can we write dml statement in function in oracle?

1026

---

nw i'm doing MBA system and planning to do oracle,database management.tell me that whether it is useful r not?.refer any course for my carrier pls

2149

---

What happens if you lost a data file?

980

---

In Oracle Applications We are Using Sub Ledger Accounting. When we Transfer the Data all modules (AP,AR,CE,FA) to SLA We done Some customizations? What are They??

1790

---

Name the three major set of files on disk that compose a database in Oracle?

1072

---

What is redo log?

1009

---

How to rename an existing table?

1053

---

What is a table index?

1018

---