Subject | Cursors? |
---|---|
Author | Gerhardus Geldenhuis |
Post date | 2001-10-12T08:56:24Z |
Hi
I have read the explanation in the Language Reference and the data
definition guide of which bove explains what a cursor is but to me it is not
very clear.
"A cursor is a one-way pointer into the ordered set of rows retrieved by the
select expression in the DECLARE CURSOR statement. It enables sequential
access to
retrieved rows in turn."
What would be the typical application of a cursor. When is it a good idea
to use and when not. I cant see the difference between a cursor and a
select statement to me it appears as if they achieve the same goal.
Groete
Gerhardus
I have read the explanation in the Language Reference and the data
definition guide of which bove explains what a cursor is but to me it is not
very clear.
"A cursor is a one-way pointer into the ordered set of rows retrieved by the
select expression in the DECLARE CURSOR statement. It enables sequential
access to
retrieved rows in turn."
What would be the typical application of a cursor. When is it a good idea
to use and when not. I cant see the difference between a cursor and a
select statement to me it appears as if they achieve the same goal.
Groete
Gerhardus