Answer / kumar srinivasalu

Cursors can be used to pass the parameters to procedures
and functions. The Single cursor used to multiple
updatation and used multiple queries at run time

Answer / somashekhar m

By using cursors It is possible to fetch row by row, when
user might want to work with rows one at a time. But not
possible with SQL standard statements it is not possible to
go row by row fetching.
A cursor can be defined as is a set of rows together with a
pointer that identifies a current row.

in ACID cursor works for consistency of the data.

Mention what plvcmt and plvrb does in pl/sql?

0 Answers  

---

can we delete the trigger in a view? if yes why if not why?

5 Answers   Tech Mahindra,

---

Hello All, Could any well write a query for the following scenario. Account(table name) No Name Amount 1 ABCD 2000.00 2 DEFG -2000.00 3 GHIJ 3000.50 4 JKLM 4000.00 5 MNOP 6000.00 O/p Should be in this format No Name Credit Debit 1 ABCD 2000.00 0 2 DEFG 0 -2000.00 3 GHIJ 3000.50 4 JKLM 0 -4000.00 5 MNOP 6000.00 o could any one give appropriate query for this Thnks in Advance

5 Answers   Target,

---

How do I count rows in sql?

0 Answers  

---

Why stored procedure is faster than query?

0 Answers  

---

What is cursor and why it is required?

0 Answers  

---

What is Overloading of procedures ?

2 Answers  

---

can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible? : Sql dba

0 Answers  

---

how can I make a script that can be bi-language (supports english, german)? : Sql dba

0 Answers  

---

how to calculate the difference between two dates? : Sql dba

0 Answers  

---

how many columns can be used for creating index? : Sql dba

0 Answers  

---

Does mysql support pl sql?

0 Answers  

---