Answer Posted / tejeswara rao potnuru

Find Out The Nth Highest Salary


SELECT MAX(SAL),LEVEL FROM EMP
WHERE LEVEL=&LEVELNO
CONNECT BY PRIOR SAL>SAL
GROUP BY LEVEL;

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

1094

---

What are the ways tablespaces can be managed and how do they differ?

2381

---

How to load a large xml file?

1063

---

What is a private synonym?

1594

---

What is the sid in oracle?

978

---

What is set operator oracle?

992

---

How to start a new transaction in oracle?

1095

---

What is java oracle used for?

1031

---

please explain.. DB architecture ...

2032

---

How can windows applications connect to oracle servers?

1070

---

Explain about achiever in sql?

1043

---

Can a parameter be passed to a cursor?

1138

---

What is a named program unit?

1097

---

How do you get nicely formatted results from an oracle procedure that returns a reference cursor?

1088

---

How to execute a stored program unit?

1087

---