Answer Posted / biswapratap singh

SELECT MIN(sal) FROM emp WHERE
sal IN (SELECT distinct TOP 3 sal FROM emp ORDER BY sal DESC)

How to drop an existing view in oracle?

560

---

What is a user account in oracle?

616

---

What do you mean by merge in oracle and how can you merge two tables?

513

---

What is the difference between translate and replace?

546

---

What is flashback in Oracle?

575

---

---

How to define an anonymous procedure with variables?

535

---

Explain a synonym?

590

---

What are the restrictions in a oracle read only transaction?

558

---

Explain an exception?

560

---

How to count groups returned with the group by clause in oracle?

562

---

Which is better Oracle or MS SQL? Why?

3954

---

How to call a sub procedure?

554

---

How to rename a tablespace in oracle?

609

---

How to select some columns from a table in oracle?

543

---

How to initialize variables with default values?

621

---