interview

home / developersection / interviews / concept of cursor in database?

Ask Question

Concept of cursor in database?

Anonymous User 2407 20-Oct-2010

mssql server

Updated on 23-Sep-2020

Anonymous User

Other

I am a content writter !

Message

Can you answer this question?

Answer

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

interview

Concept of cursor in database?

Anonymous User

Can you answer this question?

1 Answers

Liked By