Answer Posted / rajeevgeu

select rownum,salary from(select rownum r,salary from emp order by salary)where r=3;

definition of cluster and non-clustered index?

2958

---

Can multiple cursors being opened at the same time?

1015

---

How to create a new view in oracle?

1012

---

Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.

1943

---

How do I uninstall oracle 11g?

1037

---

How to connect asp pages to oracle servers?

1002

---

How many types of table in Oracle?

1055

---

How to bring a tablespace online?

992

---

What is the meaning of recursive hints in oracle?

992

---

What is a schema in oracle?

965

---

Why is oracle database so popular?

946

---

What are group functions in oracle?

965

---

What are the various constraints used in oracle?

990

---

How to change program global area (pga) in oracle?

1031

---

what is difference between sql plus and sql*plus? (not sql and sql plus).

3811

---