Answer / oracleapps_learner

A Cursor is a pointer, which works on active set, I.e.
which points to only one row at a time in the context area?s
ACTIVE SET. A cursor is a construct of pl/sql, used to
process multiple rows using a pl/sql block.

Answer / suresh.somayajula

Cursor is a private SQL worksheet area where we can

execute SQL commands and to store processing information.

Answer / dipa paul

Cursor works as a array.

Could any one tell me the steps of conversions and what kind of validations and exceptions do we use during this conversion? Please do answer in detail. what program do we write in user exit in reports?

3 Answers   iGate,

---

Can you explain the difference between architecture followed in 10g & 11g?

0 Answers  

---

How to report output like below supplier name date amount abc software jan/11 10000 /* jan month total transactions*/ abc software feb/12 30000 /* feb month total transactions*/ dell computers jan/13 45000 /* jan month total transactions*/

4 Answers   Satyam,

---

can we use commit in trigger? If yes how?

2 Answers   Cap Gemini, TCS,

---

what is pl/sql table and pl/sql records? what is the use of that?

3 Answers   Intelligroup,

---

what is the difference between procedure and function

3 Answers   Wipro,

---

What is the Lookup's and what is the use of lookup's?

3 Answers   TCS,

---

what are the pl/sql tables

1 Answers   IBM,

---

what is organization id

2 Answers   Wipro,

---

Oracle E-Business suite?

2 Answers  

---

how can i print random rows in plsql table

0 Answers   Fujitsu, KPIT,

---

do i need to declare bind parameter before using in the query?

2 Answers   Satyam,

---