Answer Posted / prem

SQL> select salary from(select salary,rownum a from(select salary from employee order by salary desc))where a=2;

How many types of cluster table in Oracle?

575

---

How to use group functions in the select clause using oracle?

593

---

How to rename a tablespace in oracle?

618

---

What is index in Oracle?

590

---

Explain the use of show option in imp command.

638

---

---

Difference between hot backup vs. Cold backup?

606

---

What is primefaces used for?

559

---

Why do you use stored procedures and state some of its disadvantages?

563

---

What is a snapshot in oracle database?

575

---

How to create tables for odbc connection testing?

492

---

What is data file?

619

---

How to create a stored program unit?

580

---

Please explain drop constraint oracle?

627

---

Hi Can any one tell me what are the API's used in requisition import.

1485

---

How to convert numbers to characters in oracle?

588

---