Latest Tutorials| Questions and Answers|Ask Questions?|Site Map



Home Answers Viewqa SQL What is cursors?

Have Programming Question? Ask it here!
 
 
 


hemant kumar
What is cursors?
1 Answer(s)      3 years and 10 months ago
Posted in : SQL


What is cursors?


Advertisement
View Answers

November 18, 2010 at 3:31 PM


Hi,

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:

1- Declare cursor

2- Open cursor

3- Fetch row from the cursor

4- Process fetched row

5- Close cursor

6- Deallocate cursor

Thanks,



Related Tutorials/Questions & Answers:
Advertisements
Advertisements
 

 

 

DMCA.com