what are the advantages of cursors than procedures?

Question Posted / swapna

2 Answers
10990 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

what are the advantages of cursors than procedures?..

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

Is This Answer Correct ?

16 Yes

0 No

what are the advantages of cursors than procedures?..

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.

Is This Answer Correct ?

12 Yes

2 No

Post New Answer