answersLogoWhite

0

The purpose of a cursor in a database is to provide an option to the programmer using which he/she can iterate through the contents of a table one record at a time and use it for processing. A sample cursor can be created using the below statement

DECLARE cursor_employee CURSOR FOR SELECT * FROM tbl_employee_info

The above cursor cursor_employee will contain the contents of the table tbl_employee_info and can be used by the programmer for manipulation one record at a time.

A Cursor may act like a DataStructure . it stores the record coming from the base table . in if we want ot retrive the date very fastly we will user cursors.

User Avatar

Wiki User

14y ago

What else can I help you with?