Answer Posted / raghav

select * from (
select Name,
Salary,
Dept,
Rank()over (order by salary desc) RANK
from Employee)
where RANK = 3

Why do we use coalesce function in oracle?

631

---

Explain integrity constraints?

668

---

what is the difference between restoring and recovering?

558

---

How to use "in" parameter properly?

619

---

Please explain joins in oracle?

549

---

---

How to run create database statement?

579

---

What is SQL access advisor in Oracle?

632

---

How to start a specific oracle instance?

584

---

Is oracle a programming language?

568

---

How to concatenate two text values in oracle?

593

---

Which environment variables are absolutely critical in order to run the OUI?

1658

---

How to retrieve data from an cursor to a record?

563

---

What is a package ? What are the advantages of package ?

605

---

What is partitioned table in Oracle?

639

---

What are the general rules on data consistency?

589

---