1.

What Is Cursor?

Answer»

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:

  • Declare cursor,
  • Open cursor,
  • Fetch row from the cursor,
  • Process FETCHED row,
  • Close cursor,
  • Deallocate cursor.

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:


Discussion

No Comment Found

Related InterviewSolutions