Answer Posted / alka

select min(salary)
from(select salary
from emp
order by salary desc
)
where rownum <=3

When do I need to use a semicolon vs a slash in oracle sql?

594

---

1) Does oracle have any table which contain all the exceptions and it's code internally?

1284

---

What is a dynamic performance view in oracle?

608

---

How can you merge two tables in oracle?

571

---

what are the advantages of running a database in archive log mode?

1737

---

---

Is oracle the best database?

522

---

How to name query output columns in oracle?

692

---

How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

1833

---

How to write text literals in oracle?

614

---

How to convert csv to table in oracle?

528

---

How many anonymous blocks can be defined?

588

---

How to pass parameters to procedures in oracle?

570

---

Is oracle a programming language?

570

---

How do I find the database name in oracle?

603

---

What is meant by recursive hints in oracle?

622

---