cursor

[helpamit]

what is benifit of using cursor?

[Indsack]

what is benifit of using cursor?

When SQL runs a select statement, the resulting rows comprise the result table. A cursor provides a way to access a result table.

A DECLARE CURSOR ,OPEN and CLOSE ,A FETCH are some of cursors..

[rushdishams]

Also, by using triggers, you can fetch a single row at a time. if you have a trigger on some field and more than one row at a time is fetched as a result of your query on that field, then obviously you are having an ERROR message. cursors are good way providing you the facility to fetch and display rows fetched more than one at a time.

Cheers