top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

What is cursors?

+1 vote
193 views
What is cursors?
posted Dec 2, 2014 by Balu

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

+1 vote
 
Best answer

Cursor is a database object used by applications to manipulate data in a set on a row-by-row basis,
instead of the typical SQL commands that operate on all the rows in the set at one time.
In order to work with a cursor we need to perform some steps in the following order:
Declare cursor
Open cursor
Fetch row from the cursor
Process fetched row
Close cursor
Deallocate cursor

answer Dec 2, 2014 by Manikandan J
...