What does fetching a cursor do?

0 Answers  

---

i have a table eno dno sal 1 10 200 2 10 150 3 10 100 4 20 75 5 20 100 i want to get sal which is less than the avg sal of thri dept. eno dno sal 2 10 150 3 10 100 4 20 75

12 Answers   IBM,

---

I have a procedure in a procedure. The inner procedure contains out parameter. How I can call the inner procedure in the out procedure and send the inner procedure parameter value(out parameter value) into out procedure?

2 Answers  

---

Can you have multiple SPs with the same name on a database?

2 Answers   CGI, Quest,

---

Can we use joins in subquery?

0 Answers  

---

---

What is the difference between an inner and outer join?

0 Answers  

---

why use cursors?

5 Answers   Oracle,

---

How can I create a table from another table without copying any values from the old table?

8 Answers  

---

What are instead of triggers?

0 Answers  

---

If records are inserted into table without committing.How to refer to these values in a procedure?

2 Answers  

---

Is postgresql a nosql database?

0 Answers  

---

How to display the contents of a current record fetched in a reference cursor?

2 Answers  

---