CONCEPT OF CURSOR IN DATABASE?

Monaj Singh

Total Post:48

Points:240
Posted by  Monaj Singh
 1159  View(s)
Ratings:
Rate this:
  1. Rajesh Goswami

    Post:85

    Points:425
    Concept of cursor in database?

    Cursors provide a mechanism by which a database client iterates over the records in a database. Using cursors, the client can get, put, and delete database records. Database programmers use cursors for processing individual rows returned by the database system for a query.

    Working with cursor:
    Syntax:
    Declare a cursor

    DECLARE cursor_name CURSOR FOR SELECT ... FROM ...

    Open a cursor

    OPEN cursor_name

    Fetch Cursor

    FETCH cursor_name INTO ...

    Close Cursor
    CLOSE cursor_name




Answer

NEWSLETTER

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