Answer Posted / ved

SELECT TOP 1 salary
FROM (
SELECT DISTINCT TOP n salary
FROM employee
ORDER BY salary DESC) a
ORDER BY salary

How to update values on multiple rows in oracle?

600

---

How can windows applications connect to oracle servers?

522

---

What exactly do quotation marks around the table name do?

544

---

Explain table?

651

---

Explain what are the different type of segments?

577

---

---

How many types of auditing in Oracle?

566

---

What is different types of joins?

574

---

How to rename an index in oracle?

616

---

Explain an integrity constrains?

697

---

How do I limit the number of rows returned by an oracle query after ordering?

631

---

How to assign a tablespace to a users in oracle?

591

---

Can we use bind variables in oracle stored procedure?

490

---

how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?

1829

---

Why we use bulk collect in oracle?

536

---

What is truncate oracle?

531

---