Answer Posted / nagaraju nampally

select * from (select ename,sal,deptno,dense_rank()
over(partition by deptno order by sal)rnk from emp)x where
x.rnk<5

What is a snapshot in oracle database?

1022

---

How do I call oracle stored procedures that take no parameters?

1106

---

Explain drop constraint oracle?

1057

---

Give the various rollback segment states.

1050

---

How to check database size in Oracle?

1189

---

How to start a new transaction in oracle?

1083

---

How to use existing values in update statements using oracle?

1065

---

How to convert raw data type into text in oracle? Explain

991

---

How to save query output to a local file?

1023

---

What is recovery manager(rman) backup in Oracle?

1183

---

How to work with data objects interactively?

976

---

What happens if you use a wrong connect identifier?

1057

---

How to create a stored procedure in oracle?

1102

---

What are the differences between number and binary_float in oracle?

1098

---

What is oracle rownum?

947

---