WHAT IS CURSORS?

Amit Singh

Total Post:565

Points:2825
Posted by  Amit Singh
 1368  View(s)
Ratings:
Rate this:
  1. Amit Singh

    Post:565

    Points:2825
    What is cursors?

    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

NEWSLETTER

Enter your email address here always to be updated. We promise not to spam!