Concept of cursor in database?

Anonymous User 2680 20 Oct 2010

1 Answers

Rajesh Goswami 09 Nov 2010

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

Markdown for AI

A clean, structured version of this page for AI assistants and LLMs.

Open .md

interview

Concept of cursor in database?

Can you answer this question?

1 Answers