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.

What is magic table?

6 Answers  

---

Which is better stored procedure or query?

0 Answers  

---

Write a query to get last 10 records from the table.

12 Answers   iNautix,

---

What is the sql query to display the current date?

0 Answers  

---

What are the two parts of a procedure ?

6 Answers   Hi Caliber IT,

---

What is the basic difference between a sql and stored procedure ?

2 Answers   L&T,

---

What is the maximum size of sqlite database?

0 Answers  

---

How do you sort in sql?

0 Answers  

---

trans_id trans_date trans_amt debit_credit_indicator 001 01-JAN-13 1099 cr 001 12-JAN-13 500 db 002 24-FEB-13 400 db 002 23-MAR-13 345 cr 001 18-APR-13 800 cr 002 15-MAR-13 600 db 001 12-FEB-13 200 cr i want like this output trans_id trans_date trans_amt debit_credit_indicator 001 JAN 1599 cr no.of trans 2 i want trans_id and trans_date like 'JAN' or 'FEB' etc, trans_amt i want all credit amount - debit amount per each trans_id. and debit_credit_indicator and no.of transactions in a month.

1 Answers   Oracle,

---

How do I view a sql trace file?

0 Answers  

---

What is a sql statement?

0 Answers  

---

How to display all Friday's in a year with date?

4 Answers   Flipkart,

---