WHAT IS CURSORS?

Amit Singh

Total Post:562

Points:2810
Posted by  Amit Singh
 1447  View(s)
Ratings:
Rate this:
  1. Amit Singh

    Post:562

    Points:2810
    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!