what is the differnce between procedure and function? in both dml operations can work and in procedure through out parameter you can return value ,then what is the differce?

3 Answers   3i Infotech,

---

what is ref cursor in pl/sql?

3 Answers  

---

What is error ora-01000: maximum open cursors exceeded

0 Answers  

---

How do you copy a table in sql?

0 Answers  

---

What is union and union all keyword in sql?

0 Answers  

---

Is sql injection illegal?

0 Answers  

---

what is the difference between cursor FETCH and FOR LOOP ?

3 Answers   CG-VAK, Tech Mahindra,

---

What cursor type do you use to retrieve multiple recordsets?

17 Answers   Apollo, CTS, IonIdea, Microsoft, Oracle, TCS, Vmoksha, Wipro,

---

There is a table, In one column it has implemented a index, but the index is disturbed by the regular dml statements.. but still we need to keep the index. how it is possible?

1 Answers   Cognizant,

---

What is cold data?

0 Answers  

---

What is rule base and cost base optimizer?

2 Answers   Thermotech,

---

Why do we need cursor in pl sql?

0 Answers  

---