CONCEPT OF CURSOR IN DATABASE?

Monaj Singh

Total Post:0

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

    Post:84

    Points:420
    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

      Modified On Mar-26-2018 04:58:19 AM

Answer

NEWSLETTER

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