Question

What is a CURSOR and what is its use?

Answer 1

A CURSOR is a programming device that helps the SELECT statement find out a set of rows but displays them one at a time. This is because the host language can deal with only one row at a time.