Answer Posted / manjusure@yahoo.co.in

select * from emp e where 5> (select count(max(sal)) from emp
where e.deptno=deptno and sal>e.sal group by sal);

How to loop through data rows in the implicit cursor?

1120

---

In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?

2350

---

Explain the difference between a procedure and a function? What do you understand by those terms?

1136

---

Explain oracle’s system global area (sga).

1189

---

What do you mean by a tablespace?

1092

---

What is a nvl function? How can it be used?

1100

---

What is oracle and what are its different editions?

1122

---

How to update a table row with a record?

1069

---

What is a user account in oracle?

1173

---

HI, Please let me know the syllabus for Oracle OCA and OCP Certification

2550

---

What is a system tablespace and when it is created?

1018

---

What is BBED in Oracle?

1201

---

What to do if the startbd.bat failed to start the xe instance?

1132

---

hi friends i completed b.com 2004.i have 3y accounting exp. in manufacturing company.now i have completed oracle finance.pls suggest me how will get job in oracle.can i get job in oracle.

2426

---

What happens in oracle commit?

1082

---