Answer Posted / raunaq

to all the people who are using rownum in their queries...

This query will not work if you have more than 1 person
having the second highest salary

What is private procedure oracle?

1049

---

What is execute immediate in oracle?

1078

---

What is a proxy object?

1108

---

How to export your own schema?

1051

---

How to execute a stored program unit?

1128

---

Explain the difference between sap and oracle?

1086

---

What is the difference between post-database commit and post-form commit?

1286

---

How to sort output in descending order in oracle?

1102

---

What is an oracle user account?

1040

---

How to count groups returned with the group by clause in oracle?

1122

---

what is normalisation?what are its uses?

2329

---

What is parameterized cursor in oracle?

1222

---

How to define an anonymous procedure with variables?

1240

---

Select all the employees who were hired in last 2 years and who works in dept where max managers are working.

3021

---

What would you do with an in-doubt distributed transaction?

2047

---