Answer Posted / shivaprasad

select distinct top 1 Salary from(select distinct top 3
Salary from Employee order by Salary DESC)temp order by
Salary;

What are the different types of trigger and explain its various uses and functions?

551

---

What are the differences between number and binary_float in oracle?

571

---

how may join possible between (requisition with purchase order)

1699

---

How to delete multiple rows from a table in oracle?

563

---

What is the difference between pre-select and pre-query?

621

---

---

How to import one table back from a dump file?

597

---

Explain the use of file option in exp command.

601

---

Whats the benefit of dbms_stats over analyze?

1497

---

How do I find my oracle client driver version?

528

---

query optmization techniques and quwry analyser+projects+ppts

1932

---

What is the disadvantage of User defind function?

1833

---

What is the difference between sharding and replication?

479

---

Can we commit inside a function in oracle?

560

---

Explain what are the advantages of views?

613

---

List out the difference between commit, rollback, and savepoint?

621

---